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 and OS/390 System Administration

Overview:

Develop the skills you need to evaluate and manage DB2 system functions. Learn how to tailor and install DB2 and its attachment facilities, how to determine system problems, and how to set up security procedures. Learn about DB2 system recovery and system performance tuning. Practice the principles and techniques you learn in the lectures during machine-based lab exercises.

Who Should Take This Course:

Individuals responsible for managing and implementing a DB2 system.

What You Are Taught:

• Select and implement the DB2 functions that best satisfy the site requirements
• Implement effective security procedures for a DB2 environment
• Understand and use the components of a DB2 subsystem and its attachment facilities
  
• Describe and implement DB2 system recovery and restart procedures
• Control and use DB2 trace information
• Understand and use basic DB2 statistical and accounting information to tune DB2 systems
• Administer plans and packages
• Install and operate DB2 and the Internal Resource Lock Manager (IRLM)
• Describe the DB2 basic problem determination tools

Topics Include:

• Basic architecture and fundamental mechanisms, Distributed data, Installation, IRLM, System security,
• DB2 program flow, Time Sharing Option (TSO) and batch environments, Packaging the application
• DB2 authorization, DB2 audit facility, Logging, Application recovery, Transaction flow in Information Management System (IMS) and Customer Information Control System (CICS), Monitoring and controlling DB2, System recovery and restart, Performance, DB2 for Multiple Virtual Storage (MVS)

Prerequisites:

You should complete:

DB2 Family Fundamentals (CF030), DB2 for OS/390 Database Administration Workshop (CF830) or have equivalent experience and understand how DB2 user data objects are created, managed, and recovered.