how to identify the records in a particular partition

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

We are having a DB2 table with 64 partitions, i want to know the number of records in each partition, could any body help me how to write a
query to identify the number of records in each partition?

thanks,
Nagendran.R

plkanth_526 · New User Joined: 01 Jun 2008 Posts: 7 Location: Bangalore

You can get the information from RTS tables.Please use the below query to get the number of rows present partition wise.

SELECT TOTALROWS
FROM "SYSIBM".TABLESPACESTATS
WHERE
DBNAME = 'xxxx'
NAME = 'xxxx '
PARTITION = xx with ur;

am_ne · New User Joined: 24 Mar 2007 Posts: 25 Location: Bangalore

Hi,

If RTS tables are not enabled then you have to know the partitioning logic.

The partitioning logic of the table based on values of one/multiple column.
Once you know the partitioning column name and the maximum values for your partitions, you can write the query easily.

Thanks,
Amit