Retrieving catalog information about partition order
The LOGICAL_PART column in the SYSIBM.SYSTABLEPART table contains information for key order or logical partition order.
Procedure
Query the SYSIBM.SYSTABLEPART table.
The
following statement displays information on partition order in ascending
limit value order:
SELECT LIMITKEY, PARTITION
FROM SYSIBM.SYSTABLEPART
ORDER BY LOGICAL_PART;