BPFIX


BPFIX is a Data Collector command that you can use to request page fix analysis of a specific buffer pool or all buffer pools. All analysis output is directed to SYSTSPRT.

image2021-6-23_12-0-14.png

Parameter

Description

DCssid

Subsystem ID of the Data Collector for which the command reports the status

Use this parameter only when you issue the command from the console. When you issue the command from the Data Collector Command Interface panel, it automatically applies to the currently selected Data Collector.

DB2ssid

ID of the Db2 subsystem for which you are enabling or disabling analysis

bpid

Triggers a one-time analysis of the indicated buffer pool on the next background analysis cycle

ALLON

Enables daily analysis of the top 10 I/O-intensive buffer pools in the specified Db2 subsystem, with an individual analysis of each buffer pool daily at 12:00 A.M. (midnight)

ALLOFF

Disables daily analysis of buffer pools

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*