Not collecting IDB2 Acct Rec SQL History

Document ID : KB000043989
Last Modified Date : 14/02/2018
Show Technical Document Details


We are no longer collecting SQL history for work coming through DB2 Connect on z/Linux


There is no CA-Insight accounting record for this data.

This could be due to one of the following:

1. The data collector is not collecting CA-Insight accounting data.
One or more trace options must be enabled in the HIST-ACCT-DETAIL
SYSPARM setting.

2. No detail trace data was collected for any of the options
enabled in the HIST-ACCT-DETAIL SYSPARM setting.

You can use the INS HISTORY command to view the current detail
IDB2 accounting record trace options that are enabled.


Insight does not capture dynamic SQL from DB2 Connect. We are able to find it in the Dynamic Statement Cache,