ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

PDT Errors with SQLCA Message Display

book

Article ID: 237486

calendar_today

Updated On:

Products

Detector for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

A -204 SQL error code is displayed in Detector, but unable to view the SQLCA display message when using Detector. The panel where this error is displayed below. 

20.0    >   --------- DETECTOR SQL Error Detail Display -------- 12-15-21 07:57
Command ==>                                                     Scroll ==> PAGE
                                                                    LINE 1 OF 1
SQLcode ==> -204            SQLstate ==> 42704              DB2 SSID ==> D401  
Opid    ==> DBM1DNN         Planname ==> DSNESPCS           Connid ==> TSO     
                                                                               
Interval Time ==> 01:00                           Interval Elapsed ==> 03:40.32
-------------------------------------------------------------------------------
                                                                               
S -SQLCA Message Display, Q -SQL Call Text, D -View Detail                     
                                                                               
    PROGRAM   TYPE  SQL_CALL  STMT#   SECT#  DATE      TIME      AUTHID        
    --------  ----  --------  ------- -----  --------  --------  --------      
s   DSNESM68  PKGE  PREPARE       190     1  12-15-21  07:54:18  DBM1DNN       
******************************* BOTTOM OF DATA ********************************
                                                                               

Curious if there is a parameter/parm that need to be updated in order to get around this issue.

 

Environment

Release : 20.0

Component : Detector for DB2 for z/OS

Resolution

The problem was recreated by removing the SSID from the SETUP global Parmlib Member. Check SETUP Global Parmlib member and verify that it contains the information for SSID D401 and its CDBALOAD parameter contains the correct load libraries. Here is a link to the documentation with more information on the SETUP Global Parmlib Member.