IMS Physical Organization of Databases Workshop [TDS_CM22G]

OVERVIEW

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

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

OBJECTIVES

• 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

AUDIENCE

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

CONTENT

• 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