Goals for the Seminar
Seminar Outline
Goals for the Seminar
Seminar Outline
This seminar covers DB2 Version 4, 5, and 6. Primary focus is at the Version 5 level.
The DB2 log has fascinated the DB2 professional because so little is published about it. This seminar will separate the facts from the fantasies that have surrounded the log over the years. Log placement, how and when data is logged, what is actually contained in a log record, SYSLGRNX, SYSCOPY, the log utilities, and changes in the log process that have taken place over the last few releases are just some of the issues that will be addressed. Armed with this information, you will be able to solve recovery problems that may have seemed un-solvable before and improve the performance of the DB2 Recovery utilities.
The seminar begins with an overview of the log function and physical format of the log records. From here, the student is guided through the solution of a number of problem scenarios using only the information from the log to solve the problem. There will also be discussions on how to develop some home grown tools based on the DB2 off-line utilities to aid in some of the problem solving. Of course, there will be ample time for students to ask questions and discuss any aspect of the DB2 log that has always interested them.
This seminar is updated to DB2 Version 5.