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 1

Duration: 4.5 Days
Delivery Method: Classroom (Hands-on Lab)
Skill Level: Intermediate

Overview:

Learn how to physically implement a logical database design in DB2. Learn about DB2 data management, DB2 catalogue tables, recovery considerations, the bind process, database utilities such as LOAD, REORG, COPY, RECOVER, RUNSTATS and security considerations. A significant hands-on exercise on most of the topics is offered. Learn about DB2 Universal Database (UDB) for OS/390 Version 7.
IACET Continuing Education Units 3.6

Who Should Take This Course:

DB2 UDB for z/OS and OS/390 database administrators or individuals who need to acquire the basic skills required to administer a DB2 Database.

What You Are Taught:

Define and maintain the objects that make up a DB2 database, Describe how data is stored in a DB2 database, Resolve referential and check constraint violations, Load external sequential input data into DB2 tables, Gather statistics about DB2 data, Reorganize DB2 data, Unload DB2 data in external format, Define the basic principles of DB2 recovery, Recover a damaged table space to current, Compress data, Describe the fundamental difference between static and dynamic SQL programs, Describe the process to bind a DB2 application program, Control access to DB2 objects, Describe the basic access paths used by DB2, Describe basic DB2 serialization concepts

Topics Include:

• DB2 Objects, Storage Groups, Databases, Tables, Indexes, Referential integrity, Getting data into and out of DB2, Keeping your DB2 data in good shape, Application data recovery basics, Compression, Program preparation, Security, Access Paths, Serialization

Prerequisites:

You should complete:

• DB2 Family Fundamentals (CF030)
• DB2 SQL Workshop (CF120)

Or have equivalent experience. You should also be able to:

• Design a relational table
  
• Use the Structured Query Language (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