Statistical information type (-k option specification) | Type of statistical information output | Statistical information output trigger |
---|
sys | Statistical information on system operation | Statistical information is output at the interval specified in the -m option. |
uap | Statistical information on UAPs | Statistical information is output during connection to and disconnection from HiRDB. |
sql | Statistical information on SQLs | Statistical information is output when SQL execution starts and ends. |
buf | Statistical information on global buffers1 | Statistical information is output at synchronization points. |
fil | Statistical information on HiRDB files related to database manipulations |
dfw | Statistical information on deferred write processing |
idx | Statistical information on indexes |
sop | Statistical information on SQL static optimization | Statistical information is output when no hit occurs on an SQL object buffer during preprocessing of a dynamic SQL or static SQL. |
dop | Statistical information on SQL dynamic optimization | Statistical information is output when an SQL statement other than FETCH or CLOSE is executed. |
pcd | Statistical information related to SQL object execution | Statistical information is output when an SQL object is executed. |
sqh | Statistical information on SQL statement statistics2 | Statistical information is output during PREPARE and when an embedded SQL is executed. |
obj | Statistical information on SQL object transmission3 | Statistical information is output when an SQL object is executed. |
fsv | Statistical information on foreign server option3 | Statistical information is output when a transaction is terminated. |
hba | Statistical information on foreign server usage3 | Statistical information is output when an SQL statement is executed for a foreign server. |