SAP Knowledge Base Article - Preview

3565700 - DB6: "SQLCA has already been built" in db2diag log

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

SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

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.