DB2 Locking Concurrency for DBAs

Environment:Non-data SharingAudience:Database Administrators, System Administrators and Capacity Planners.Prerequisites:A thorough understanding of DB2 for z/OS objects: databases, table spaces, tables and indexes.Summary:Especially designed for the DBA, this course focuses on everything the DBA should understand about the internals of DB2 locking in a non-data sharing environment. Equipped with such knowledge, the DBA function should be able to monitor IRLM and tune it so as to maximise concurrency and minimise locking CPU cycles. Among the topics covered are:

• DB2 subsystem options
• Database design options
• Application design options
• Bind/rebind options
• Claims and drains
• Monitoring and tuning

The presentation includes useful and practical recommendations to both online (e.g., CICS) and batch processes.Objectives:Upon completion of this presentation, the delegate should understand the scope and limits of DB2 locking choices such that locking definition, management, monitoring and tuning is less of a challenge.