Module 1 Overview of DB2 Major Components
Objectives             
DB2 and E-Business         
Effective E-Business Model        
DB2 E-Business Components        
DB2 Product Family          
DB2 Object Architecture       
DB2 Architecture — Multiple Instances    
DB2 Architecture — Processes    
DB2 Architecture — Shared Memory   
DB2 Architecture — Configuration Files   
Summary           
Lab Exercises    

Module  2 Introduction to GUI Tools
What are the GUI Tools?          
List of GUI Tools          
First Steps - Overview        
First Steps: Create Sample Databases   
First Steps: Working With Tutorials    
First Steps: Quick Tour        
Information Center           
Control Center: Overview         
Control Center: Tools Menu        
Control Center: Object Menus       
Configuration Assistant: Overview      
Command Center: Overview        
Command Center: Query Results      
Task Center: Overview        
Task Center: Task Menu         
Task Center: New Task        
Task Center: Options          
Health Center           
Journal             
License Center          
Development Center: Create a Project    
Development Center: Project View     
Development Center: Create a New Routine   
Visual Explain: Scenario         
Visual Explain: Overview         
Visual Explain: Access Plan        
Summary             
Lab Exercises 

Module 3 Data Placement
Objectives             
Table Spaces           
Containers              
Extents              
Buffer pool             
SMS Table Spaces          
DMS Table Spaces          
SMS Table Spaces and Tables       
DMS Table Spaces and Tables      
SMS vs. DMS            
Buffer pools and Table Spaces      
Table Spaces Defined at Database Creation   
CREATE DATABASE Example      
CREATE TABLESPACE Syntax       
CREATE TABLE SPACE Examples      
EXTENTSIZE and PREFETCHSIZE      
Authority to Create Table Space       
Listing Table Spaces          
Listing Table Spaces with Detail       
Listing Containers          
LIST TABLE SPACES Authority       
LIST TABLESPACE CONTAINERS Authority   
Altering Table Spaces         
ALTER TABLESPACE Syntax      
ALTER TABLESPACE: Example      
ALTER TABLESPACE: Example       
ALTER TABLESPACE Authorization     
Dropping Table Spaces        
DROP TABLESPACE Authority       
DMS Table Space Minimum Size      
Performance: Container Size       
RAID Devices           
Performance: SMS Table Spaces      
Performance: DMS Table Spaces      
Performance: Catalog Table Space      
Performance: System-Temporary Space    
Performance: User Table Spaces     

Module 4 Creating an Instance
Objectives             
Instance Components          
Requirements to Create a UNIX Instance     
The SYSADM User and Group       
Fenced User           
DAS User            
Database Administration Server (DAS)     
Creating an Instance         
The db2icrt Command in Detail      
Creating an Instance in Windows      
Drop Instance           
Why Drop the DAS?          
Starting Instances          
Stopping Instances         
Instance Configuration Using the CLP    
Instance Configuration Using the Control Center  
Update Instance Configuration      
Registry Variables          
Levels of the Registry         
View Registry Variables        
Set Registry Variables         
Instance Authorization         
Client/Server Connectivity        
Manual Configuration         
Manual Configuration Scenario      
Cataloging the Server         
Cataloging the Database         
Cataloging Authorization         
Configuration Assistant (CA)        
Discovery Parameters         
Configuration Assistant Overview      
Configuration Assistant: Add a Database    
Add Database Wizard: Set Up Connection   
Add Database Wizard: Search the Network    
Add Database Wizard: Testing the Connection  
Search: Configuration is Complete     
Summary             
Lab Exercises           

Module 5 Database Tables and Views
Objectives             
The Database Configuration File      
Managing the DB CFG File Using CLP     
Managing DB CFG Using CC        
Database Configuration Window      
Starting and Stopping Databases       
FORCE APPLICATION        
Authorization             
Schemas             
Current Schema           
CREATE SCHEMA SQL Statement      
CREATE SCHEMA Examples       
Create a Schema Using SQL Statements    
System Catalog Tables        
Querying Catalog Tables for Table Names   
Querying Catalog Tables for Table Spaces   
Querying Catalog Tables for Bufferpools    
Querying Catalog Tables for Constraints    
Large Objects           
Large Objects and Tables        
Temporary Tables          
Benefits of Global Temporary Tables     
Creating Temporary Tables       
Temporary Table Authorizations       
Views              
Classifying Views           
CREATE VIEW Examples        
Creating Views Using the Control Center    
Create View Window          
SQL Assist Window         
SQL Assist: Tables Page         
Federated System          
Federated System Objects       
Summary             
Lab Exercises   

