Log File Management: Troubleshooting
Failure in the DB2 User Exit
The procedure for finding out the cause of the trouble is basically the same for both the ARCHIVE and RETRIEVE action of the DB2 user exit program.
The entry in this file will provide information about the return code received from the user exit program. (For more information, see Messages).
– db2uext2.log : Protocol file
– db2uext2.err : Entries for errors that occurred
– db2uext2.trc : Trace file for the last DB2 user exit processing. (For information about tracing, see Tracing.)
Failure in Log File Archiving or Log File Restoring
One page of the log file management notebook is called the "journal". The log file management actions are listed there. To display a detailed protocol for a particular action, double-click on the relevant action entry.
The protocol files are located in the /db2/<SID>/saparch (archiving) and db2/<SID>/saprest (restoring) directories. Their file names have the following format:
For archiving: a<enc_ts>.<fid>
For restoring: r<enc_ts>.<fid>
where <enc_ts> is the encrypted timestamp of the execution time and <fid> is the function ID of the log file management task (for example, "svd" stands for archive and subsequently delete a log file).
The contents of these files are the same as you will get if you access the SAP-DB2admin: Log File Management function Journal from the DB2 Control Center.