Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

Designed to review the concepts & components of DB2 version 9.5 for LINUX, UNIX & Windows. This course has 3 major sections; basic administration, advanced recovery" & "performance & tuning". DB2 commands & SQL will be used to focus on DB2 administration

Course Outline
This course is designed to review the concepts and components of DB2 version 9.5 for LINUX, UNIX and Windows. This course has 3 major sections; basic administration, advanced recovery€ and €oeperformance and tuning€. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops. Performance and tuning issues will be reviewed and applied in workshops.

Objectives At the end of this course, students will be able to:
€¢ Understand the basic concepts and facilities of DB2.
€¢ Create instances, databases and relational objects to support application development and user data access.
€¢ Understand row compression and range partitioning on tables to improve performance
€¢ Use IMPORT, EXPORT and LOAD utilities to manipulate data.
€¢ Perform basic and advanced database and tablespace recovery
€¢ Understand the basic security features of DB2.
€¢ Understand and control the locking behavior of DB2 and gather snapshot information for analysis.
€¢ Know how the DB2 Optimizer can be influenced to aid performance.
€¢ Use performance enhancing techniques for supporting applications.
€¢ Use EXPLAIN tools and techniques to improve SQL performance.
€¢ Alter the configuration of DB2 to improve performance

Topics €¢ The DB2 Family
€¢ Getting started with DB2 (INSTANCES)
€¢ Workshop
€¢ DB2 and GUI
€¢ Creating databases and tablespaces
€¢ Creating Tables and other objects
€¢ DB2 Security
€¢ DB2 Data Management
€¢ Basic Database Recovery
€¢ Disaster Recovery for tables and tablespaces
€¢ Incremental backup and recovery techniques
€¢ Data Access Techniques
€¢ The DB2 Optimizer
€¢ DB2 Operational Model
€¢ DB2 Configuration Parameters

Audience This course is designed for database administrators.

Course Outline I. The DB2 Family
A. The DB2 family of products
B. DB2 communications options

II. Getting started with DB2 (INSTANCES)
A. The DB2 hierarchy of objects
B. TCP/IP Connectivity for DB2
C. Instance creation and configuration
D. CLP (command line processor) coding options
E. The DB2 Administration Server

III. DB2 and GUI
A. Administration (GUI) tools
B. Configuring a DB2 Client to access remote instances and databases
C. Using the Command Editor to run queries or commands
D. Using the Control Center to create a database object

IV. Creating databases and tablespaces
A. Know how to create a database
B. Create SMS and DMS tablespaces
C. List tablespace and container information for a database
D. Get tablespace snapshots
E. Alter a tablespace and change container sizes
F. List and change the database and instance configuration files
G. Introduce Automatic storage

V. Creating Tables and other objects
A. Creating tables and indexes
B. Using data types and nullity attributes for columns
C. Defining Referential and table Check constraints
D. Creating views and nested table expressions
E. Introduce row compression
F. Identify concepts of range partitioning

A. When and how to use DB2 triggers
B. Create and code triggers
C. When and how to use UDT€(TM)s
D. Define sourced and external UDF
E. Define table functions

A. How DB2 controls concurrency and integrity for multiple users
B. Know the factors effecting data locking
C. Use commands to affect the behavior of DB2 locking
D. Use monitors to analyze user locking activity
E. Review and alter database configuration parameters that effect locking

VIII. DB2 Security
A. How to GRANT privileges
B. Know of administration Authorities in DB2
C. How to create tables and other objects for use of groups

IX. DB2 Data Management
A. Identify logging techniques that DB2 uses
B. Basic features of some DB2 Utilities, that help manage data
C. When to use these utilities

A. When and how to use IMPORT, EXPORT and LOAD
B. Choose options to improve performance the effects of using LOAD and how to bring a table to normal status
C. Compare LOAD and IMPORT

XI. Basic Database Recovery
A. When and how to use BACKUP and RECOVERY operations.
B. Choose a database configuration for €oefull recovery€ after failure.
C. ROLLFORWARD through the transaction logs to reapply changes to data.
D. Check the status of a tablespace.
E. Accomplish point-in-time recovery of a tablespace

XII. Disaster Recovery for tables and tablespaces
A. Complete a redirected restore, to replace lost or changed containers for tablespaces.
B. Recover from dropped table

XIII. Incremental backup and recovery techniques
A. Why and how to choose an incremental backup activity.
B. Determine options for database and tablespace recovery, when incremental backup has been used.
C. Setup for a database for incremental backup activity

XIV. Data Access Techniques
A. Understand strategies that might be used by the DB2 optimizer
B. Know what happens at execute time for specific strategies.
C. Use the EXPLAIN tools to analyse access strategy.

XV. The DB2 Optimizer
A. Know the impact of optimizer options on performance
B. Review multi-table access
C. Create indexes with varying options to improve performance
D. Create automatic summary tables
E. Consider the ways RAID technology may be used
F. Use lab activities to analyze and influence SQL performance

XVI. DB2 Operational Model
A. Review the architectural concepts for DB2
B. Look at the behavior of DB2, with respect to I/O operations
C. Identify important cache and monitoring elements
D. Lab activities involve extensive performance and tuning of the database to improve overall performance. Analysis of DB2 snapshots will prompt changes in database configuration. This pattern of analysis and change (tuning), will be repeated until performance is optimized.

XVII. DB2 Configuration Parameters
A. Review important configuration parameters for the a database and the database manager
B. Introduce auto-configuration
C. Identify the DB2 Design Advisor
Prerequisites & Certificates

Students should have relevant operating systems experience (UNIX, LINUX or Windows), and knowledge of relational database theory and SQL. Previous experience of using DB2 or another relational database is recommended.

Certificates offered

Certificate of completion

Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 596 times.