Professional Web Applications Themes

Help -- I need your feedback about table REORG! - IBM DB2

Has anyone gotten the above view to work? When I run it, it reports that all of my tables have "**-" as their reorg status. Thanks, -Roger -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default Re: Help -- I need your feedback about table REORG!


    Has anyone gotten the above view to work? When I run it, it reports that
    all of my tables have "**-" as their reorg status.

    Thanks,
    -Roger

    --
    Posted via [url]http://dbforums.com[/url]
    rogert Guest

  2. #2

    Default Re: Help -- I need your feedback about table REORG!

    Roger,

    the above SQL just does the REORGCHK ONLY for tables WITH Indexes
    because of the inner join in the statement. You may want to change it
    to a left outer join if this makes sense for you. I just tried it with
    the left outer join, send me a note if you need the statement.

    cheers
    Florian




    rogert <member28856dbforums.com> wrote in message news:<3226840.1060638671dbforums.com>...
    > Has anyone gotten the above view to work? When I run it, it reports that
    > all of my tables have "**-" as their reorg status.
    >
    > Thanks,
    > -Roger
    florian Guest

Similar Threads

  1. Question add records to access table using adobe flash feedback form
    By Unregistered in forum Web Design
    Replies: 0
    Last Post: August 23rd, 04:03 AM
  2. index length and reorg - help need
    By filler in forum IBM DB2
    Replies: 0
    Last Post: September 10th, 09:19 AM
  3. Replies: 2
    Last Post: August 12th, 07:55 AM
  4. Clarfication on reorg of critical dbspace...
    By Rajasekaran, Rajesh in forum Informix
    Replies: 5
    Last Post: July 31st, 01:01 PM
  5. Difference between Reorg e consistency check
    By Stefano in forum IBM DB2
    Replies: 0
    Last Post: July 22nd, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139