|
Problem IT23319
|
Status: Closed |
-901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENTIS RUN TWICE
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Example:
2017-03-08-14.59.04.187441+060 I1415362911E992 LEVEL:
Severe
PID : 13860 TID : 139985030211328 PROC :
db2sysc 0
INSTANCE: XXXX NODE : 000 DB : XXX
APPHDL : XXXXXX APPID: XXXXXXXXXXX
AUTHID : XXXX HOSTNAME: XXX
EDUID : XXX EDUNAME: db2agent (PB3) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
MESSAGE : ZRC=0x825B01ED=-2107964947=SQLRA_PREP_ANON_BLOCK
"Can't compile the anonymous block directly, use
icoord method"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRA067
sqlerrd : (1) 0x825B01ED (2) 0x000001ED (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFC18 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V105FP10. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner :
follow-up : IT24960 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.11.2017
11.07.2018
11.07.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
