This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | 3V830 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 5.0 days | Delivery type | Instructor Led - Online Training
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $3,250.00 plus tax | ||
This course is the Instructor On Line (ILO) version of CV830.
This is an online course. Please do not make travel arrangements for this course.
After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
Note: This course material is at the DB2 9 for z/OS level.
View this course in other countries
Training Paths that reference this course are:
Audience
This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
Prerequisites
Before taking this course, you should be able to:
- Design a relational table
- Describe the SQL data manipulation statements to access and change the contents of DB2 tables
You should also take DB2 Family Fundamentals (CE03) and SQL Workshop (CE12), or have equivalent experience.
Skills taught
After completing this course, you should be able to:
- Define and maintain the objects that make up a DB2 database
- Resolve referential and check constraint violations
- Load external sequential input data into DB2 tables
- Gather statistics about DB2 data
- Reorganize DB2 data
- Unload DB2 data in external format
- Recover a damaged table space to current
- Compress data
- Bind a DB2 application program
- Control access to DB2 objects
- Describe basic DB2 serialization concepts
Course outline
Introduction
- Describe what DB2 for z/OS is at an overview level
- Understand the fundamental differences between static and dynamic SQL programs
- Define the major responsibilities of any application program
- Define the major responsibilities of the DB2 system
- Understand the basic principles of DB2 Recovery
- Discuss the basic roles people will play in a DB2 shop
Setting up a DB2 database
- Describe the DB2 objects that make up a DB2 database
- Select parameters for these DB2 database objects so that they are implemented with the most appropriate attributes
- Create storage groups, databases, table spaces, tables, views, synonyms, aliases, materialized query tables, and indexes
- Alter the attributes of DB2 database objects as requirements change over time
- Describe how data is stored in a DB2 database
Implementing unique and referential requirements
- Describe the concepts of PRIMARY KEY, UNIQUE KEY, and FOREIGN KEY
- Implement these keys in DB2
- Implement REFERENTIAL CONSTRAINTS on new or existing tables with the appropriate DELETE rules
- Discuss identity columns and sequence objects
Getting data into and out of DB2
- Describe how DB2 utilities may be executed, monitored, terminated, and restarted
- Run the DB2 LOAD utility and make full use of its many features
- Run the CHECK DATA utility to check DB2 table space data for any violations of referential integrity constraints or table check constraints
- Run the DB2 UNLOAD utility, and make full use of its many features
Keeping your DB2 data in good shape
- Describe and interpret the statistics collected by RUNSTATS and real-time statistics
- Run RUNSTATS with an appropriately chosen set of options
- Describe why it is necessary to periodically REORG your table spaces and indexes
- Run REORG with an appropriately chosen set of options
Application data recovery basics
- Make DB2 user data available again following media failures.
Program preparation / bind
- Describe the main steps needed to prepare a program with embedded static SQL to access DB2.
Security
- Describe DB2 global security
- Describe the various DB2 authids and how they are established
- Understand how DB2 security controls access to data
- Describe and implement DB2 privileges and authorities appropriately
- Describe how ownership is established in DB2
- Describe DB2 authorization checking
- Describe and implement security for plans and packages
- Describe multilevel security
- Describe the advantages and considerations for using the RACF / DB2 external security module
Serialization
- Describe concurrency
- Explain the aspects of transaction locks
- Tell when locks are acquired and released
- Describe S and X locks
- Explain isolation levels
- Explain LOCKSIZE
Agenda
Day 1
- Welcome
- Introduction
- Unit 2 (topic 1) - Overview of setting up a DB2 database
- Unit 2 (topic 2) - Storage groups, databases, and table spaces
- Lab 1
- Lab 1 review
- Unit 2 (topic 3) - Tables
- Lab 2
- Lab 2 review
Day 2
- Unit 2 (topic 5) - Views, synonyms, and aliases
- Lab 3
- Lab 3 review
- Unit 2 (topic 6) - Materialized Query Tables
- Unit 2 (topic 7) - Indexes
- Lab 4
- Lab 4 review
- Unit 2 (topic 8) - Additional information
Day 3 Unit 3 - Referential integrity
- Lab 5
- Lab 5 review
- Unit 3 - Identity columns and sequences
- Unit 4 - Getting data into and out of DB2
- Lab 6
Day 4
- Lab 6 review
- Unit 5 - Keeping your DB2 data in good shape
- Lab 7
- Lab 7 review
- Unit 6 - Application data recovery basics
- Lab 8
- Lab 8 review
Day 5
- Unit 7 - Program preparation
- Unit 8 - Security
- Lab 9
- Lab 9 review
- Unit 9 - Serialization
- Lab 10
- Lab 10 review
Remarks
This is an Instructor Led On Line course. Please do not make travel arrangements for this course. Your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. All Instructor Led On Line US courses start at 9:00 am Central time. Materials are not guaranteed to be delivered to student, if registration is received three business days before class start date.
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
