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.
SAP Knowledge Base Article - Preview