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).
Release : 20.0
Component : CA Insight Database Performance Monitor for DB for z/OS