|
Problem IC72157
|
Status: Geschlossen |
MIGRATED SQL PROCEDURE MAY FAIL WITH RC = -901. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Apply 91FP10 which has the fix. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC72189 IC72190 IC72191
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.10.2010
13.06.2011
13.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
