by John Campbell, IBM(UK)

Audience: DB2 DBA, Level: Intermediate/Advanced 

Level: Intermediate/Advanced

Link to the presentation S134. Recommended Best Practices from Customer DB2 Health Check Studies Part 2

This two part presentation will introduce and discuss the major lessons to be learned from recent customer DB2 Health Check Studies carried out by DB2 for z/OS Development. The objectives are to: introduce and discuss the most common issues, share the experience gained from customer helath check studies, share the experience from live customer production incidents, provide proven recommended best practice, and to encourage proactive behavior. The following topics will be covered: WLM Policy Setup, Balanced Design across CICS and DB2 Disaster Recovery, Continuous Availability vs. Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs. Restart Light, Storage Tuning.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.