DB2 Partition Range: How to View Limits

You can use the following command to view the range of partitions allowed to be created in DB2.

SELECT PARTITION_RANGE_START, PARTITION_RANGE_END
FROM SYSCAT.DBPARTITIONGROUPS
WHERE DBPARTITIONGROUPNAME = '<分区组名称>';

In the command above, replace with the actual partition group name, and then execute the command to view the range of partitions allowed to be created in that partition group.