SAP Knowledge Base Article - Preview

3278552 - DB2: SQLCODE = -204 SAPR3.DB2QCLTRC is an undefined name

Symptom

After unicode conversion and SAP system upgrade, you get following issues:

  • Symptom 1

    Transaction code "dbacockpit" returns error: Table SAPR3.DB2QCLREQ not found in DB2 catalog.

  • Symptom 2

    SAP collector setup fails at step "Create Tables".

    Error calling SAPCL 20221122 123456  DB2-call 'PREPARE' failed: sqlcode 
    = -204 (SAPR3.DB2QCLTRC) 20221122 123456  SQL statement: 20221122 123456
    CONNECT  20221122 123456   DSNT408I SQLCODE = -204, ERROR:  
    SAPR3.DB2QCLTRC IS AN UNDEFINED NAME                                    
    DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE                        
    DSNT415I SQLERRP    = DSNXOTL SQL PROCEDURE DETECTING ERROR

In the SAPCL trace (Directory: "/u/<sid>adm/sapcl_trace/" on the z/OS USS side), it gives error "Invalid DB2 version C1"

start trace 20221122123456
CLERR (00) 20221122 123456   DB2-call 'PREPARE' failed: sqlcode = -204 (SAPR3.DB2QCLTRC)
CLERR (00) 20221122 123456   SQL statement:
CLERR (00) 20221122 123456   CONNECT
CLERR (00) 20221122 123456   DSNT408I SQLCODE = -204, ERROR:  SAPR3.DB2QCLTRC IS AN UNDEFINED NAME                                                          
                                               DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE                                                                                
                                               DSNT415I SQLERRP    = DSNXOTL SQL PROCEDURE DETECTING ERROR                                                                                                                              
CLERR (00) 20221122 123456  Invalid DB2 version C1.
stop trace: 20221122 123456


Read more...

Environment

  • SAP Netweaver 7.5
  • SAP Kernel 7.53
  • Db2 on z/OS 12.1.5
  • SAPCL Release 720

Keywords

DB2QCLREQ, DB2 catalog, SQLCODE = -204, DB2QCLTRC, Invalid DB2 version C1

, KBA , BC-DB-DB2-CCM , DB2 for z/OS - CCM/Database monitors , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.