IBM Support

IT06608: CRASH IN SQLSADDVECTORRECORD UNDER A CALL TO SQLDINDEXFETCH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Crash in sqlsAddVectorRecord under a call to sqldIndexFetch;
    Root cause is need to cleaning up stale pointers in MERGE join.
    
    [Environment]
    AIX 6.1, DB2 v9.7 + FP10, DPF, 1 machine, 4 logical node
    
    Operating system is: AIX 64BIT 6.1.0.0
    OSS reports operating system level as: 6.1.
    DB2 Release Info:
    Server running MPP/EEE.
    DB21085I This instance or install (instance name, where
    applicable:
    "db2inst1") uses "64" bits and DB2 code release "SQL0907A" with
    level
    identifier "080B0107".
    Informational tokens are "DB2 v9.7.0.10", "s141015", " IP23650",
    and Fix
    Pack
    "10".
    
    <StackTrace>
    @102@sqlsAddVectorRecord__FP10SQLS_SORTS
    @102@sqlsBuildRow__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSPibP7OSS
    TickP12OSSTickDeltaPP10SQLD_VALUE
    sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE
    sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo
    sqlrisr2__FP8sqlrr_cb
    @147@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB
    sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB
    .sqlirdk.fdpr.clone.2426__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP
    8SQLD_KEYP12SQLI_KEYDATAP9sqli_scanPi
    .sqldIndexFetch.fdpr.clone.317__FP8SQLD_CCBP8SQLZ_RID
    sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT
    3P12SQLD_ID_LISTP9SQLP_LSN8
    sqlritaSimplePerm__FP8sqlrr_cb
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm
    sqlrr_dss_router__FP8sqlrr_cb
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T
    sqleSubRequestRouter__FP8sqeAgentPUiT2
    sqleProcessSubRequest__FP8sqeAgent
    RunEDU__8sqeAgentFv
    EDUDriver__9sqzEDUObjFv
    sqloEDUEntry
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 fp11 or later.                               *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT06608

  • 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

    2015-01-20

  • Closed date

    2015-10-08

  • Last modified date

    2015-10-08

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

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT06608

Modified date: 08 October 2015