The first time round I used thoe inplace reorg
With an onffline reorg the used pages were lowered.
What is the use of the inplace reorg ?
-----Original Message-----
From: RAJESH CHANDRAMOHAN [mailto:chandramohan.[Email address protected]
Sent: Thursday, May 24, 2007 1:11 PM
To: Louw, Philip P
Subject: RE: Reorg not releasing expected space.
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text
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
[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.
__________________________________________________________________________________________________________________________________
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