> > > CL2X3G Detaillierte Beschreibung

DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

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

Agenda

Day 1

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

Day 2

  • Unit 5: Creating database objects
    • Exercise 3: Create objects
  • Unit 6: Moving data
    • Exercise 4: Moving data

Day 3

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

Day 4

  • Unit 7: Locking and concurrency
    • Exercise 7: Investigating DB2 Locking
  • Unit 8: Security
    • Exercise 8: Database Security