How did you run reorg online or offline?
Use reorg command with "USE" keyword and specify any SMS tablespace
which had good space to hold reorg.
Even if it does not lower the high water mark pages, try using DB2DART
utility with exclusive connection to db.
Regards
Rajesh
-----Original Message-----
From: Louw Philip P
[mailto:db2udbdba-ezmlmshield-x8693487.[Email address protected]
Sent: Thursday, May 24, 2007 7:02 AM
To: LazyDBA Discussion
Subject: Reorg not releasing expected space.
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
________________________________________________________________________
___________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.
--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.
DB2 & UDB email list listserv db2-l LazyDBA home page