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.