DB2 FOR LUW / DB2FORLUW / 970 - DB2

Rollforward database still got hang issue after applying the fix
of APAR IC97678, the error message in db2diag.log and stack info
are same as before.

db2diag.log:

2016-08-24-11.14.13.657859+480 I1399274157A508    LEVEL: Error
PID     : 5243594              TID  : 53971       PROC : db2sysc
0
INSTANCE: xxxx              NODE : 000         DB   : xxxx
APPHDL  : 0-1317               APPID: *LOCAL.xxxx.160824031413
AUTHID  : xxxx
EDUID   : 53971                EDUNAME: db2agent (xxxx) 0
FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery,
probe:1230
RETCODE : ZRC=0x801000BB=-2146434885=SQLPR_MISSING_LOGFILES
          "rollforward missing log files"

2016-08-24-11.14.13.658628+480 E1399274666A476    LEVEL: Warning
PID     : 5243594              TID  : 53971       PROC : db2sysc
0
INSTANCE: xxxx              NODE : 000         DB   : xxxx
APPHDL  : 0-1317               APPID: *LOCAL.xxxx.160824031413
AUTHID  : xxxx
EDUID   : 53971                EDUNAME: db2agent (xxxx) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol,
probe:8180
MESSAGE : ADM1611W  The rollforward recovery phase has been
completed.

2016-08-24-11.14.13.658800+480 I1399275143A501    LEVEL: Warning
PID     : 5243594              TID  : 53971       PROC : db2sysc
0
INSTANCE: xxxx              NODE : 000         DB   : xxxx
APPHDL  : 0-1317               APPID: *LOCAL.xxxx.160824031413
AUTHID  : xxxx
EDUID   : 53971                EDUNAME: db2agent (xxxx) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol,
probe:8181
MESSAGE : The rollforward recovery phase completed with a return
code of
          -2146434885

EDU 53971 is waiting for destroy of page cleaner:

Stack:
======================

0x0900000000111894 thread_wait + 0x94
  0x0900000015C20F1C sqloWaitEDUWaitPost + 0x28C
  0x0900000015B15668
sqlbDestroyPageCleanerGroup__FP20SQLB_CLNR_GROUP_INFOP12SQLB_GLO
BALS + 0x360
  0x0900000015A812C0 sqlbDestroyAllCleaners__FP12SQLB_GLOBALS +
0x90
  0x0900000015A81120 sqlbterm_async_edus__FP12SQLB_GLOBALS +
0x150
  0x0900000015A80A60 sqlbCleanupBeforeTerm__FP12SQLB_GLOBALS +
0x260
  0x0900000015ACD360
TermDbConnect__16sqeLocalDatabaseFP8sqeAgentP5sqlcai + 0x68
  0x0900000015ACBDD4
AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0xCEC
  0x0900000015E04B94 sqlesrspWrp__FP14db2UCinterface + 0xF0
  0x0900000015E04DE4 sqleUCagentConnectReset + 0xC8
  0x0900000015E3E15C
@63@sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x8A8
  0x0900000015E3F22C
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2BC
  0x0900000015E3EBAC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0xEC
  0x0900000015B07D84 RunEDU__8sqeAgentFv + 0x2D8
  0x0900000015B0AED0 EDUDriver__9sqzEDUObjFv + 0xD8
  0x0900000015AFFD28 sqloEDUEntry + 0x250


Summary:
Found in 1 stacks of a total of 260 stacks ( 0.38% ) in 260
files
Found in:
     /home/db2v101/work/stack/5243594.53971.000.stack.txt --
db2agent(xxxx) -- 2016-08-24-13.19.10.701830(Signal #31)
????????????????????????????????????????????????????????????????
????????

Page cleaner is sleeping in a loop:

Stack:
======================

0x0900000000563910 _p_nsleep + 0x10
  0x09000000000397E4 nsleep + 0xE4
  0x090000000015DA90 nanosleep + 0x190
  0x090000000EDA0900 ossSleep + 0x80
  0x0900000015A9D108 sqlorest + 0x5C
  0x090000001286C5DC sqlorest@glue83D + 0x78
  0x0900000011F627EC sqlpflog__FP16sqeLocalDatabaseP9SQLP_LSN8 +
0x284
  0x0900000015C7E13C
sqloDispatchNBlocks__20SQLO_LIO_HANDLE_DATAFPP11SQLO_IO_REQUlPC2
2SQLO_LIO_CALLBACK_INFOP24SQLO_LIO_DISPATCH_STATUS16SQLO_LIO_OP_
TYPE + 0x1D0


Summary:
Found in 33 stacks of a total of 260 stacks ( 12.69% ) in 260
files
Found in:
     /home/db2v101/work/stack/5243594.10460.000.stack.txt --
db2pclnr(xxxx) -- 2016-08-24-13.19.10.718015(Signal #31)
     /home/db2v101/work/stack/5243594.16114.000.stack.txt --
db2pclnr(xxxx) -- 2016-08-24-13.19.10.730660(Signal #31)
     /home/db2v101/work/stack/5243594.16885.000.stack.txt --
db2pclnr(xxxx) -- 2016-08-24-13.19.10.722484(Signal #31)
     /home/db2v101/work/stack/5243594.17656.000.stack.txt --
db2pclnr(xxxx) -- 2016-08-24-13.19.10.720790(Signal #31)

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* See SYSROUTE APARs to see where this APAR is addressed       *
****************************************************************

Try to avoid the error above reported in db2diag.log during
rollforward database.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

30.08.2016
08.05.2017
08.05.2017