IMS Logical Relationships

People responsible for designing, implementing, maintaining, or tuning IMS databases using logical relationships.

• Code the DBDs and PSBs for databases involved in logical relationships, including those using recursive data structures
• Use IMS utilities to load and reorganize logically related databases
• Choose logical relationship update rules based upon application processing requirements
• Identify DBD coding parameters that are critical to the performance of logically related databases
• Interpret the results of logical relationship implementation choices using the reports provided by the IMS Monitor

• Introduction to Logical Relationships
• Unidirectional Logical Relationships
• Unidirectional Logical Data Structures
• Bidirectional Logical Relationships
• Bidirectional Logical Data Structures
• Database Load and Reorganization
• Recursive Structures
• ISRT Rules and Exercise
• Logical Relationship Performance
• Logical Relationship Tuning
• Design and Change Considerations

You should have at least four months of experience using IMS and should be able to:

• • Use TSO/ISPF or PDF
• • Demonstrate basic knowledge of:
  • OS/VS Job Control Language
  • VSAM access methods service utilities
  • DL/I application programming techniques
• Describe the characteristics and storage format of HISAM, HIDAM and HDAM databases and code their DBDs
• Understand the IMS DB Monitor and use its reports to resolve database performance concerns

These skills can be developed by attending:

• IMS Physical Organization of Databases Workshop (CM22)
• IMS Database Performance and Tuning Workshop (CM30)