Stream: Db2
Time: 14:15 - 15:00
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 the same time, as far as is possible, preserving data integrity. Objective: 1. Understand what happens when Db2 restarts, both for stand-alone subsystems and in data sharing environments. This includes restart after a controlled shutdown and after an subsystem, member or data sharing group 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. 4. Learn how to deal with exception conditions such as LPAR failure. 5. Learn how to restart Db2 conditionally, and under what conditions. 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. Db2 restart in Data sharing 8. Retained locks in data sharing 9. Restart light in data sharing 10. Dealing with GRECP and LPL conditions 11. Resolving postponed units of recovery 12. Conditional Restart explained 13. Group restart in data sharing |
There is currently no attachment for Introduction to Db2 for z/OS Restart
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!