suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT29280 Status: Closed

ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN
SQLPUPDATEGLOBALTIMEINGLFH

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem 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
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1.4.5                                      *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : 
follow-up : IT30786 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.05.2019
31.10.2019
31.10.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)