CMDBID: 68998 | Course Code: CM241G | Duration: 4 Days
Overview>
Learn how to successfully implement and tune Information Management System (IMS) databases with IMS logical relationships. Examine in detail the various pointer options. Practice these skills in intensive machine-lab exercises.
Audience>
People responsible for designing, implementing, maintaining, or tuning IMS databases using logical relationships.
Skills Gained>
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
Prerequisites>
You should have at least four months of experience using IMS and should be able to:
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)
Outline>
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
Our Clients
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.
