Introduction to DB2 | 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 Physical Objects | DB2 Catalog, DB2 Directory, Active & Archive Logs, BSDS, Buffer Pools, Lock |
Database Design | Physical design Process, Object Design Storage Groups, Databases, Table space, Tables, Data Types, Indexes, View, Constraints, Primary Key & Foreign Key, DB2 Catalog |
Program Preparation / Bind | DB2, DSN Commands, Program Preparation, DCL Gen, 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. |