Book your CV83GB DB2 9 for z/OS Database Administration Workshop Part 1 Training Course
This five day course is being run one times on Monday 23rd of April 2012 in London,
Book this course with us today from as little as £2,100.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses by the manufacturer IBMSee all courses provided by IBM
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Monday 23 April 2012 | London |  | £2,100.00+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
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.
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.
Audience:
Future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
Objectives:
- 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
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
IBM
IBM Training Courses offer comprehensive training designed for individuals, companies and public organisations. IBM courses are worldwide so delegates don’t have to travel far to get the training they require.
IBM training courses are both dynamic and exciting, concentrating on theoretical and practical management training to help delegates meet their objectives and goals. With IBM courses being available worldwide delegates don’t have to travel far to get the training they require.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.