Reports

How do I identify if a table is partitioned?

SELECT 
  TABLE_NAME, 
  TABLE_SCHEMA, 
  PARTITION_TABLE 
FROM 
  QSYS2.SYSTABLES
WHERE 
  TABLE_SCHEMA = 'YOUR_SCHEMA' 
  AND
  TABLE_NAME = 'YOUR_TABLE';

How do I find out the number of partitions of a Table?

SELECT 
  count(*) as NUM_PARTITIONS
FROM 
  QSYS2.SYSPARTITIONDISK
WHERE 
  TABLE_SCHEMA = 'YOUR_SCHEMA' 
  AND
  TABLE_NAME = 'YOUR_TABLE';

How do I Write a Query to retrieve data from a Specific partition by providing a partition name or number reference?

SELECT A.*
FROM YOUR_TABLE A
WHERE DATAPARTITIONNAME(A) = 'PARTITION_NAME';

79134188