| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC94024 | Status: Geschlossen |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 inclusive fixpack. * **************************************************************** | |
| Local-Fix: | |
If possible, remove ROWID from the INSERT or UPDATE statement. | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.07.2013 13.01.2014 13.01.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.9 |
|
| 9.7.0.9 |
|
