Don't know on z/OS, but on UNIX I use:

select count(*),
dbpartitionnum(MBRH_MBR_HUB_ID)
from pds.MBRH_MBR_HUB
group by dbpartitionnum(MBRH_MBR_HUB_ID)
order by 2
with ur
;

The MBRH_MBR_HUB_ID is the PK column, not that it matters. Good luck!
EB





"White Clay " <db2udbdba-ezmlmshield-x71034963.[Email address protected]
11/20/2006 12: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



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