All,
Generic - db2 list tablespaces show detail
Customised -
select distinct substr(a.tablespace_name,1,20) as tbsp_name,
case
when a.tablespace_type = 0 then 'DMS'
when a.tablespace_type = 1 then 'SMS'
else '??'
end as type,
substr(char(a.page_size),1,8) as pg_size,
substr(char(sum(a.total_pages)),1,15) as total,
substr(char(sum(a.usable_pages)),1,15) as usable,
substr(char(sum(a.used_pages)),1,15) as used,
substr(char(sum(a.free_pages)),1,15) as free,
substr(char(sum(a.high_water_mark)),1,15) as hgh_wt_mrk,
decimal(((decimal(sum(a.used_pages),12,2) /
decimal(sum(a.usable_pages),12,2)) * 100),5,2) as pct_used,
decimal(((decimal(sum(a.used_pages),12,2) *
decimal(sum(a.page_size),5,0)) / 1024/1024/1024),8,1) as space_used_GB
from table(snapshot_tbs_cfg(cast(NULL as char), -2)) as a
group by tablespace_name, tablespace_type, page_size
order by 9 desc;
Use the above sql and let me know if any queries.
Regards,
Rajesh Chandramohan
Offshore UDB DBA Team
180-066-62388 x 13311/37/97
Please note that the ODC UDB Operations work on a shift rotation basis,
therefore any ongoing communication generated from this e-mail should
have #ODC UDB or #DBA-UDB included in order to maintain a prompt
response.
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x4367687.[Email address protected]
Sent: Wednesday, February 20, 2008 6:10 AM
To: LazyDBA Discussion
Subject: Re: to know the status of table spaces and container
USE this:
get snapshot for tablespaces on
On Wed 20/02/08 4:19 PM , "Gaurav Raj " sent:
Hi all,
I need to know how much table space is utilized and how much space in
container is free corresponding to that tablespace Regards, Gaurav
Raj| APAC| Tech Mahindra A-7, Sector 64, NOIDA, UP, Pin : 201303, INDIA
Cell: 9953138624
Email: gaurav.[Email address protected] www.techmahindra.com
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at
http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com
/Disclaimer.html
[3] externally and http://tim.techmahindra.com/Disclaimer.html [4]
internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a dba job: http://jobs.lazydba.com [5] To Subscribe :
http://www.LazyDBA.com [6] To unsubscribe:
http://www.lazydba.com/unsubscribe.html [7]
Links:
------
[1]
http://192.168.14.11/parse.php?redirect=dhtmled1%3A%2F%2Fexchweb%2Fbin%2
Fredir.asp%3FURL%3Dhttp%3A%2F%2Fwww.techmahindra.com%2F
[2]
http://192.168.14.11/parse.php?redirect=dhtmled1%3A%2F%2Fexchweb%2Fbin%2
Fredir.asp%3FURL%3Dhttp%3A%2F%2Fwww.techmahindra.comTEAM
[3] http://192.168.14.11/<a target=
[4] http://tim.techmahindra.com/Disclaimer.html
[5]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[6]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[7]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Fu
nsubscribe.html
Disclaimer: This communication is for the exclusive use of the
intended recipient(s) and shall not attach any liability on the
originator or ITC Infotech India Ltd./its Holding company/ its
Subsidiaries/ its Group Companies. If you are the addressee, the
contents of this e-mail are intended for your use only and it shall not
be forwarded to any third party, without first obtaining written
authorization from the originator or ITC Infotech India Ltd./ its
Holding company/its Subsidiaries/ its Group Companies. It may contain
information which is confidential and legally privileged and the same
shall not be used or dealt with by any third party in any manner
whatsoever without the specific consent of ITC Infotech India Ltd./
its Holding company/ its Subsidiaries/ its Group Companies.
---------------------------------------------------------------------
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