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

HWM on Reorg Questioned

P: n/a
Hi All -

OSName: AIX
NodeName: dr_aixdb01
Version: 5
Release: 3

dr_aixdb01$db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release
"SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and
FixPak
"14".
Product is installed at "/usr/opt/db2_08_01".

---------------

We're bringing this database in-house from a hosting service. I want
to ensure that once we get it here that it is well organized, etc. I
would like to see a well-sized set of tablespaces and so I'm running
some tests on reorg, etc. to help determine the optimal size for each
TS.

I've been testing with one table in tablespace TIVA_CANCEL_DT named
tivadsn.tiva_cancel. I do an offline reorg and get n value for HWM.
I do another offline reorg and get x value for HWM. Everytime I reorg
I get the previous HWM....they flip-flop in what I consider
'interesting' behavior. The INPLACE reorg doesn't exhibit this flip-
flop behavior as the offline reorg does.

Thoughts?

-B

--------------

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 221232
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 110640
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 221232
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 110640
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

inplace reorg here <<<===== <<<=====

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 110640
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 221232
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000

dr_aixdb01$db2 reorg table tivadsn.tiva_cancel <<<===== <<<=====
DB20000I The REORG command completed successfully.

Tablespace ID = 10
Name = TIVA_CANCEL_DT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 222528
Useable pages = 222496
Used pages = 110640
Free pages = 111856
High water mark (pages) = 110640
<<<===== <<<=====
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 128
Number of containers = 2
Minimum recovery time = 2008-01-16-23.36.16.000000
Mar 12 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.