STEPS TO CHECK ALL THE TABLESPACE PARTITIONED ENTRIES
1. Tables are always defined in respective tablespaces
SELECT * FROM SYSIBM.SYSTABLES
WHERE NAME= 'MSG_RCVD'
WITH UR;
The tablespace for the mentioned table is TSMPR
----------------------------------------------------------------------------------------
2. The table space is partitioned by defining index on each partition with Limit keys.
SELECT * FROM SYSIBM.SYSTABLESPACE
WHERE NAME = 'TSMPR'
WITH UR;
The partition we get from here were
