DT160I Related SQL call text could not be located within Detector for Db2

Products

• Detector for DB2 for z/OS

Issue/Introduction

DT160I Related SQL call text could not be located in Detector for Db2 for z/OS (PDT) Table SQL Activity Display when trying to display SQL text.

Resolution

This is a security issue due to the use of Db2 External Security as shown below even though user has executed the required GRANTs
as documented in hlq.CDBASRC member PDTSQTGR and recycled the Xmanager Started Task:        
  

STCnnnnn PDT0220 PKGESQLT DB2=ssid PKGE=<package> REQ=PREPARE SQLCODE= -551 

ssid.SYSIBM.SYSPACKSTMT.SELECT CL(xxxxx ) 

INSUFFICIENT ACCESS AUTHORITY 

FROM ssid.**.SELECT (G) 

ACCESS INTENT(READ ) ACCESS ALLOWED(NONE ) 

STCnnnnn ICH408I USER(<xmanager authid>) GROUP(<group name>) NAME(<name> ) 

STCnnnnn PDT0220 PKGESQLT DB2=ssid PKGE=<package> REQ=PREPARE SQLCODE= -551 

ssid.SYSIBM.SYSPACKSTMT.SELECT CL(xxxxx ) 

INSUFFICIENT ACCESS AUTHORITY 

FROM ssid.**.SELECT (G) 

ACCESS INTENT(READ ) ACCESS ALLOWED(NONE )