|
Problem IC72157
|
Status: Closed |
MIGRATED SQL PROCEDURE MAY FAIL WITH RC = -901. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
The following kind of errors may be written to db2diag.log with
dump data for executing a SQL procedure
if the SQL procedure has been migrated to V9.1 or V9.5 from V8.
2010-10-01-13.30.21.555341+480 I396952A402 LEVEL: Severe
PID : 139908 TID : 1 PROC :
db2agent
(SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-50 APPID:
172.23.7.12.23301.101001053000
AUTHID : YES
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:20
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
2010-10-01-13.30.21.559929+480 I397355A806 LEVEL: Severe
PID : 139908 TID : 1 PROC :
db2agent
(SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-50 APPID:
172.23.7.12.23301.101001053000
AUTHID : YES
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33
sqlerrmc: sqlriChangeCsoCodepage: sanity 10
sqlerrp : SQLRI15A
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFFF6 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
This issue may happen for a SQL procedure accessing a LOB object
in mixed code page environment. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users migrating from V8 to V9.1 or V9.5 databases. *
****************************************************************
* PROBLEM DESCRIPTION: *
* -901 may be encountered when migrating procedure accessing a *
* mixed codepage LOB object from V8 to V91 or V95 databases, *
* as mixed codepage information might not be reconstructed *
* properly. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 91FP10 which has the fix. *
**************************************************************** |
| Local Fix: |
Drop and create the SQL procedure after a DB2 instance is
migrated from V8. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Apply 91FP10 which has the fix. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72189 IC72190 IC72191
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.10.2010
13.06.2011
13.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
