Sysview Performance Management Option (IDB2) getting message SQL text database not available
search cancel

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

book

Article ID: 145170

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Sysview Performance Management Option for Db2 for z/OS (IDB2) error trying to get SQL Text in ssid: SQL text database not available.
This is a Db2 12 subsystem using Database Management tools r20.

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.

Resolution

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