IBM Support

IC68225: SELECT AGAINST A TABLE CAN RESULT IN INSTANCE SHUTDOWN/ABEND WITH SQLRIMOVEDATAPTR AT THE TOP OF CORRESPONDING THE TRAP FILE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The instance shuts down/abends with a sigsegv. Looking at the
    corresponding trap file which is generated as a result of
    sigsegv the following can be observed:
    
    0x09000000333CFCDC sqlriMoveDataPtr__FP8sqlrr_cb + 0xDC
    0x09000000326EE2F4
    sqlriExecSargThread__FP8sqlrr_cbP12sqlri_opparm + 0x554
    0x09000000326F159C
    sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED + 0x2DC
    0x09000000326F83E4 sqldReadNorm__FP13SQLD_DFM_WORKl + 0x1684
    0x09000000326FED38 sqldFetchNext__FP13SQLD_DFM_WORK + 0x878
    0x09000000326FFE38 sqldfrd__FP13SQLD_DFM_WORK + 0xDD8
    
    This can be easily recreated on v9.7 Fixpak 1 on Solaris however
    it is not confined to this platform or level.
    
    Recreate Steps:
    
    db2 "create table taba ( one int )"
    db2 "create table tabb ( one int )"
    db2 "insert into taba values ( 1 )"
    db2 "insert into tabb values ( 1 )"
    db2 "select a.rowid from taba a, tabb b"
    

Local fix

  • N/A
    

Problem summary

  • The instance shuts down/abends with a sigsegv. Looking at the
    corresponding trap file which is generated as a result of
    sigsegv the following can be observed:
    
    0x09000000333CFCDC sqlriMoveDataPtr__FP8sqlrr_cb + 0xDC
    0x09000000326EE2F4
    sqlriExecSargThread__FP8sqlrr_cbP12sqlri_opparm + 0x554
    0x09000000326F159C
    sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED + 0x2DC
    0x09000000326F83E4 sqldReadNorm__FP13SQLD_DFM_WORKl + 0x1684
    0x09000000326FED38 sqldFetchNext__FP13SQLD_DFM_WORK + 0x878
    0x09000000326FFE38 sqldfrd__FP13SQLD_DFM_WORK + 0xDD8
    
    This can be easily recreated on v9.7 Fixpak 1 on Solaris however
    it is not confined to this platform or level.
    
    Recreate Steps:
    
    db2 "create table taba ( one int )"
    db2 "create table tabb ( one int )"
    db2 "insert into taba values ( 1 )"
    db2 "insert into tabb values ( 1 )"
    db2 "select a.rowid from taba a, tabb b"
    

Problem conclusion

  • First fixed in db2 v9.7 fp3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68225

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-28

  • Closed date

    2010-09-24

  • Last modified date

    2010-09-24

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

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

    IC68328

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

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:
24 September 2010