DB2 - Problembeschreibung
Problem IT08565 | Status: Geschlossen |
DB2 MAY RETURN SQL901 ERROR OR TERMINATE ABNORMALLY DUE TO IMPROPER HANDLING OF ARRAY INSERT IN DPF ENVIRONMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In some rare situation, DB2 may return SQL901 error with message "BQS Sequencing Error" or terminate abnormally due to improper handling of array insert in DPF environment. You might see the following db2diag.log entries: 2015-02-25-20.56.28.650865-300 I4254475E468 LEVEL: Severe PID : 14838 TID : 140705905239808PROC : db2sysc 79 INSTANCE: db2inst1 NODE : 079 DB : SAMPLE APPHDL : 1-5859 APPID: 10.195.176.210.38005.150312140432 AUTHID : db2user EDUID : 353571 EDUNAME: db2agntp (SAMPLE) 79 FUNCTION: DB2 UDB, buffer Q services, sqlkqrcv, probe:70 MESSAGE : BQS Sequencing Error! Conn: 0, Rcvd: 7, Expected: 6 2015-02-25-20.56.28.651180-300 I4254944E584 LEVEL: Error PID : 14838 TID : 140705905239808PROC : db2sysc 79 INSTANCE: db2inst1 NODE : 079 DB : SAMPLE APPHDL : 1-5859 APPID: 10.195.176.210.38005.150312140432 AUTHID : db2user EDUID : 353571 EDUNAME: db2agntp (SAMPLE) 79 FUNCTION: DB2 UDB, table Q services, sqlktrcv, probe:50 MESSAGE : DIA0001E An internal error occurred. Report the following error code : "Line=00625, rc1=0x82180001, rc2=0x00000000, rc3=(nil), msg=sqlkqrcv(conn)". 2015-02-25-20.56.28.653235-300 I4259870E877 LEVEL: Severe PID : 14838 TID : 140705905239808PROC : db2sysc 79 INSTANCE: db2inst1 NODE : 079 DB : SAMPLE APPHDL : 1-5859 APPID: 10.195.176.210.38005.150312140432 AUTHID : db2user EDUID : 353571 EDUNAME: db2agntp (SAMPLE) 79 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 43 sqlerrmc: probe 050 in sqlktrcv(), msg=sqlkqrcv(conn) sqlerrp : SQLRI087 sqlerrd : (1) 0x82180001 (2) 0x00000001 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFE0C (6) 0x0000004F sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description below. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 11. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 11. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.04.2015 26.10.2015 26.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |