Not collecting IDB2 Acct Rec SQL History

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

Issue/Problem/Symptoms: 

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

R/HTIDBSUM

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.

Resolution/Workaround:

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