IBM Support

IT29280: ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • During Load the following message can be reported in the
    db2diag.log and the database can shut down abnormally with
    SQL0902:
    
    2019-05-13-10.31.51.611758+120 I1276219A646         LEVEL: Error
    PID     : 21366412             TID : 167804         PROC :
    db2sysc 0
    INSTANCE: db2jkl               NODE : 000           DB   : JKL
    APPHDL  : 0-43392              APPID: *LOCAL.db2jkl.190513083122
    UOWID   : 56                   ACTID: 1
    AUTHID  : DB2JKL               HOSTNAME: hal9000
    EDUID   : 167804               EDUNAME: db2agent (JKL) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpUpdateGlobalTimeInGLFH, probe:20
    MESSAGE : ZRC=0x870F0035=-2029060043=SQLO_NOTAVAIL
              "Cannot honor the conditional request"
              DIA8531C A memory access error has occurred.
    
    following the message of forced database shutdown
    
    2019-05-13-10.31.54.908141+120 I1299205A5024        LEVEL: Info
    PID     : 21366412             TID : 167804         PROC :
    db2sysc 0
    INSTANCE: db2jkl               NODE : 000           DB   : JKL
    APPHDL  : 0-43392              APPID: *LOCAL.db2pbi.190513083122
    UOWID   : 56                   ACTID: 1
    AUTHID  : DB2JKL               HOSTNAME: hal9000
    EDUID   : 167804               EDUNAME: db2agent (JKL) 0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeLocalDatabase::ForceDBShutdown, probe:17026
    MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB
    shutdown agent ID
              is:
    DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
    0-43392
    DATA #2 : sqeApplication_acbInfo,
    PD_TYPE_sqeApplication_acbInfo, 4 bytes
    x0
    CALLSTCK:
    
    with the following stack:
    
    sqeLocalDatabase::ForceDBShutdown
    sqlrr_rds_common_post
    sqlrr_rollback
    sqluv_rollback
    sqlu_register_table_load
    sqluvtld_route_in
    sqlesrvr
    sqleMappingFnServer
    sqlerKnownProcedure
    sqlerCallDL
    sqljs_ddm_excsqlstt
    sqljsParseRdbAccessed
    sqljsParse
    IPRA.$sqljsSqlam
    sqljsDrdaAsSPDriver
    IPRA.$sqlerWaitForFencedInvocation
    sqlerInvokeFencedRoutine
    sqlriInvokeInvoker
    sqlricall
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5                                      *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29280

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-28

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30786

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2019