DB2 - Problembeschreibung
Problem IT09499 | Status: Geschlossen |
SQL ERROR IN AUTOMOUS PROCEDURE CAUSES "SQLCA HAS ALREADY BEEN BUILT" MESSAGES IN DB2DIAG.LOG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
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. | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.06.2015 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |