 |
|
 |
IBM
|
| |
|
| |
|
| Course Name: |
DB2 9 Database Administration Workshop for Linux, UNIX, and Windows - CL2X2 Training |
| |
|
| Deployment Options: |
Onsite - Instructor-Led Training |
| |
|
| Course Duration: |
4 days depending on audience background and options |
|
|
| |
|
| Related Courses |
| |
 |
| |
|
|
|
| Introduction: |
| |
This course is designed to teach you how to perform database administration tasks using DB2
9. Tasks include creating DB2 instances, creating and populating databases, and using logical design to support
concurrency and recovery requirements. New features such as range partitioning, data row compression, and pure
XML (native XML storage) will be introduced. Hands-on exercises provide an option of using either an AIX, Linux,
or Windows operating system.
Certification:
Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration. |
| |
| Audience: |
| |
| This intermediate course is for system administrators, database administrators, and technical
personnel involved in planning, implementing, and maintaining DB2 databas |
| |
| Prerequisites: |
| |
|
Before taking this course 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
joins
|
| |
| Customize it: |
| |
| This 4-day IBM course will be customized to your needs and specifications. Eno.com will assist
you in identifying those needs and specifications. A word to the wise, there are many vendors of IBM training.
They will typically have a broad and general course, one size fits all, already developed and just put your organization?s
name on the title slide. This minimizes their effort and time investment. At Eno.com, every course is made to your
exact and exacting specifications. We help you ensure what you are getting is what you really need even if at the
beginning you weren't too sure of what that was. We fit the class to your needs. We never fit you into our standard,
one size fits all, class. |
| |
| Objectives: |
| |
|
What You'll Learn
- Administer a DB2 database system using commands and GUI tools
- Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply
data placement principles
- Implement a given logical database design using DB2 to support integrity and concurrency
requirements
- Components of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Use autonomic features of DB2
- Implement DB2 security
|
| |
| Course Outline |
| |
1. Overview of DB2 9 on Linux, UNIX, and Windows
•Contrast the DB2 family of products
•Identify the DB2 products
•Functions of DB2 components
•Explore installation and parameters
2. Command Line Processor (CLP) and GUI usage
•Use the Command Line Processor
•Explore the GUI environment
•DAS role with GUI tools
3. The DB2 environment
•Key features of an Instance
•Create and drop an Instance
•Use db2start and db2stop
•Distinguish between types of configuration
•Modify the Database Manager Configuration
4. Creating databases and data placement
•Review specifics of creating a database
•Explore the System Catalog tables and views
•Compare DMS and SMS table spaces
•Set up and manage a DB2 database with Automatic Storage enabled
•Differentiate between table spaces, containers, extents, and pages
•Define table spaces
•Use the get snapshot for tablespaces command to display table space statistics
•Explore database configuration parameters
5. Creating database objects
•DB2 object hierarchy and physical directories and files
•Create the following objects: Schema, Table, View, Alias, Index
•Explore the use of table partitioning
•Review the use of Temporary Tables
•Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
•Exploring the need for and the use of Large Objects
•Recognize XML and its native store as critical infrastructure for emerging technologies
6. Moving data
•The INSERT statement and its limitations
•Differences between IMPORT and LOAD
•EXPORT, IMPORT, and LOAD syntax
•Create and use Exception Tables and Dump-Files
•Distinguish and resolve Table States: Load Pending and Set Integrity Pending
•Use the SET INTEGRITY command
•The db2move and db2look commands
7. Backup and recovery
•Major principles and methods for backup and recovery
•Three types of recovery used by DB2
•Importance of logging for backup and recovery
•How data logging takes place, including circular logging and archival logging
•Use the BACKUP, RESTORE, and ROLLFORWARD commands
•Perform a table space backup and recovery
•Restore a database to the end of logs or to a point-in-time
•Configuration parameters and the recovery history file and using these to handle various backup and recovery scenarios
8. Locking and concurrency
•Why locking is needed
•Objects that can be locked
•Various lock modes and their compatibility
•Four different levels of data protection
•Set isolation level and lock time out for current activity
•Lock conversion and escalation
•The situation that causes deadlocks
9. Problem determination
•Collect information for problem analysis and resolution
•Use error logs for basic problem analysis
•Four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, and Health Monitor
•Function of EXPLAIN and using this facility to assist basic analysis
•Use a series of basic commands to better work with connections and sessions
•Retrieve statistics and other information from a running DB2 instance
•Use RUNSTATS, REORGCHK, and REORG to resolve application performance problems
10. Security
•Use DB2 access control mechanisms to implement security within the database
•Use group IDs to create a control hierarchy
•Label Based Access Control (LBAC)
•Privileges within a database
•Privileges required for binding and executing a package
•Difference between explicit privileges and implicit privileges
•Different DB2 authorization levels
Agenda
Day 1
•Welcome
•Unit 1 - Overview of DB2 on Linux, UNIX, and Windows
•Lab 1 (Starting your lab environment)
•Unit 2 - Command Line Processor (CLP) and GUI usage
•Lab 2 (DB2 CLP usage)
•Unit 3 - The DB2 environment
•Lab 3 (Create an instance and explore the environment)
Day 2
•Unit 4 - Creating databases and data placement
•Lab 4 (Creating databases and data placement)
•Unit 5 - Creating database objects
•Lab 5 (Create objects)
•Unit 6 - Moving data
•Lab 6 (Moving data)
Day 3
•Unit 7 - Backup and recovery
•Lab 7 (Backup and recovery)
•Unit 8 - Locking and concurrency
•Lab 8 (Investigating DB2 locking)
Day 4
•Unit 9 - Problem determination
•Lab 9 (Problem determination)
•Unit 10 - Security
•Lab 10 (Security) |
| |
| Other Expertise: |
| |
|
|
|
| |
|
For organizational purchases, please send us a message at  salesinfo@eno.com
or complete and submit this form .
|
| |
| |
| |
|
|
|
