Symptom
Error message "SQLCA has already been built" (sqlcode: -1224) is found in the db2diag log file, which is under /db2/<SID/db2dump by default.
Example:
2025-01-05-16.02.29.645000+480 E411776753F1127 LEVEL: Error
PID : 9492 TID : 11216 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
APPHDL : 0-44091 APPID: *LOCAL.DB2ABC.250105080235
AUTHID : DB2ABC HOSTNAME: abc123
EDUID : 11216 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:870
MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
DATA #1 : String, 28 bytes
UCstate terminate bit is set
DATA #2 : Hexdump, 4 bytes
0x000000038ED32548 : 4001 0000
DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80040003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Read more...
Environment
- SAP on IBM Db2 for Linux, Unix and Windows
Product
Keywords
SQLCA, built, sqlcode: -1224, SQLR_CA_BUILT, UCstate, terminate , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , 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