> > > CL213G Detailed outline

DB2 10 for LUW: Basic Administration for AIX (CL213G)

Course Description Schedule Course Outline

Detailed Course Outline

  • Overview of DB2 on Linux, UNIX and Windows
  • Command Line Processor (CLP) and GUI usage
  • The DB2 Database Manager Instance
  • Creating databases and data placement
  • Creating database objects
  • Moving data
  • Backup and recovery
  • Database Maintenance, Monitoring and Problem Determination
  • Locking and concurrency
  • Security

Agenda

  • The planned agenda follows. Here are the considerations:
  • The first six units must be taught in the order specified:
  • Overview of DB2, Command Line Processor (CLP) and GUI usage
  • The DB2 Database Manager Instance, Creating databases and data placement
  • Creating database objects
  • Moving data
  • Backup and recovery
  • Database Maintenance, Monitoring and Problem Determination
  • Locking and concurrency
  • Security

Day 1

  • (00:30) Welcome
  • (00:45) Unit 1: Overview of DB2 on Linux, UNIX and Windows
  • (00:45) Unit 2: Command Line Processor (CLP) and GUI usage
  • (00:45) Unit 3: The DB2 Database Manager Instance
  • (00:40) Exercise 1: Create a New DB2 Instance
  • (02:00) Unit 4: Creating databases and data placement
  • (00:45) Exercise 2: Creating databases and data placement

Day 2

  • (01:30) Unit 5: Creating database objects
  • (00:45) Exercise 3: Create objects
  • (02:00) Unit 6: Moving data
  • (01:00) Exercise 4: Moving data

Day 3

  • (02:00) Unit 7: Backup and recovery
  • (01:00) Exercise 5: Backup and recovery
  • (02:00) Unit 8: Database Maintenance, Monitoring and Problem Determination
  • (01:00) Exercise 6: Using DB2 Tools for Performance

Day 4

  • (01:00) Unit 9: Locking and concurrency
  • (01:00) Exercise 7: Investigating DB2 Locking
  • (01:30) Unit 10: Security
  • (01:00) Exercise 8: Database Security