Home >
DB2 for z/OS >
DB2 Locking & Concurrency for DBAs
DB2 Locking & Concurrency for DBAs
| Course Code: |
DZOLC2 |
| Duration: |
1 day |
| Environment: |
Non-data Sharing |
| Audience: |
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.
|
Detailed Outline |
|