We have SAP applications running on DB2 on AIX and Windows. On one of our AIX server, we recently created a symbolic link to our Log directory some thing like
ln -s /db2/NODE0000/SQL0001/SQLOGDIR /db2/QMP/log_dir
This created a symbolic link from the default log directory to a new logdirectory. After that when we stopped and started DB2, all the logs were moved to new log_dir except one. S000019.LOG didnt move to the log_dir and while starting DB2, it hanged for some time and when i checked in the DB2 Diag log, it showed Userexit is waiting to archive log S000019.LOG and couldnot find it. So i manually moved the S000019.LOG from the old log directory (/db2/NODE0000/SQL0001/SQLOGDIR) into the log_dir and then DB2start worked fine and database came up.
But now the problem is i am unable to view the S000019.LOG in the log archive directory.. i.e /db2/QMP/log_archive. All other logs prior to 19 and after that are archived. Now if some disaster happens i think it will be hard to recover the database as the log chain is incomplete in the Log archive directory.
How to resolve this problem? Is it because that i manually moved the S000019.LOG to the log_dir, that Userexit didnt archived that file or is there something else ? Can i archive a single log file at a time? I have listed the history file and below is the part of the output from that--->
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20060823094852 1 U S0000017.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20060823094852
End Time: 20060823141425
Status: A
----------------------------------------------------------------------------
EID: 1413 Location:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20060823141417 1 U S0000018.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20060823141417
End Time: 20060823190557
Status: A
----------------------------------------------------------------------------
EID: 1414 Location:
[b]Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20060823190536 P D S0000019.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20060823190536
End Time:
Status: A
----------------------------------------------------------------------------
EID: 1415 Location: /db2/QAS/db2qas/NODE0000/SQL00001/SQLOGDIR/S0000019.LOG
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20060823211408 1 U S0000020.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20060823211408
End Time: 20060823225115
Status: A
----------------------------------------------------------------------------
EID: 1416 Location:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20060823225053 1 U S0000021.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20060823225053
End Time: 20060824003051
Status: A
----------------------------------------------------------------------------
EID: 1445 Location:
Why does the Type and Device in the history log file show P and D for S000019.LOG which is different for other entries.
Will there be any problem with the above situation? Please advice..
Thanks in advance for your kind reply...
Regards
Siva