IBM Support

IT25801: INVALID MIRROR LOG PATH MESSAGE IS SEEN IN DIAG LOG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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 : <preformatted>
    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 : <preformatted>
    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 : <preformatted>
    Error opening:
    /db2/testdb/logdir2/NODE0000/LOGSTREAM0000/LOGSTREAM0000/S187468
    7.LOG.
    

Local fix

  • 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.
    

Problem summary

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

Problem conclusion

  • Upgrade to Db2 11.1 m4fp4 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25801

  • 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

    2018-07-25

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       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:
27 November 2018