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

You Will Learn How To

• Administer a DB2 database system using commands and GUI tools
• Compare DMS, SMS, and Automatic storage management for table space storage
• Implement a given logical database design using DB2 to support integrity and concurrency requirements
• List and describe the components of DB2
• Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
• Use autonomic features of DB2
• Examine Explain output to determine access strategy chosen by Optimizer
• Investigate current application activity that might indicate performance problems using SQL statements
• Implement DB2 security

Important Course Information

Requirements

• You should be able to:
  • Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
  • State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
  • Discuss basic relational database concepts and objects such as tables, indexes, views, and join
• These skills can be developed by taking:
  • OS Training:
    • AIX 5L Basics
    • Linux Basics and Administration
    • Windows Systems Administration
    • Or by having equivalent HP-UX or Solaris administration experience
  • DB2 SQL Workshop
  • DB2 Fundamentals

Course Outline

• 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