What is the 'partnum' and what does it means?

Question

In some onstat/oncheck outputs and systables table there is information about the 'partnum'. What is the 'partnum' and what does it means?

Answer

The partition number (partnum) contains information about a table.

It is 4-byte hexadecimal value (0x12345678) that is composite of two values, the most significant 3 digits indicates which dbspace contains the table (tblspace) and the least 5 significant digits indicates the logical page number that contains information about the table.

It means that 0x123 indicates which dbspace contains the table and 0x45678 indicates a logical page number that keeps information about the table.

For example, if the partnum of table customer is 0x0050015f, it means that dbspace 5 (0x005) contains the table and the logical page 0x0015f keeps information about the customer table.

Note 1: The 'tblsnum' in 'onstat -k' and 'tblnum' in 'onstat -t/-T' corresponds to the part number (partnum) of the table.

Note 2: The value of partnum stored in systables and reported in oncheck -pt is a decimal value, you need to convert it to hexadecimal in order to get the information of which dbspace contains the table and the logical page that keeps information of the table.