DT160I: Related SQL call text could not be located.

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

User gets DT160I: Related SQL call text could not be located In Detector 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 hasr ran the required GRANT's as documented in highlvl.CDBASRC member PDTSQTGR and recycled the Xmanager Started Task DB2 authorization ID:           

12.32.01 STC08883 PDT0220 PKGESQLT DB2=DB2D PKGE=MUTL0093 REQ=PREPARE SQLCODE= -551 

780 DB2D.SYSIBM.SYSPACKSTMT.SELECT CL(MDSNTB ) 

780 INSUFFICIENT ACCESS AUTHORITY 

780 FROM DB2D.**.SELECT (G) 

780 ACCESS INTENT(READ ) ACCESS ALLOWED(NONE ) 

12.32.05 STC08883 ICH408I USER(CADB2 ) GROUP(STARTASK) NAME(USUARIO CADB2 ) 782 

12.32.05 STC08883 PDT0220 PKGESQLT DB2=DB2D PKGE=MUTL0093 REQ=PREPARE SQLCODE= -551 

782 DB2D.SYSIBM.SYSPACKSTMT.SELECT CL(MDSNTB ) 

782 INSUFFICIENT ACCESS AUTHORITY 

782 FROM DB2D.**.SELECT (G) 

782 ACCESS INTENT(READ ) ACCESS ALLOWED(NONE )