|
Problem IC95499
|
Status: Closed |
STORED PROCEDURES RANDOMLY FAILS WITH ERROR SQL1124N |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
After upgrading to DB2 10.5 FP1, your stored procedures may
randomly fail with error SQL1124N.
From the db2diag.log, you can first see this particular message:
2013-06-28-22.33.21.840201+120 I1600A364 LEVEL:
Severe
PID : 24314096 TID : 1 PROC :
db2fmp (6169) 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: host1
EDUID : 1 EDUNAME: db2fmp (6169) 0
FUNCTION: DB2 UDB, oper system services, sqloSSemP, probe:10
MESSAGE : ZRC=0x009871BE=9990590
which can lead to different errors -1131, -1044 or -1042 in the
db2diag.log |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 FP3 or later *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
The problem was first fixed in DB2 10.5 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
20.12.2013
20.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
