DB2 UDB for z/OS Database Administration II (CF84AAU)

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 is a continuation of course CF83 and is designed to teach you how to perform additional database administration tasks. CF84 also covers several of the topics introduced in CF83 in much more depth.
Audience DB2 UDB for z/OS database administrators who have the basic skills required to administer a DB2 database and want to extend their skills.
Prerequisites Students should have attended course CF83AAU - DB2 UDB for z/OS Database Administration Workshop: P1 (V8), or have attained a similar level of experience.
Objectives Upon completion of the course, the student should be able to:
· Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages
· Alter table characteristics such as data types of columns and identify the impact of making such changes
· Alter indexes to add columns or to change the varying length or clustering characteristics of the index, and identify the impact of making such changes
· React to the "Advisory Reorg" Database Exception Table state
· Make appropriate decisions to successfully handle table space versions
· Use parallel index build with the LOAD, REORG and REBUILD INDEX utilities
· Load partitions in parallel
· Determine the appropriate LOAD options to use while considering concurrency and performance requirements
· Choose appropriate options with REORG and UNLOAD to achieve optimal performance and availability
· Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
· Provide appropriate LISTDEF, TEMPLATE, and OPTIONS utility control statements for use in DB2 utilities
· Determine the applicability and implement user defined data types, user defined functions, stored procedures, triggers, and large objects

Contents This course covers the following major topics:
· Program preparation and use of packages
· Online schema enhancements
· Utility performance and availability features
· Partition management
· Generic utility jobs
· UDTs, UDFs, and stored procedures
· Triggers
· Large objects
· Performance-related topics


...''

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

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 Workshop - Part I (CF83AAU)
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)
QMF/SQL for End Users (U4507AU)

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.