DB2 UDB for z/OS Database Administration Workshop - Part I (CF83AAU)

IBM Australia Ltd
Sydney,Melbourne,PERTH,BRISBANE,CANBERRA CITY, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Duration 5.0 Day(s)
Description 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 UDB for z/OS Version 8 level.

Audience Future DB2 UDB 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 (CF03AU) and DB2 SQL
· Workshop (CF12AU) or have equivalent experience

Objectives 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 or delimited input data into DB2 tables
· Gather statistics about DB2 data
· Reorganize DB2 data
· Unload DB2 data in external or delimited 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.

Contents The course contains the following units:
· Introduction
· DB2 Objects
· Referential Integrity
· Getting Data into and out of DB2
o SQL INSERT, DELETE and UPDATE
o Introduction to Utilities
o LOAD Utility
o Ensuring Referential and Check Constraints
o The UNLOAD Utility
· Keeping your DB2 data in good shape
o Running RUNSTATS
o REORG
o History Statistics
· Application Data Recovery Basics
· ESA Data Compression
· Program Preparation / Bind
· Security
· Serialization

The course also includes extensive machine lab exercises, which gives 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:
o LOAD and CHECK DATA
o RUNSTATS, REORG and UNLOAD
o COPY and RECOVER
o DB2 security
o DB2 locking

...''

Phone:1800 801 088

School Address:

IBM Australia Ltd
Level 13
IBM Centre
601 Pacific Highway
St Leonards NSW 2065.
Tel:1800 801 088

Jobs & Resumes: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY
Houses & Roommates: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY

IBM DB2 OLAP Server: Administration and Partitioning (DW62AU)
Accessing the DB2 UDB for iSeries Database using SQL (OL37AU)
DB2 Family Fundamentals (CF03AU)
DB2 SQL Workshop (CF12AU)
DB2 SQL Workshop for Experienced Users (CF13AAU)
DB2 UDB for OS/390 Data Sharing Implementation Workshop (CF35AU)
DB2 for OS/390 Data Sharing Recovery and Restart Workshop (CF36AU)
DB2 Stored Procedures Programming Workshop (CF71AU)
DB2 UDB Control Centre and GUI Tools for OS/390 DBAs (CF72AU)
DB2 Universal Database Programming Workshop for z/OS (CF82AU)
DB2 UDB for z/OS Database Administration II (CF84AAU)
DB2 UDB for z/OS System Administration (CF85AU)
DB2 UDB for z/OS and OS/390 Application Data Recovery (CF89AU)
DB2 UDB for z/OS and OS/390 System/Disaster Recovery Workshop (CF91AU)
DB2 UDB Server for z/OS Application Performance and Tuning (CF96AAU)
DB2 UDB for z/OS and OS/390 Version 7 Transition (CG37AU)
DB2 UDB for z/OS Version 8 Transition (CG38AU)
DB2 UDB for z/OS System Performance Analysis (CG88AU)
IBM DB2 V8 for z/OS Functions (ITS406AU)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.