ZL1_CM22

Ladda ner som PDF

IMS Physical Organization of Databases Workshop

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

Målgrupp

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

Förkunskaper

You should have:

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

Course 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

 Course 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

Course 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

 Course 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

Utbildningen levereras i samarbete med

Kurs-ID: ZL1_CM22
Längd: 4 dag
Pris exkl moms: 26 500 kr

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Ort och datum

Stockholm
3 apr-6 apr
Boka nu!

Tipsa