Microtek Learning Logo

Db2 12 for zOS Advanced Database Administration Training

4.7
(4.7)

Db2 12 for zOS Advanced Database Administration Training is developed to help professionals gain comprehensive knowledge about advanced database administration skills, including online schema changes, stored procedures, partition management, and the use of packages.

  • Category : IBM

Course Price : $1674 Per Participant

Course Description

Db2 12 for zOS Advanced Database Administration Training is developed to help professionals gain comprehensive knowledge about advanced database administration skills, including online schema changes, stored procedures, partition management, and the use of packages.

This technical training program also familiarizes you with the availability and performance features of the utilities. To train all your employees at once, you can check out our enterprise training program.

It provides comprehensive information on program preparations, partition management, and online schema change processes and strategies.

Db2 12 for zOS Advanced Database Administration Training is suitable for database administrators who want to improve their skills and build credibility.

In this course, you will learn about REORG features and processes such as LOAD and REBUILD INDEX, and UNLOAD overview and processes.

It also provides in-depth information on native procedure deployment and stored procedures. 

Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Deploying the native procedure.
  • green-tick Preparing program and utilizing the packages.
  • green-tick Elaborating about UNLOAD processes and its overview.
  • green-tick REORG processes and features.
  • green-tick REBUILD AND LOAD INDEXES.
  • green-tick Managing partition and storing procedures.
  • green-tick Changing strategies for an online scheme and other processes.

Prerequisites

  • Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
  • Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements
  • Basic skills in administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.

Who should attend this course?

The target audience for Db2 12 For ZOS Advanced Database Administration Training are professionals working as Database Administrators.

Schedules

Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

Curriculum

  • Program preparation overview
  • Execution time errors
  • BIND actions
  • Package status and REBIND
  • Deleting a package
  • Determining the table/view qualifier
  • Changing data type
  • Adding columns to a table
  • Renaming columns in a table
  • Renaming indexes
  • Adding columns to indexes
  • Versioning
  • Pending online schema changes
  • Dropping columns from a table
  • Converting to UTS
  • Other pending changes
  • Impact of pending changes on immediate options
  • Restrictions and considerations
  • Adding partitions
  • Rotating partitions
  • Modifying limit keys
  • Rebalancing partitions
  • External stored procedures
  • WLM-established application environments
  • Altering and dropping a stored procedure
  • Commands for stored procedures
  • Execution privileges
  • Catalog information
  • LOAD and REBUILD INDEX
  • LOAD with parallel index build
  • LOAD partitions in parallel
  • REBUILD INDEX
  • Inline image copies and statistics
  • LOAD SHRLEVEL CHANGE
  • LOAD REPLACE SHRLEVEL REFERENCE
  • Performance features of REORG
  • Online REORG
  • Inline image copies and statistics
  • Considerations for PBG table spaces
  • Online REORG with LOBs (optional)
  • Overview
  • Image copy specification
  • Table-only input specification
  • SHRLEVEL option
  • Modes of operation
  • Table mirroring
  • Package versioning
  • Plan management
  • Other REBIND PACKAGE options
  • Application compatibility
  • Native stored procedures
  • Native procedure deployment
  • Course Details

    • enroll enroll-green
      Enrolled: 1291
    • duration duration green
      Duration: 2 Days

    Talk to Learning Advisor