Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  DB2 connect issue

    Posted Fri January 22, 2021 03:05 PM

    When i am trying to connect db2 using db2 connect to JTS, it showing

    sql1273n an operation reading logs on database JTS cannot continue because of a missing log file s0013211.log on database partition 0 and log stream 0

    How to solve this?This has happened after an unexpected shutdown





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration


  • 2.  RE: DB2 connect issue

    Posted Fri January 22, 2021 08:42 PM

    Hi Sreenath,

    Basically s0013211.log is missing from the log path. Where is my DB log path?

    > db2 get db cfg for <dbname> | grep -i "Path to log files".

    E.g.

    db2 get db cfg for SAMPLE | grep -i "Path to log files"

    Changed path to log files (NEWLOGPATH) =

    Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/

    Make sure you copy the missing log file to the log path and try to connect to the database once again.

    Now, If

    1. the missing log file cannot be found, OR
    2. the missing log file cannot be recovered

    Please check the most appropriate "User Response" for SQL message in question , here.

    Regards, Thiago





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration


Related Content