Cours: IMS Physical Organization of Databases Workshop

This course of 4 sessions, 8 hours each day, teaches how to design, implement, reorganize, and recover Information Management System (IMS) databases. Practice these skills in intensive machine exercises.

Voir ce cours dans d'autres pays

Schémas de filière:

• IMS

Début

This is an intermediate course for database administrators, system programmers, and other data administration individuals, who design, implement, and maintain Data Language One (DL/I) databases.

Début

You should have:

• Basic understanding of IMS product features and organization along with a working knowledge of z/OS tools and Job Control Language (JCL).

Début

• 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 any of the IMS access methods

Début

Introduction to DL/I

• Describe database concepts:
  • Hierarchic structure
  • Segments
  • Database records
  • Segment relationships
  • Database definition (DBDGEN)
  • Program Specification Block (PSB) purpose
  • PSB definition (PSBGEN)
  • Database load

IMS Access Methods

• Describe the structures, characteristics, and features of the IMS physical access methods

HISAM

• Provide overview of the HISAM access method. Include: HISAM storage format, HISAM characteristics, DBD coding, and PSB coding

DBD/PSB/Data Sets/JCL

• Describe the relationships between DBDGEN, PSBGEN, execution JCL, and database data set allocation.

IMS Test Utility: DFSDDLT0

• Code and execute the DL/I test program to: List an entire database, and List selected segments from a database

HD Access Methods

• Describe HD characteristics, pointers, database storage format, freespace, and data sets

HIDAM

• Describe physical data set characteristics of a HIDAM primary index and the HIDAM database
• Code DBDs for a HIDAM database

HDAM

• Describe the characteristics of the HDAM Access Method
• Code a DBD using the various parameters necessary for an HDAM database

Database Reorganization

• Code the JCL and utility control statements to unload and reload a database
• Select from a list of situations or tasks, all of those that would require the HD Reorganization utilities
• List the most important tasks where the HISAM Reorganization utilities might be used
• From a given list, identify the characteristics of a specific Reorganization utility

IMS Data Sets Summary

• Describe the way VSAM KSDS, VSAM ESDS, and OSAM are used by IMS
• List uses of VSAM KSDS freespace and DL/I freespace and describe where to code these two kinds of freespace

Secondary Indexing

• Identify differences between a Secondary Index and a HIDAM Index
• Describe the sequence of utilities required to construct a secondary index database
• State the difference in an application program's processing of a database using the primary processing sequence and using a secondary processing sequence
• Code a DBD with parameters for secondary indexing
• Code a DBD for a Secondary Index database
• Code a PSB for use with a Secondary Index

Database Recovery

• Describe the steps, the utilities, and the frequency considerations required to plan the recovery of an IMS batch application
• Differentiate between full recovery and backout
• Identify the functions and characteristics of a specific database recovery
• Identify the effects of missing logs, redundant logs, and wrong purge date specifications
• List the steps required to recover a database that has become unusable due to a hardware or software error

Database Design Considerations

• List considerations for pointer selection
• Describe which database changes might affect existing application programs and which database changes are transparent to existing application programs
• Identify the steps required to change a database from one IMS access method to another

IMS Space Utilization

• Given a VSAM print of a database, or VSAM PRINTs of related databases:
  • Find the bit maps
  • Find the segments in the databases
  • Follow RBA pointers to related segments

Agenda

Day 1

• Welcome: Administration
• Unit 1: Introduction to DL/I
• Unit 2: IMS Access Methods
• Unit 3: HISAM
• Unit 4: DBD/PSB/Data Sets/JCL
• Unit 5: IMS Test Utility: DFSDDLT0
• Exercise 1: HISAM - Part 1

Day 2

• Exercise 1: HISAM - Part 2
• Exercise Review
• Unit 6: HD Access Methods
• Unit 7: HIDAM
• Unit 8: HDAM
• Unit 9: Database Reorganization
• Exercise 2: HIDAM - Part 1

Day 3

• Exercise 2: HIDAM - Part 2
• Exercise Review
• Unit 10: IMS Data Sets Summary
• Unit 11: Secondary Indexing
• Exercise 3: HDAM, Secondary Indexing - Part 1

Day 4

• Exercise 3: HDAM, Secondary Indexing - Part 2
• Exercise Review
• Unit 12: Database Recovery
• Unit 13: Database Design Considerations
• Unit 14: IMS Space Utilization
• Exercise 4: Recovery
• Exercise Review
• HALDB (Optional)

Début