onstat -g ppd command: Print partition compression dictionary information

Use the onstat –g ppd command to display information about the active compression dictionaries that were created for compressed tables and table fragments or compressed B-tree indexes. You can choose to print information for a particular numbered partition or for all open partitions.

The onstat –g ppd command prints the same information that the syscompdicts_full table and the syscompdicts view in the sysmaster database display. The only difference is that the syscompdicts_full table and the syscompdicts view display information about all compression dictionaries, not just the active dictionaries.

Figure 1: Syntax:

1  onstat   -g ppd
2.1?  partition number
2.1  0

If you specify a partition number, onstat -g ppd prints the partition profile for that partition. If you specify 0, this option prints profiles for all partitions.

Example output

Figure 2: onstat –g ppd Output
partnum    Version  DbsNum  CrTS         CrLogID  CrLogPos  DrTS   DrLogID  DrLogPos
0x200002   1        2       1229018150   3        577560    0      0        0
0x200003   1        2       1229018150   3        606232    0      0        0
0x300002   1        3       1229018150   3        630808    0      0        0
0x400002   1        4       1229018150   3        655384    0      0        0
0x500002   1        5       1229018150   3        679960    0      0        0
partnum    ColOffset  DbsNum    CrTS        CrLogID    CrLogPos  DrTS     DrLogID  DrLogPos
0x1001d5   -1         1         1393371661  4          16339024  0        0        0
0x1001d5   4          1         1393371661  4          16355408  0        0        0

Output description

partnum
Partition number to which the compression dictionary applies
Version
Version of the code that is creating the compression dictionary
ColOffset
The byte offset for a compressed partition blob column. -1 means that only the row is compressed
DbsNum
Number of the dbspace that the dictionary resides in
CrTS
Timestamp that shows when the dictionary was created
CrLogID
Unique ID for the logical log that was created when the dictionary was created
CrLogPos
Position within the logical log when the dictionary was created
DrTS
Timestamp that shows when the dictionary was purged
DrLogID
Unique ID for the logical log that was created when the dictionary was purged
DrLogPos
Position within the logical log when the dictionary was purged