DB2 - Problembeschreibung
Problem IC90170 | Status: Geschlossen |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When ROWID is used in an INSERT or UPDATE statement where the target table does not have a column named ROWID, DB2 server may terminate abnormally. The failing trace stack for an INSERT statement looks like: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ ..... 0x00002B980C2C42C7 sqlo_trce + .... 0x00002B980C30D957 sqloEDUCodeTrapHandler + .... 0x0000003F2A60EB70 address: 0x0000003F2A60EB70 ; dladdress: .... 0x00002B980A8029CD _Z23sqlnq_fix_insert_valuesPP9sqlnq_pidP9sqlnq_qcxP3locS0_ + .... 0x00002B980D0FC850 _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc + .... 0x00002B980D0891AA _Z12sqlnp_smactnP8sqlnp_cbi + ..... 0x00002B980A77C06B _Z12sqlnp_parserP8sqlnp_cb + .... 0x00002B980A7815ED _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + .... 0x00002B980A59CCFB _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur +.... 0x00002B980A59C211 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + ... The failing trace stack for an UPDATE statement looks like: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ .... 0x00002AAAAE0CF517 sqloEDUCodeTrapHandler + 0x0277 0x00002AAAAABD5E00 address: 0x00002AAAAABD5E00 ; dladdress: 0x00002AAAAABC8000 ; offset in lib: 0x000000000000DE00 ; 0x00002AAAADCD219D _Z23sqlnq_update_target_adtP9sqlnq_pidS0_P23sqlnq_adt_update_gro upsP3loc + 0x019d 0x00002AAAAC570FF9 _Z20sqlnq_sem_set_clausePP8stknode_i10actiontypePhP3loc + 0x0879 0x00002AAAAEE75A51 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0a41 0x00002AAAAC4D70B2 _Z12sqlnp_parserP8sqlnp_cb + 0x0822 0x00002AAAAC4DC8ED _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x027d 0x00002AAAAC3043A0 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x0b20 0x00002AAAAC303871 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0021 With the APAR fix, SQL206N will be returned. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3. * **************************************************************** | |
Local-Fix: | |
If possible, remove ROWID from the INSERT or UPDATE statement. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 3. Recommendation: Upgrade to DB2 Version 10.1 Fix Pack 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC94024 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.02.2013 08.10.2013 08.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |