row count by partition in IQ 16

[Former Member]

Is there a system table or tables that I can use to obtain the number of rows that each partition in an IQ table has. 

[Gisung]

Hi,

Here are partition related system table.

But there are no system tables that include the number of rows that each partition.

ISYSPARTITION	One row for each range subpartition of a hash-range partitioned table. Because Hash partitions are logical rather than physical objects, ISSYPARTITION will not contain any rows for hash partitions of hash partitioned table or hash-range partitioned table. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITION System View for details.
ISYSPARTITIONKEY*	One row for each column of a partition key. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONKEY System View for details.
ISYSPARTITIONSCHEME	One row for each hash partitioned table and each hash-range partitioned table. The hash function and the number of hash partitions per table is fixed for the database and is not stored as part of this table. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONSCHEME System View for details.

Regards,

Gi-Sung Jang