By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

database reorg

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.