Stream: Db2
Time: 10:00 - 10:45
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 second session covers Db2 restart in a data sharing environment, including group restart, and additionally discusses the advanced topic of conditional restart. It build on the topics covered in Part 1, Db2 restart basics. Objectives: 1. Understand what happens when Db2 restarts in data sharing environments. This includes restart after a controlled shutdown and after a 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. Db2 restart in Data sharing 2. Retained locks in data sharing 3. Restart light in data sharing 4. Dealing with GRECP and LPL conditions 5. Resolving postponed units of recovery 6. Group restart in data sharing 7. Conditional restart
There is currently no attachment for Db2 for z/OS Restart Part 2
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!