database reorg

[Harold Pritchett]

I have a v8.2 db2 server (FixPak 7a) running on
RedHat Enterprise linux v3 (2.4.21-37.ELsmp kernel)

Currently there is one database which appears to
badly need reorganization. I'm new to this whole
DBA thing and need to find a database reorg primer
somewhere that will give me the info I need to repair
my database.

I have run reorgchk against the database and am not
sure what the output means. I'm not going to post
all 1200 lines here, but what do things like
*--, *-*, -**, or *----, ----*, ---*-, -**--, *-*--,
--*-*, or -***- mean???

Harold

[Phil Sherman]

One of the best ways to get information about the results of a command
(REORGCHK) is to read the Command Reference manual. It contains a full
explanation of each of the output columns in the report.

Two reports are produced, one for tables and one for indexes. The last
column of each contains flags which indicate which of the statistics
lies outside of the "is OK" range of values. Those outside, indicating
that REORG would be useful are indicated with an "*", while the
statistics lying inside acceptable ranges are shown by a "-".
Phil Sherman


Harold Pritchett wrote:

I have a v8.2 db2 server (FixPak 7a) running on
RedHat Enterprise linux v3 (2.4.21-37.ELsmp kernel)

Currently there is one database which appears to
badly need reorganization. I'm new to this whole
DBA thing and need to find a database reorg primer
somewhere that will give me the info I need to repair
my database.

I have run reorgchk against the database and am not
sure what the output means. I'm not going to post
all 1200 lines here, but what do things like
*--, *-*, -**, or *----, ----*, ---*-, -**--, *-*--,
--*-*, or -***- mean???

Harold