DB2 FOR LUW / DB2FORLUW / B10 - DB2

When infinite logging is used and mirror log path is set, the
following invalid path message is seen in diag log if Db2 needs
to retrieve an active log file during runtime rollback.

2018-02-19-10.10.44.463850+540 E1950846A595         LEVEL: Info
PID     : 18745668             TID : 6941           PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
TESTDB
HOSTNAME: DBSERVER
EDUID   : 6941                 EDUNAME: db2logmgr (TESTDB) 0
FUNCTION: DB2 UDB, data protection services,
sqpLogMgrEdu::sqlpgRetrieveLogFile, probe:4130
DATA #1 : 
Started retrieve for log file S1874687.LOG for log stream 0 from
log chain 1.
   Retrieval destination:
/db2/testdb/logdir/NODE0000/LOGSTREAM0000/LOGSTREAM0000/
   Actual retrieval method: USE_METHOD1

2018-02-19-10.10.45.946206+540 I1951442A511         LEVEL: Info
PID     : 18745668             TID : 6941           PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
TESTDB
HOSTNAME: DBSERVER
EDUID   : 6941                 EDUNAME: db2logmgr (TESTDB) 0
FUNCTION: DB2 UDB, data protection services,
sqpLogMgrEdu::sqlpgRetrieveLogFile, probe:4148
DATA #1 : 
Completed retrieve for log file S1874687.LOG on chain 1 to
/db2/testdb/logdir/NODE0000/LOGSTREAM0000/LOGSTREAM0000/.

2018-02-19-10.10.45.948983+540 I1951954A580         LEVEL:
Warning
PID     : 18745668             TID : 7198           PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
TESTDB
HOSTNAME: DBSERVER
EDUID   : 7198                 EDUNAME: db2loggr (TESTDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
MESSAGE : ZRC=0x870F0011=-2029060079=SQLO_PATH "an invalid path"
          DIA8514C An invalid file path, "", was specified.
DATA #1 : 
Error opening:
/db2/testdb/logdir2/NODE0000/LOGSTREAM0000/LOGSTREAM0000/S187468
7.LOG.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 m4fp4 or later                           *
****************************************************************

The message can be ignored, it doesn't mean any issue with your
mirror log path. The invalid path here is just because the log
stream subdirectory is not created in mirror log path which is
by design since Db2 only retrieves to primary log path as long
as primary log path is good.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

25.07.2018
27.11.2018
27.11.2018