Hi
We have 4k Tablespace that is nearing the 64gig limit. There are only
two tables in the tablespace. A very small Codes table and an events
table.
To avoid running out of space we deleted about 60% of the rows out of
the events table.
A reorg was run on the table, but no pages were freed up.
How can I see the amount of pages freed up .
The out of list tablespaces show detail before and after the reorg
Before:
Tablespace ID = 4
Name = PRD_EV_DAT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 15976876
Useable pages = 15975936
Used pages = 14952960
Free pages = 1022976
High water mark (pages) = 14952960
Page size (bytes) = 4096
Extent size (pages) = 128
Prefetch size (pages) = 512
Number of containers = 4
Minimum recovery time = 2005-03-08-13.23.35.000000
After:
Tablespace ID = 4
Name = PRD_EV_DAT
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 15976876
Useable pages = 15975936
Used pages = 14952960
Free pages = 1022976
High water mark (pages) = 14952960
Page size (bytes) = 4096
Extent size (pages) = 128
Prefetch size (pages) = 512
Number of containers = 4
Minimum recovery time = 2005-03-08-13.23.35.000000
Regards
Philip
__________________________________________________________________________________________________________________________________
Standard Bank Disclaimer and Confidentiality Note
This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited
and/or its subsidiaries ("the Group"). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by
mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions
expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or
damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity
of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS).
For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za
___________________________________________________________________________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page