Stream: Db2
Time: 11:30 - 12:15
Abstract: It is all too easy to take Db2 restart for granted, but it is important to understand how Db2 restart works so you can plan for and practice restart when there are exception conditions. Planning, practice and preparation will stand you in good stead when you have a real emergency and need to restore a business service as soon as possible and at maximise your chances of preserving data integrity. The first session covers Db2 subsystem restart basics. It provides the building blocks for Part 2 which covers restart in data sharing, and the more advanced topic of conditional restart. Objective: 1. Understand what happens when Db2 restarts. This includes restart after a controlled shutdown and after a subsystem failure. 2. Understand what looks normal after either kind of restart, and what looks abnormal. 3. Learn how to identify and deal with exception conditions arising from a restart. Agenda (subject to change): 1. Introduction to restarting Db2 after termination 2. Phase 1: Log Initialisation 3. Phase 2: Current Status Rebuild 4. Phase 3: Forward Log Recovery 5. Phase 4: Backward Log Recovery 6. Fast Log Apply processing 7. Limiting backout processing 8. Handling unresolved Units of Recovery 9. Tuning for fast restart
There is currently no attachment for Db2 for z/OS Restart Part 1
Gareth has over 35 years Db2 experience as a DBA, and Systems Programmer. He gained experience in the financial, transport, retail and manufacturing businesses before joining IBM's Strategic Outsourcing division in 2000. He joined the Db2 for z/OS Development SWAT Team in 2006, under the leadership of John Campbell, where he worked with many customers around the world in both consultancy and trouble-shooting roles. He now works as a Principal Consultant for Triton Consulting. Gareth is an IBM Redbook and white paper author, has written other technical documents and has presented at many user conferences. He became a Db2 Gold Consultant in 2020, and is active in the Db2 user community.
Click here to give some Feedback so we can make it even better next year!