Why am I getting a "RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT" in the db2diag.log?

IBM Support

Why am I getting a "RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT" in the db2diag.log?

Question & Answer

Question

Why am I getting a "RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT" in the db2diag.log?

Cause

For example:

2016-04-14-04.21.18.340872-240 I761101518E544 LEVEL: Warning
PID : 27757 TID : 46934089787136 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48357 APPID: *****.****.*****
AUTHID : ***** HOSTNAME: ****
EDUID : 454 EDUNAME: db2agent (AC_LOAD) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, probe:35
RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
"SQLCA has already been built"

Answer

Typically a SQLZ_CA_BUILT message is informational.

The SQLCA will return the first warning or error encountered (if an error is encountered after a warning, the error takes precedence).
Any subsequent warnings/errors will result in messages like the one pasted above.

These messages can be ignored.

This message just indicates that there was an attempt to build the SQLCA structure (access plan manager) but it was already built.

The function dumping the message was the sqlrl_userTempGetInfo (DB2 looking for Declared Global Temporary Table information).
After a crash the DGTT might not be available anymore so the users can get a message per application that was using the table
if you had many applications you may get a lot of this entries. Usually DB2 cleans all those messages once the information is loaded
again the the bufferpools and memory etc.