Course Description
2 to 3 hours
Personnel requiring an introduction to DB2
Basic knowledge of Data Processing concepts.
After completing this course, the student will be able to:
• Define the concepts of DB2
• Define the basics of SQL
• Identify how to start and stop the system
• Identify how to monitor and restart the system
Introduction, DB2, SQL
Tables
Security
Availability and Recoverability
Command Syntax of Common SQL Statements
Starting/ Stopping DB2 Subsystem
Entering Commands to DB2
Monitoring DB2 Subsystem
Log and Boot Start Data Set
Termination and Restart of the DB2 System
Case Examples of DB2 Failures
