• DB2 Address Spaces
• System Services Address Spaces (DSNMSTR),
• Database Services Address Spaces (DSNDBM1)
• Internal Resources Lock Manager (IRLMPROC),
Distributed Database Facility (DSNDIST) Storage
Procedure Address Space (DSNSPAS)

• DB2 Catalog, DB2 Directory, Active& Archive Logs
• BSDS, Buffer Pools, Locks

• Physical design Process, Object Design
• Storage Groups, Databases, Table space, Tables, Data
Types, Indexes, View, Constraints Primary Key &
Foreign Key.

Program Preparation / Bind
• DB2, DSN Commands
• Program Preparation, DCLGen, Pre Compilation, Bind
Package & Plan
Locking and Concurrency
• Locking, Locking hierarchy, Transaction locks, Table
space locks, Releasing locks
• Releasing Page/Row Locks, Concurrency Options
Security & Control
• Explicit Privileges, Database Privileges, System
Privileges, User Privileges, Schema Privileges Grant
& Revoke Privileges
DB2 Online Utilities
• LOAD & CHECK DATA, CHECK INDEX, REORG, REPAIR,
RUNSTATS, MODIFY, STOSPACE,BACKUP & RECOVERY,
COPY, RECOVER, QUIESCE, REPORT, MERGECOPY
DB2 Standalone Utilities
• DSN1COPY, DSN1LOGP, DSN1PRINT, DSNJLOGF,
DSNJU003
DB2 and other environment
• Connectivity definition, Call Attachment facility, CICS
Attachment facility options, TSO Attachment facility
options
Performance Management
• Performance Management definition, Optimizer,
Performance Tuning, Explain Function, Plan-Table.