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

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