IBM Support

IC94024: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error 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.
    

Local fix

  • If possible, remove ROWID from the INSERT or UPDATE statement.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to inclusive fixpack.                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC94024

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-10

  • Closed date

    2014-01-13

  • Last modified date

    2014-01-13

  • APAR is sysrouted FROM one or more of the following:

    IC90170

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 January 2014