CA Sysview Performance Management Option (IDB2) getting message - SQL text database not available

Article Id: 145170
Status: Published
Updated On: 04-06-2020 12:20
Products:
CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS , CA Database Management for DB2 for z/OS - Performance Suite , CA Database Management for DB2 for z/OS - SQL Performance Suite , CA Detector for DB2 for z/OS , CA-Insight Performance Monitor for DB2 UDB for z/OS
Issue/Introduction:

Summary: Insight error trying to get SQL Text in DB2D: SQL text database not available.
This is a Db2 v12 using CA Tools R.20.

From Thread History, select a thread with Static SQL, 6 (more), 11 (Accounting Collection Data), 2 (SQL) then T select SQL Text (error on R/IQLSQLTX).
Get the message: SQL text database not available.

Similarly, the following process works fine:
From Thread History, select a thread with Dynamic SQL, 6 (more), 11 (Accounting Collection Data), 6 (Sort Sum) then T select SQL Text (no request name identified on this screen).
 

 

Cause:

The cause of this condition was determined to be a bug.

Environment:

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution:

PTFs SO12428 (IDB2) and SO12429 (PDT) have been published for r20 to correct this condition.