db2udbgirl wrote:
Table level snapshot showed me a entry as below
Table Schema = CARD
Table Name = DEALER
Table Type = User
Data Object Pages = 3480
Index Object Pages = 2622
Rows Read = 6570376
Rows Written = 0
Overflows = 157542
Page Reorgs = 0
So I did an reorgchk and it showed me entries as below
...
Hence I ran the following 2 commands manually
1) db2 runstats on table card.dealer and
2) db2 reorg table card.dealer
Both completed successfully but still tablesnapshot shows an Overflow.
...
May I know how to resolve this problem.
Solving an overflow problem usually involves both a REORG and a review
of the application -- i.e. why did you get overflows in the first place?
Is it because the app inserts a record with NULL or very short strings
into the VARCHAR fields and then goes back and UPDATEs the VARCHARs with
longer string values? Is PCTFREE too small?
So, find the source of the problem, otherwise you'll be running REORG on
a regular basis to try and get rid of overflows.