Provided by: 123-CBT Computer Based Training IBM DB2 Universal Database V6 1--Administration Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database.

Learn To:

• Implement a new DB2 database or application.
• Maintain an existing DB2 database.

Content Emphasis

Skills-Based

Audience

This course is intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification Database Administration exam 510.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Design for a New DB2 Implementation

• Match the authentication parameter settings with their outcomes.
• Identify the authority level required for a specified privilege.
• Set access to objects given a scenario.
• Analyze the security system catalogs to determine the privileges a user holds.
• Identify the events that the DB2 audit facility can capture.
• Match the data placement objects with their descriptions.
• Construct a table space using the CREATE TABLESPACE statement.
• Choose the required number of containers given a scenario.
• Construct a buffer pool of a specified page size using the CREATE BUFFERPOOL statement.
• Select the effects of a CREATE DATABASE statement.
• Select data placement attributes given the system catalogs.
• Construct the appropriate type of index using the CREATE INDEX statement.
• Identify effects of index re-creation strategies.
• Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement.
• Construct a view on a table using the CREATE VIEW statement.
• Construct a schema using the CREATE SCHEMA statement.
• Change communications parameters using the UPDATE DATABASE MANAGER CONFIGURATION command.

Unit 2: Maintenance of an Existing Database

• Match Control Center tools with their functions.
• Create a scheduled script using the Script Center.
• Identify which type of logging is required for a given recovery situation.
• Make a copy of a database using the BACKUP DATABASE command.
• Perform the RESTORE procedure using the RESTORE DATABASE command.
• Disengage a connection to DB2 using the FORCE command.
• Capture EXPLAIN data to use with VISUAL EXPLAIN.
• Analyze the access plan from the EXPLAIN tables using the VISUAL EXPLAIN graphical interface.
• Create an Event Monitor using the CREATE EVENT MONITOR statement.
• Collect snapshot data using the GET SNAPSHOT command.
• Change configuration parameters related to performance using DB2 commands.
• Identify the purposes of the DB2 Governor.
• Identify information in the diagnostic file DB2DIAG.LOG.
• Extract data from a table using the EXPORT utility.
• Enter data into a table using the IMPORT utility.
• Enter data into a table using the LOAD utility.
• Select the required data exchange utility for specified criteria.
• Reorganize a table using data organization utilities.
• Update the statistics for database objects using the RUNSTATS command.
• Identify the functions of DB2MOVE and DB2LOOK.

Training Avaliability and Delivery

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English

About 123-CBT Computer Based Training - Training Provider

More IBM DB2 Universal Database V6 1 Training from 123-CBT Computer Based Training

• IBM DB2 Universal Database V6 1 Admin Curriculum
• IBM DB2 Universal Database V6 1 Admin Curriculum
• IBM DB2 Universal Database V6 1 App Devel Curriculum
• IBM DB2 Universal Database V6 1 App Devel Curriculum
• IBM DB2 Universal Database V6 1--Administration
• IBM DB2 Universal Database V6 1--App Development
• IBM DB2 Universal Database V6 1--App Development
• IBM DB2 Universal Database V6 1--Fundamentals
• IBM DB2 Universal Database V6 1--Fundamentals
• IBM DB2 Universal Database V6 1--Fundamentals