onstat -g ppf command: Print partition profiles

Use the onstat -g ppf partition_number command to display the partition profile for the specified partition number.

Use the onstat -g ppf or the onstat -g ppf 0 command to display the profiles for all partitions. If the TBLSPACE_STATS configuration parameter is set to 0, then the onstat -g ppf command displays: Partition profiles disabled.

For more information on the onstat -g ppf command, see the HCL OneDB™ Performance Guide.

Figure 1: Syntax:

1  onstat   -g ppf
2.1 partition_number
2.1 0

Example output

Figure 2: onstat -g ppf command output
Partition profiles
partnum    lkrqs lkwts dlks  touts isrd  iswrt isrwt isdel bfrd  bfwrt seqsc rhitratio
0x100001   0     0     0     0     0     0     0     0     0     0     0     0 
0x100002   1506  0     0     0     416   4     0     4     1282  20    0     97
0x100003   15    0     0     0     5     0     0     0     20    0     0     75
0x1000a5   0     0     0     0     0     0     0     0     12    0     0     67
0x1000e3   4     0     0     0     1     0     0     0     4     0     0     25
0x200001   0     0     0     0     0     0     0     0     0     0     0     0
0x300001   0     0     0     0     0     0     0     0     0     0     0     0
0x400001   0     0     0     0     0     0     0     0     0     0     0     0  

Output description

partnum (hex)
The partition number
lkrqs (decimal)
The number of lock requests for a partition
lkwts (decimal)
The number of lock waits for a partition
dlks (decimal)
The number of deadlocks for a partition
touts(decimal)
The number of remote deadlock timeouts for a partition
isrd (decimal)
The number of read operations for a partition
iswrt (decimal)
The number of write operations for a partition
isrwt (decimal)
The number of rewrite or update operations for a partition
isdel (decimal)
The number of delete operations for a partition
bfrd (decimal)
The number of buffer read operations, in pages
bfwrt (decimal)
The number of buffer write operations, in pages
seqsc (decimal)
The number of sequential scans for a partition
rhitratio (percentage)
The ratio of disk read operations to buffer read operations