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.


DB2 & UDB email list listserv db2-l LazyDBA home page