Module 6 Creating Indexes
Objectives             
Overview            
Type- Indexes           
Types of Indexes          
Unique Indexes           
Index: Tables and Columns        
Clustered Indexes           
Index: PCTFREE and MINPCTUSED     
Bidirectional Indexes          
Index: Illustration           
Unique Index: Example        
Clustered Index: Example        
Bidirectional Index: Example        
Creating Indexes in the Control Center    
Design Advisor          
Design Advisor: Workload Panel       
Design Advisor: Collect Statistics      
Design Advisor: Disk Usage        
Design Advisor: Calculate        
Design Advisor: Recommendations      
Design Advisor: Unused Objects       
Design Advisor: Schedule        
Design Advisor: Summary        
Design Advisor in the CLP: db2advis     
Db2advis: Implementation        
Summary              
Lab Exercises          

Module  7 Using Constraints
Objectives             
Keys: Overview           
Primary Key            
Primary Key: Table Creation Time      
Creating Tables in the Control Center      
Adding a Primary Key to an Existing Table: SQL  
Adding a Primary Key: Alter Table Window   
Foreign Key           
Foreign Key: Table Creation Time      
Foreign Key: Control Center        
Unique Key           
Specifying a Unique Key at Table Creation Time  
Changing a Unique Key: ALTER TABLE     
Check Constraint           
Check Constraint: Table Creation Time     
Create Table Window: Adding Check Constraints 
Summary             
Lab Exercises         

Module 8 Data Movement Utilities
Objectives             
Exporting Data            
Data Movement Utilities         
Data Movement Utilities: EXPORT      
EXPORT Command         
EXPORT Option: Filename and File Type     
EXPORT Option: LOBS TO        
EXPORT Option: LOBFILE        
EXPORT Option: File Type Modifier ()     
EXPORT Option: METHOD       
EXPORT Option: MESSAGES      
EXPORT Option: Select Statement     
EXPORT Option: HIERARCHY      
EXPORT Option: HIERARCHY      
EXPORT: Authorization        
IMPORT Command         
IMPORT Command: File Options and LOB   
IMPORT Command: File Type Modifiers     
IMPORT Command: METHOD      
IMPORT Command: Count and Message Options 
IMPORT: Authorization        
Data Movement Utilities: LOAD      
LOAD Phases           
LOAD: Load Phase         
LOAD: Build Phase         
LOAD: Delete Phase          
LOAD: Target and Exception Tables      
LOAD Command: Syntax        
LOAD Command: Filename and Location    
LOAD Command: Filetype and Modifier     
LOAD Command: METHOD        
LOAD Command: Counter Options     
LOAD Command: Mode         
LOAD Command: Exception Table     
LOAD Command: Statistics       
Load Command: Parallelism        
LOAD Command: Copy Options       
LOAD Command: Indexing       
LOAD: Performance Modifiers       
Unsuccessful Load Operation       
Post Load: Table Space State       
Post Load: Removing Pending States     
LOAD: Additional Features in DB2     
LOAD: Authorization          
IMPORT Versus LOAD        
Data Movement Utilities: db2move     
Data Movement Utilities: db2move     
Db2move Command: Syntax        
Data Movement Utilities: db2look      
Db2look Command: Syntax       
Summary             
Lab Exercises          

Module 9  Data Maintenance Utilities
Objectives             
Data Maintenance: The Need        
REORGCHK: Analyzing Physical Data Organization  
REORGCHK Command: Syntax and Examples  
REORGCHK: Table Statistics        
REORGCHK: Index Statistics        
REORGCHK: Interpreting of Index Information  
Reorganization           
REORG Command: Syntax and Example    
REORG: Using Index         
Generating Statistics          
RUNSTATS Command: Syntax and Examples  
RUNSTATS: Distribution Statistics     
REBIND            
REBIND and db2rbind: Syntax      
Summary              
Lab Exercises

Module 10 Locking and Concurrency
Objectives            
Why Are Locks Needed?         
Types of Locks          
Locking Type Compatibility       
Lock Conversion           
Lock Escalation          
Explicit and Implicit Locking        
Possible Problems When Data Is Shared   
Isolation Levels           
Deadlocks           
Summary            
Lab Exercises

