Thanks, that worked very well. Had a runstats scheduled, waited until it
was complete. The only other thing was the query on cardf had to be cast
as a decimal.Only way to get the data. Again, Thanks!
Clay White
Database Administrator IV
Phone: 512-424-5113
Cell: 512-470-1099
E-mail: Clay.[Email address protected]
-----Original Message-----
From: Suresh
[mailto:db2udbdba-ezmlmshield-x93977886.[Email address protected]
Sent: Monday, November 20, 2006 3:14 PM
To: LazyDBA Discussion
Subject: Re: Determine Partitions in Use
I no longer work on z/OS side but here is one way of doing it...
1. do runstats on the tablespace.
2. "select partition,cardf from sysibm.systablepart where
tbname='your-table' "
Hope this helps. By the way db2/luw got a better way of doing it using
the functions 'partition' and 'nodenum' :)
Suresh G.
"White Clay " <db2udbdba-ezmlmshield-x71034963.[Email address
protected]
11/20/2006 02:44 PM
To
"LazyDBA Discussion" <[Email address protected] cc
Subject
Determine Partitions in Use
Hopefully, this will be quick. Have a group of partitioned tablesapces
in DB2 V 7 for z/OS. Nothing but the newest and best. I haven't been
able to find the syntax to check number of rows for in each partition to
determine the ditribution. If anyone has an idea or the syntax, would be
greatly appreciated.
Thanks,
Clay White
Database Administrator IV
Phone: 512-424-5113
Cell: 512-470-1099
E-mail: Clay.[Email address protected]
---------------------------------------------------------------------
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
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's
reserves the right to retrieve and read any message created, sent and
received. Kohl's reserves the right to monitor messages to or from
authorized Kohl's Associates at any time without any further consent.
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page