10 to 15 hours
Personnel requiring knowledge of DB2 database administration
Basic programming knowledge, basic OS/390 knowledge, and basic DB2 knowledge
After completing this course, the student will be able to:
• Identify how to set up the DB2 Database Administration function in their organization
• Identify how to participate in the installation or migration of DB2
• Recognize the basics of data normalization
• Identify how DB2 objects are created and how to set up referential integrity
• Identify how DB2 tables are altered
• Identify how DB2 structures are compared
• Identify how to set up and execute DB2 utilities
• Define DB2 locking
• Identify how DB2 security is set up
• Recognize DB2 EXPLAIN output
Introduction
Software Support
Development Support
QA Support
Production Support
Backup and Recovery
Security
Database Connectivity
Performance Management
Consulting
Storage Estimates
Virtual and Real Storage
DASD Requirements
Distributed Processing
Parallel Sysplex
SMP/E
ODBC
Service Levels
Installation Jobs
Migration
Fallback
Other Software
Logical Design
Why Normalization
Steps in Normalization
Un-Normalized Relations
First Normal Form
Second Normal Form
Third Normal Form
Physical Design Process
Object Design
Storage Groups
Databases
Simple Tablespace
Segmented Tablespace
Partitioned Tablespace
Tables
Data Types
Indexes
View
Constraints
Primary Key
Foreign Key
Developer Support Overview
Adding Columns
Renaming Columns
Deleting Columns
Changing Nulls
Object Versioning
Change Requests
DBA Checklist
Listing Missing Objects
Object Comparison – Tablespace
Object Comparison – Tables
Object Comparison – Columns
Object Comparison – Indexes
Impact Analysis
Data Availability
Backup
Storage Management
Database Performance
REORG
Defect Support
Defect Support for DB2
Defect Support for Applications
Continuous Availability
Database Descriptors
COPY SHRLEVEL CHANGE
REORG SHRLEVEL CHANGE
Auditing
Security
Automation
Automation Levels Characteristics
Locking
Locking Hierarchy
Transaction Locks
Intent Locks
Tablespace Locks
Releasing Locks
Releasing Page/ Row Locks
Concurrency Options
Backup and Recovery Definition
Copy Utility
Quiesce Utility
Report Utility
Data Set Retention
Recover Utility
Rebuild Utility
Check Data Utility
Modify Utility
The BSDs
Security Definition
Privileges
Administrative Authorities
Secondary AUTH IDS
Security Exits
CICS Attachment Facility Options
IMS Attachment Facility Options
Connectivity Definition
DRDA
DB2 Connect
DRDA Levels
CLI and ODBC
JDBC
DB2 Connect Personal Edition
DB2 Connect Enterprise Edition
Performance Management Definition
DB2 Architecture
Optimizer Statistics
Default Statistics
DB2 Visual Explain
DB2 Instrumentation Facility
DB2 Estimator
DB2 Explain
PLAN_TABLE Usage
Creating the PLAN_TABLE
Populating the PLAN_TABLE
DB2 Access Path Overview
Tablespace Scan
Matching Index Scan
Index Screening
Non-Matching Index Scan
In-List Index Scan
Multiple Index Access
One Fetch Index Access
Index Only Access
Equal Unique Index
Nested Loop Join
Merge, Scan, Join
Hybrid Join
12 Questions to ask
Definition
Reasons for Conversion
Parallel Sysplex
OO Programming (UDT)
OO Programming (UDF)
OO Programming (Triggers)
Multimedia
Client Server
Data Replication
Course Description 
