DB2 10 for zOS Database Administration Part 2

Course Description

You will learn new database administration responsibilities in this course, which is an extension of DB2 10 for zOS Database Administration Workshop Part 1 (CV831).

Prerequisites

It is expected that you either took the course DB2 10 for zOS Database Administration Workshop Part 1 (CV831) or have equivalent expertise.

Target Audience

Database administrators and system programmers who want to learn more about database administration tasks should take this intermediate course. The DB2 10 for z/OS environment is used for the course lab exercises.

Learning Objectives

  • Executing program preparation steps including resolving common problems, defining collections & packages, & versioning of packages
  • Altering table characteristics such as data types of columns & identify the impact of making such changes
  • Altering indexes to add columns or to change the varying length & clustering characteristics of the index, & identify the impact of making such changes
  • Reacting to the "Advisory Reorg" Database Exception Table state
  • Making appropriate decisions to successfully handle table space versions
  • Giving the usage of the data. Determining an appropriate option for dealing with the need for adding partitions & rebalancing data partitions.
  • Determining the applicability and implement clone tables, user-defined distinct types, user-defined functions, stored procedures, triggers, & large objects

Content Outline

  • Welcome
  • Unit 1:- Transition from DB2 9 for zOS Database Administration Workshop Part-1 (CV830) to DB2 for zOS Database Administration Workshop Part-2 (CV841)
  • Unit 2:- Program Preparation and Use of Packages
  • Exercise 1:- Program Preparation
  • Unit 3:- Online Schema Changes
  • Exercise 2:- Online Schema Changes
  • Unit 4: Clone Tables
  • Exercise 3: Clone Tables
  • Unit 5: Partition Management
  • Exercise 4: Partition Management
  • Unit 6: UDTs and UDFs
  • Exercise 5: UDTs and UDFs
  • Unit 7: Stored Procedures
  • Exercise 6: Stored Procedures
  • Unit 8: Triggers
  • Exercise 7: Triggers
  • Unit 9: Large Objects
  • Exercise 8: LOBs

FAQs

IBM created the Db2 family of data management tools, which includes database servers. Although it was originally designed to serve the relational model, it has now been expanded to include object-relational functionality as well as non-relational structures like JSON and XML.

You can realize the benefits of using Db2 Multisystem in several ways:

Query performance can be improved by running in parallel (pieces of the query are run simultaneously on different systems).

The need for data replication decreases because all of the systems can access all of the data.

Much larger database files can be accommodated.

Applications are no longer concerned with the location of remote data.

When growth is needed, you can redistribute the file across more systems, and applications can run unchanged on the new systems

To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.

We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, if due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.

Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.

Participants can easily access these labs over Cloud with the help of remote desktop connection.

Radiant virtual labs provides you the flexibility to learn from anywhere in the world and in any time zone.

The learners will be enthralled as we engage them the real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.

Radiant Telelearning offers customized solutions and training programmed for individuals, teams and businesses depending upon what they require. Here is how we help each one through our diverse formats.

Individuals / One-O-One Training

▪ Focused learning sessions

▪ Programmed scheduling according to your choice

▪ Get personalized attention

▪ Choose what technology interests you

Teams: Enroll for our Classroom or online Public Batches

▪ Get our specialized updated content for different skill levels

▪ Get on-demand learning and solve problems quickly

▪ Get help from the ground level through sequential learning

Enterprise:

▪ Get customized training programmed and solutions that can be curated especially for your business

▪ Meet needs of all learners

▪ Let your employees be geared up for all kinds of problem solving

▪ Inspire your teams for future

▪ Update your employees with latest information stretching from technology, business leadership to marketing

Radiant Telelearning has a large pool of in-house certified trainers & consultants with strong background and working experience on the technology.

Radiant Telelearning offers more than 800+ courses and for each course Radiant have identified best-in-class instructors.

Radiant has highly intensive selection criteria for Technology Trainers & Consultants, who deliver you training programs. Our trainers & consultants undergo rigorous technical and behavioral interview and assessment process before they are on boarded in the company.

Our Technology experts / trainers & consultants carry deep dive knowledge in the technical subject & are certified from the OEM. Our faculty will provide you the knowledge of each course from fundamental level in an easy way, and you are free to ask your doubts any time from your respective faculty.

Our trainers have patience and ability to explain difficult concepts in a simplistic way with depth and width of knowledge.

Radiant believes in a practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover, training courses are undertaken by some of the experts who are having vast range of experience in their domain.

Send a Message.


  • Enroll