Learn how to design, implement, reorganize, and recover Information Management System (IMS) databases. Practice these skills in intensive machine labs.

• Code the Database Directories (DBD) and Program Specification Blocks (PSB) for physical databases
• Code the DBDs and PSBs to implement secondary indexing
• Use the appropriate IMS utilities to reorganize and recover physical databases, including those with secondary indexes
• Use the DL/I test program
• Prepare a job stream to load a database using different IMS access methods

This is a basic level course for database administrators, system programmers, and other data administration individuals, who design, implement, and maintain IMS databases.

You should have:

• basic understanding of IMS database features and organization along with a working knowledge of z/OS tools, Virtual Storage Access Method (VSAM) services utilities, and Job Control Language (JCL)

• Introduction to DL/I
• IMS Access Methods
• HISAM
• DBD/PSB/Data Sets/JCL
• IMS Test Utility: DFSDDLT0
• HD Access Methods
• HIDAM
• HDAM
• Database Reorganization
• IMS Data Sets Summary
• Secondary Indexing
• Database Recovery
• Database Design Considerations
• IMS Space Utilization

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.