DB2 FOR LUW / DB2FORLUW / 970 - DB2

Executing an Autonomous Stored Procedure (i.e. a SP with the 
AUTONOMOUS keyword) which encounters a SQL error causes SQLCA 
messages written into db2diag.log: 
 
2014-09-03-12.59.30.941247+120 I234018E546           LEVEL: 
Error 
PID     : 14046                TID : 139857024247552 PROC : 
db2sysc 0 
INSTANCE: db2v1053             NODE : 000            DB   : 
SAMPLE 
APPHDL  : 0-348                APPID: 
*LOCAL.db2v1053.140903105929 
AUTHID  : DB2V1053             HOSTNAME: localhost 
EDUID   : 23                   EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, routine_infrastructure, 
sqlerAutonomousInvoker, probe:318 
MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT 
          "SQLCA has already been built" 
 
The db2diag.log message itself is not very useful to determine 
which specific SQL error has occured, that has caused the SQLCA 
message to be logged.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 11.                      * 
****************************************************************

Remove the "AUTONOMOUS" Keyword if this is possible. 
Or 
Run with DIAGLEVEL 4 which will log the SQLCA structure that the 
db2 clp process eventually receives.

First fixed in DB2 Version 9.7 Fix Pack 11.

not known / see Local fix

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

05.09.2014
09.10.2015
09.10.2015

9.7.FP11