Apt Panel: Offshore & Onsite Advanced Professio-nal Training on technical skills and soft-skills for freshers and entry- level executives. >>more

CTCPanel: Comprehensive Training for Corporate facilitates organizational development by imparting high quality technical and soft-skills to the employees. >>more

Mentor (University and College partnership program) University and College partnership program-offers on-campus training on IBM Mainframe, Microsoft-Technologies, Java etc well-supported by soft-skills training modules. Presently, offering program support in South Asia and South-East Asia. >>more

DB2 UDB for Z/OS & OS/390 Database Administration Workshop – Part 2

Overview:

Learn how to further implement a DB2 UDB for OS/390 physical database design based on those topics covered in:

• DB2 for OS/390 Database Administration Workshop (CF830)

Explore a continuation of topics including recovery and utilities, focusing on new functionality, and performance estimations. The following UDB relational Object-Oriented (OO) features are discussed: User-Defined Distinct Types (UDT), User-Defined Distinct Functions (UDF), Triggers, and Large Objects (LOB), along with the causes and remedies of common locking problems. Also, learn the implementation of stored procedures, packages, and UDFs.
IACET Continuing Education Units: 3.2

Who Should Take This Course:

Database administrators responsible for planning, implementing, and maintaining DB2 UDB for OS/390 databases.

What You Are Taught:

Implement recovery to a prior point-in-time, Use enhanced features of database utilities to load, reorganize, copy, and recover data, Estimate the performance of DB2 utilities, Define and implement UDB object-oriented features (UDTs, UDFs, Triggers, LOBs), Implement and manage programming features (packages, UDFs, Stored Procedures), Solve common locking Problems

Topics Include:

Recovery of data to a prior point-in-time

Performance and availability of the following utilities:

REBUILD INDEX, COPY, RECOVER, LOAD, REORG, RUNSTATS

Utility CPU and elapsed time estimations

Administration of relational object oriented features:

User-Defined Distinct Types (UDTs), User-Defined Distinct Functions (UDFs), Stored Procedures, Triggers, Large Objects (LOBs), Package Implementation, Resolution of common locking problems

Prerequisites:

You should complete:

DB2 for OS/390 Database Administration Workshop (CF830)