DB2 SYSTEM ARCHITECTURE
- DB2 address spaces
- attachments
- buffer & EDM pools
- system datasets & databases
- logging
- distributed & shared data concepts
DB2 SYSTEM INSTALLATION
- Installation steps
- install CLIST
- installation jobs
- compatibility, enable new function & new function modes
CONNECTING TO DB2
- DB2 attachments
- controlling connections to DB2
DB2 SECURITY
- DB2 system security
- GRANT & REVOKE statements
- security privileges
DB2 LOGGING
- Log buffers
- active logs
- archive logs
- BSDS
- checkpoints
DB2 DATA RECOVERY
- Invoking DB2 utilities
- backup & recovery utilities
- point-in-time recovery
DB2 SYSTEM RECOVERY
- BACUP SYSTEM & RESTORE SYSTEM utilities
- starting DB2
- start-up phases
- deferred restart
- conditional restart
DB2 MONITORING AND CONTROL
- DB2 traces
- controlling traces
- using basic trace information to perform system & application tuning
- controlling DB2 & attachments
PROBLEM DETERMINATION
- DB2 messages & codes
- diagnostic tools
- problem identification & resolution
PERFORMANCE AND TUNING
- SLAs
- performance aims
- performance factors
- tuning
