Kursen har inget datum. Ring vår kursbokning 077 186 10 37 för information om en privat utbildning.
Översikt
| Kurskod | CV830SE | Leveranstyp | Classroom
(Hands-on labs) |
|---|---|---|---|
| Kurslängd | 5.0 dagar | Kurstyp | |
| Listpris | Set by Partner |
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.
Målgrupp
Future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
Förkunskaper
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.
Mål
- 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
Nyckelområden
The course contains the following units:
- Introduction
- Setting up a DB2 database
- Overview of setting up a DB2 database
- Storage groups, databases, and table spaces
- Tables
- Data compression
- Views, synonyms, and aliases
- Materialized Query Tables
- Indexes
- Additional information
- Referential integrity
- Referential integrity
- Informational RI constraints
- Identity columns and sequences
- Getting data into and out of DB2
- SQL INSERT, DELETE, and UPDATE
- Introduction to utilities
- LOAD utility
- Ensuring referential and check constraints
- UNLOAD utility
- Keeping your DB2 data in good shape
- RUNSTATS
- REORG
- Real time statistics
- Application data recovery basics
- Program preparation / bind
- Security
- Serialization
The course also includes extensive machine lab exercises which give you the opportunity to gain hands-on experience of:
- Creating and using databases, table spaces, tables, views, and indexes
- Defining check and referential constraints
- Creating and running the following utility jobs:
- LOAD, CHECK DATA, and UNLOAD
- RUNSTATS and REORG
- COPY and RECOVER
- DB2 security
- DB2 locking