|
Problem IC73817
|
Status: Closed |
STATEMENT RUN IN DB2_COMPATIBILITY_VECTOR=ORA AND IN DPF MODE MAY RETURN INTERNAL ERROR IN SQLKT_UNPACK_TUPLE() |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This problem is specifically when the DB2 registry variable
DB2_COMPATIBILITY_VECTOR=ORA is set and in DPF mode. The symptom
of the problem is an error message SQL0901N with the similar
text appeared in the db2diag.log file.
SQLCAID : SQLCA
SQLCABC : 136
SQLCODE : -901
SQLERRML : 70
SQLERRMC : probe 030 in sqlkt_pack_tuple(), msg=cold=NULLABLE
zvalue=NONULLS col(
SQLERRP : SQLRI088
SQLERRD[0]: -2112421887
SQLERRD[1]: 1
SQLERRD[2]: 0
SQLERRD[3]: 0
SQLERRD[4]: -500
SQLERRD[5]: 1
SQLWARN :
SQLSTATE : |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* This problem is specifically when the DB2 registry variable *
* *
* DB2_COMPATIBILITY_VECTOR=ORA is set and in DPF mode. The *
* symptom *
* of the problem is an error message SQL0901N with the similar *
* *
* text appeared in the db2diag.log file. *
* *
* *
* *
* SQLCAID : SQLCA *
* *
* SQLCABC : 136 *
* *
* SQLCODE : -901 *
* *
* SQLERRML : 70 *
* *
* SQLERRMC : probe 030 in sqlkt_pack_tuple(), *
* msg=cold=NULLABLE *
* zvalue=NONULLS col( *
* *
* SQLERRP : SQLRI088 *
* *
* SQLERRD[0]: -2112421887 *
* *
* SQLERRD[1]: 1 *
* *
* SQLERRD[2]: 0 *
* *
* SQLERRD[3]: 0 *
* *
* SQLERRD[4]: -500 *
* *
* SQLERRD[5]: 1 *
* *
* SQLWARN : *
* *
* SQLSTATE : *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 4 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 version 9.7 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.01.2011
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
