Home > database >  DB2 automatically stop, two or three days to solve!!!!!!
DB2 automatically stop, two or three days to solve!!!!!!

Time:10-21

020-03-02-02. I7389248E508 45.50.819110-300 LEVEL: the Event
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, the probe: 20
CHANGE: CFG DB ZWXX: "Database_memory" From: "366480" To: "352032"

The 2020-03-02-02.45.50.949386-300 I7389757E439 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, the probe: 30
MESSAGE: Crash Recovery is men.

The 2020-03-02-02.45.51.630543-300 I7390197E502 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, the probe: 410
MESSAGE: Crash recovery started. LowtranLSN 0000000220340010 MinbuffLSN
0000000220340010

The 2020-03-02-02.45.51.630662-300 E7390700E456 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, the probe: 410
MESSAGE: ADM1530E Crash recovery has had initiated.

The 2020-03-02-02.45.51.631744-300 I7391157E497 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, the probe: 2000
DATA # 1:
Using the parallel recovery agents with 4 5 QSets 15 the queues and chunks of 16

The 2020-03-02-02.45.54.004270-300 I7391655E353 LEVEL: Warning
PID: 18031, 140396940224256: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000
EDUID: 22 EDUNAME: db2lfr (ZWXX) 0
FUNCTION: DB2 UDB, data protection, services, sqlpgarl, the probe: 99
MESSAGE: the INFO ONLY: Found an old page in the log file

The 2020-03-02-02.45.54.352272-300 I7392009E512 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, the probe: 4000
MESSAGE: DIA2051W Forward phase of crash recovery has completed. The Next LSN is
"0000000221111922".

The 2020-03-02-02.45.54.378511-300 E7392522E465 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, the probe: 3170
MESSAGE: ADM1531E Crash recovery has completed successfully.

The 2020-03-02-02.45.54.378696-300 I7392988E467 LEVEL: Warning
PID: 18031, 140396952807168: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 7 APPID: 10.2.101.1.46747.200302074550
AUTHID: DB2INST1
EDUID: 19 EDUNAME: either (ZWXX) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, the probe: 3170
MESSAGE: Crash recovery completed. Next LSN is 0000000221111922

The 2020-03-02-02.45.54.837544-300 E7393456E468 LEVEL: the Event
PID: 18031, 140396877309696: dar proc: db2sysc 0
INSTANCE: db2inst1 NODE: 000 DB: ZWXX
APPHDL: 0 to 8 APPID: * LOCAL DB2.200302074554
AUTHID: DB2INST1
EDUID: 37 EDUNAME: db2stmm (ZWXX) 0
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  •  Tags:  
  • DB2
  • Related