"SQLCA has already been built"

Posted by Pawan at April 08. 2008

Hi,

I am seeing below error in db2diag.log file.Whats this and how to remove???

Its urgent plz.

db2diag -time 2008-04-07-00.00.00.230520| db2diag -g instance=carsdb |db2diag -l error
2008-04-07-13.24.27.944754+330 I12982248G433      LEVEL: Error
PID     : 13696                TID : 3086546624 PROC : db2agent (EVENTXML) 0
INSTANCE: carsdb               NODE : 000         DB   : EVENTXML
APPHDL : 0-56                 APPID: *LOCAL.carsdb.080407075232
FUNCTION: DB2 UDB, runtime interpreter, sqlricls_complex, probe:140
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
          "SQLCA has already been built"

2008-04-07-13.24.28.039721+330 I12982682G989      LEVEL: Error
PID     : 13696                TID : 3086546624 PROC : db2agent (EVENTXML) 0
INSTANCE: carsdb               NODE : 000         DB   : EVENTXML
APPHDL : 0-56                 APPID: *LOCAL.carsdb.080407075232
MESSAGE : Reporting -1476; old SQLCA:
DATA #1 : Hexdump, 136 bytes
0xB7F4FCE4 : 5351 4C43 4120 2020 8800 0000 DFFC FFFF    SQLCA   ........
0xB7F4FCF4 : 0000 2020 2020 2020 2020 2020 2020 2020    ..
0xB7F4FD04 : 2020 2020 2020 2020 2020 2020 2020 2020
0xB7F4FD14 : 2020 2020 2020 2020 2020 2020 2020 2020
0xB7F4FD24 : 2020 2020 2020 2020 2020 2020 2020 2020
0xB7F4FD34 : 2020 2020 2020 2020 5351 4C52 4930 3638            SQLRI068
0xB7F4FD44 : 4900 1680 4900 0000 0000 0000 0000 0000    I...I...........
0xB7F4FD54 : 9CFF FFFF 0000 0000 2020 2020 2020 2020    ........
0xB7F4FD64 : 2020 2020 2020 2020

Thanks

Pawan

Re: "SQLCA has already been built"

Posted by perallis at April 08. 2008

Possible workarounds:

change the table cardinality. Cardinality might get DB2 to switch from a right outer hash join to a nested-loop join. This would avoid the problem.

DBM CFG "INTRA_PARALLEL=NO". Running without INTRA_PARALLEL will also avoid it, but this will effect performance of some queries.

"SET CURRENT DEGREE = '1'" for dynamic SQL or DEGREE for static SQL. Switching the degree of a query to 1 will force DB2 to not parallelize the query.

"db2set DB2_HASH_JOIN=NO". This will disable hash join, but that can impact performance of other queries too.

rewrite the query to not contain right outer join.

Pawan, please tell us what is the fix pack you are using.

if the fixpack be less than 11, try to apply the fixpack more than 11 in Version 8

And post here if some solution above helped you!

Thanks!

Re: "SQLCA has already been built"

Posted by Pawan at April 09. 2008

thanks ....

we are using fix pack 9.

Re: "SQLCA has already been built"

Posted by Pawan at April 09. 2008

"DB2 v8.1.2.89", "OD_14086", "MI00117_14086", and
FixPak "9".

Re: "SQLCA has already been built"

Posted by perallis at April 09. 2008

So, try to apply the fixpack 12!

DBA to DBA

Personal tools

Document Actions

"SQLCA has already been built"