DB2 FOR LUW / DB2FORLUW / 970 - DB2

When performing an ALTER TABLE statement, you may see the 
following message being logged in the db2diag.log. 
 
2010-01-20-10.14.58.818898+000 I19706865A600      LEVEL: Severe 
 
PID     : 401546               TID  : 13087       PROC : db2sysc 
0 
INSTANCE: db2inst3             NODE : 000         DB   : TESTDB 
APPHDL  : 0-36085              APPID: 
172.16.19.127.34832.10012010163 
AUTHID  : NEWTON 
 
EDUID   : 13087                EDUNAME: db2agent (TESTDB) 0 
 
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:990 
 
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT 
 
          "SQLCA has already been built" 
 
DATA #1 : String, 33 bytes 
 
Probe that returned non-zero rc: 
 
DATA #2 : unsigned integer, 4 bytes 
 
10000 
 
This message can be safely ignored so it shouldn't be logged as 
severe.

EXCESSIVE SQLZ_CA_BUILT MESSAGE MAY BE LOGGED IN DB2DIAG.LOG 
WITH SEVERE LEVEL DURING ALTER TABLE

N/A

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V9.7 FP2.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.02.2010
14.05.2010
14.05.2010

9.7.FP2