Module  11 Backup and Recovery
Objectives            
Types of Recovery          
Logging Concepts          
Transaction Log File Usage       
Circular Logging           
Dual Logging            
Archival Logging/Log Retain        
Backup Utility           
Backup Files           
Restoring a Backup Image        
The Database Roll Forward        
Redirected Restore          
Restore Considerations         
Table Space Recovery         
Table Space State: Offline       
Table Space Offline State (cont)     
Backup and Restore Summary       
Recovery History File        
Dropped Table Recovery        
Summary            
Lab Exercises

Module 12 Performance Monitoring
Objectives            
Performance Tuning Overview      
Common Database Server Parameters     
Common Database Parameters       
AUTOCONFIGURE           
Query Parallelism         
Monitoring Performance        
Snapshot Monitor         
Snapshot Monitor: Switches       
Retrieving Snapshot Information      
Snapshot Output: Locks        
Snapshot Monitoring: Authority       
Event Monitoring           
Event Monitor          
Event Monitor: Data Collection       
Event Monitor Interface         
Event Monitoring: Steps and Authorization    
Creating an Event Monitor: Type of Event   
Creating an Event Monitor: Event Condition   
Creating an Event Monitor: File Path     
Creating an Event Monitor: Maxfiles     
Creating an Event Monitor: Maxfilesize     
Creating an Event Monitor: Buffersize    
Creating an Event Monitor: Append/Replace  
Creating an Event Monitor: Manual Start/Autostart  
Creating an Event Monitor: Example     
Event Monitor: Start/Flush       
Event Monitor: Reading Output       
Event Monitor: db2eva        
Event Monitor: db2eva (cont)      
Event Monitor: db2eva (cont)      
Health Monitor and Health Center     
Health Indicator Settings        
Summary            
Lab Exercises

Module  13 Query Optimization
Objectives            
Query Optimization         
SQL Compiler Overview         
What is Explain?           
Query Explain Tables          
Capturing Explain Data        
Capturing Explain Data: Explain Statement    
Capture Explain Data: Special Register    
Prep-Bind Overview          
DB2 SQL Explain Tools         
View Explain Data: db2expln       
View Explain Data: Visual Explain     
Visual Explain: Graphical Output      
Visual Explain: Component Details      
Visual Explain: Uses         
Explain: Setting the Optimization Level     
Minimize Client-Server Communication    
Summary            
Lab Exercises

Module 14 Problem Determination
Objectives            
To Solve a Problem         
Describe the Problem         
Problem Types          
Required Diagnostic Data        
Required Data Checklist         
Additional Data Available         
The db2diaglog File          
Suggestion           
DIAGLEVEL  Considerations      
Location of the db2diaglog File       
Db2diaglog Information Example     
db2diaglog Example: Starting the Database  
db2diaglog: Finding Error Information     
Looking Up Internal Codes        
Byte Reversal          
Looking Up Internal Return Codes      
Db2diaglog Example: Container Error     
Db2diaglog Example: Sharing Violation    
Db2diaglog Example: Manual Cleanup     
Db2diaglog Example: Database Connection  
Which Container?         
Error Explanation          
Error Reasons          
Error Resolution           
Summary            
Lab Exercises

Module 15 Security
Objectives            
Security            
Authentication           
Authentication Type: Server        
Authentication Type: DCS        
Encrypted Password          
Authentication Type: KERBEROS      
Authentication Type: KRB_SERVER_ENCRYPT  
Authentication Type: CLIENT      
TRUST_ALLCLNTS         
TRUST_CLNTAUTH          
Authorities           
Authorities in the DBM Configuration    
Database Authority Summary      
Privileges            
Levels of Privileges          
Database Level Privileges       
Schema Level Privileges        
Table and View Privileges        
Package and Routine Privileges       
Index and Table Space Privileges     
Implicit Privileges          
Privileges Required for Application Development 
System Catalog Views        
Hierarchy of Authorizations and Privileges     
Audit Facility            
The db2audit Command: How It Works     
Summary            
Lab Exercises

Module 16 Summary
Objectives            
Course Objectives          
Basic Technical References        
Advanced Technical References       
Next Courses             
Evaluation Sheet           
Lab Exercises Environment
Overview             
Client Setup (Windows)          
DB2 Server Setup (Windows)       
DB2 Server Setup (UNIX/Linux)       
DB2 Platforms           
DB2 Command Line Syntax        
DB2 Online Reference         
Starting a Command Line Session       
QUIT vs. TERMINATE vs. CONNECT RESET   
List CLP Command Options       
Modify CLP Options          
Input File: No Operating System Commands    

Input File: Operating System Commands