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 for OS/390 Database Administration Workshop

Duration: 4.5 Days

Overview:

Learn how to implement a DB2 for OS/390 physical database design that is based on a completed logical database design. Included in this course are instructions on data management, DB2 catalog tables, and database utilities such as LOAD and REORG, and recovery considerations. It also provides significant hands-on exercises for many of the topics. This course is for DB2 for OS/390 Version 5.

Who Should Take This Course:

DB2 for OS/390 database administrators or anyone else responsible for planning, implementing, and maintaining DB2 for OS/390 database is must.

What You Are Taught:

• Implement a DB2 database design
• Evaluate the performance of a DB2 database design
• Use database utilities to load and reorganize data
• Define and implement a basic database recovery strategy
• Manage access to databases using DB2 authorization facilities

Topics Include:

• Physical Design: table, view, and index objects; tablespaces, indexspaces, storage groups and databases; referential integrity
• Utilities: CHECK DATA and LOAD, REORG and RUNSTATS
• Serialization
• Security
• Performance
• Program Prep and Bind
• Recovery; Data Compression; Managing DB2

Prerequisites:

Ability to:

• Design a relational table
  
• Use the SQL data manipulation statements to access and change the contents of DB2 tables
• Define DB2 security privileges and authorities and use the SQL control statements required to implement this security

You should also take DB2 Fundamentals (CF030) or have equivalent experience.