HWM on Reorg Questioned

bwmiller16

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

Subscribe Post Reply

2187

Similar topics

Reorg on UDB

by: Raquel | last post by:

This question if for UDB on LUW. Suppose I take regular database backups of my database Monday: database backup <ts1> Tuesday: Tablespace reorged and imagecopied <ts2> Friday: database...

DB2 Database

DB2 UDB V8 inplace reorg

by: Anna Hutter | last post by:

Hello, this question is about DB2 UDB V8 and its inplace reorganisation. It seems that in small tables, an inplace reorg doesn´t start. Is there a limit in size of a table when a reorg starts?...

DB2 Database

Online reorg and super exclusive lock cause many problems

by: Lara | last post by:

Hello freaks, we have many problems with our online reorg and no idea how to resolve it. We had to do an online reorg beacause of 24 h online business. We start the reorg-statements (table by...

DB2 Database

Reorg table/index questions

by: TomHorner | last post by:

I have several quick questions about reorg's, and a request (favor). 1. The documentation says that reorg "Reorganizes an index or a table" I cannot see how one would reorg ONE particular index...

DB2 Database

reorgchk reorg interpretation

by: hikums | last post by:

1. I did a reorgchk, and found that F2 on table and F4 on index indicates a reorg is necessary. 2. Did a reorg. 3. Again I do a reorgchk, the report is the same as in Step 1 4. I do a...

DB2 Database

ONLINE REORG

by: andy.standley | last post by:

Hi, we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to set the reorg to be online. I use the control center on the box - db2cc and then configure automatic maintenance wizard -...

DB2 Database

Load utility vs reorg

by: Yuri | last post by:

We have an update sql that was running OK for several months completing in under 2 minutes . Yesterday something changed and we had to kill this update after it ran more than 6 hours. Update input...

DB2 Database

Reorg Not Reclaiming Anticipated Space

by: mike_dba | last post by:

I am using DMS raw. I have a tablespace which is defined with 5 containers each allocated at 1.5 GB for a total of about 7.5 GB. I did a major deletion followed by a reorg and a runstats. I am...

DB2 Database

Seemingly Successful Inplace Reorg returns -1 Completion Status

by: sethwai | last post by:

Hi, I have a nightly script that executes inplace reorgs allow write access for several tables after a previous script does a large number of delete operations. It usually has been executing...

DB2 Database

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA