DT160I: Related SQL call text could not be located.

book

Article ID: 8228

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

User gets DT160I: Related SQL call text could not be located In Detector Table SQL Activity Display when trying to display SQL text

Environment

Release:
Component: PDT

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 )