|
Problem IC90170
|
Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3. Recommendation:
Upgrade to DB2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC94024
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.02.2013
08.10.2013
08.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
