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.