IBM IMS Essentials Part 1: IMS Database Manager

Rating:
Summary: IBM IMS Essentials Part 1: IMS Database Manager
Review: Course Overview
In IBM IMS Essentials Part 1: Database Manager, you are introduced to the IMS Database Manager. IMS hierarchical databases are covered, and the Data Language/I (DL/I) function codes used to query and update the databases within application programs. You are introduced to database change logging and the various database recovery utilities used in IMS. Finally, you learn about IMS hierarchic access methods and about optimizing DL/I access methods. This course is current to IMS v.8, but generally applicable to v.7 and beyond.

Learn To

To identify features of Information Management System (IMS).
To identify components of IMS.
To identify advantages of a database.
To identify features and functions of the application control block generation (ACBGEN) utility.
To identify elements of a Data Language/I (DL/I) program.
To identify the Common Business-Oriented Language (COBOL) code for defining a program communication block (PCB) mask.
To identify parts of a Data Language/I (DL/I) database segment.
To identify types of IMS hierarchic access methods.
To identify features of the Hierarchical Sequential Access Method (HSAM).
To identify reasons for using a logical database.
To identify characteristics of a secondary index.
To identify reasons for using sparse indexing.

Audience
The primary audience includes users who want a basic understanding of the IMS Database (IMS DB) and IMS Transaction Manager (IMS TM) products. Additionally, data processing individuals who work with an IMS system, whether Database (DB), Database/Data Communications (DB/DC), or Database Control Subsystem (DBCTL). Learners should be able to describe the fundamentals of data processing, including the function of operating systems, access methods and Job Control Language (JCL). These skills can be obtained from on-the-job experience.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Introduction to IMS Database Manager 1.5 - 2 hours

Identify features of Information Management System (IMS).
Identify components of IMS.
Identify advantages of a database.
Identify features and functions of Data Language/I (DL/I).
Identify limitations of a traditional system.
Identify benefits of a database environment.
Match components of the IMS hierarchical database model with their descriptions.
Identify impacts of adding an application in a database environment.
Identify advantages of data independence.
Identify features and functions of the database description generation (DBDGEN) utility.
Identify features and functions of the program specification block generation (PSBGEN) utility.

Unit 2: IMS Database Handling 1.5 - 2 hours

Identify features and functions of the application control block generation (ACBGEN) utility.
Identify elements of a Data Language/I (DL/I) program.
Identify the Common Business-Oriented Language (COBOL) code for defining a program communication block (PCB) mask.
Identify the key aspects of the application interface block (AIB) used to access a database.
Identify parameters of a Data Language/I (DL/I) call.
Identify features and functions of a segment search argument (SSA).
Identify links in the control-block relationships in Data Language/I (DL/I).
Identify uses of GET UNIQUE (GU) calls.
Identify uses of GET NEXT(GN) calls.
Identify requirements for updating, inserting, or deleting a segment.
Identify functions of the database change accumulation utility used to consolidate database changes.
Identify basic Data Language/I (DL/I) function codes.
Identify functions of the database recovery utility.
Identify the key aspects of Multiple Virtual Storage (MVS) access methods used to move data to buffers.
Identify characteristics of a test Data Language/I (DL/I) DLT0 program.
Identify circumstances when a database may need to be recovered.
Identify functions of the Image Copy utility used to back up a database.

Unit 3: IMS Access Methods 1.5 - 2 hours

Identify parts of a Data Language/I (DL/I) database segment.
Identify types of IMS hierarchic access methods.
Identify features of the Hierarchical Sequential Access Method (HSAM).
Identify features of the Hierarchical Indexed Sequential Access Method (HISAM).
Identify considerations for migrating a Data Language/I (DL/I) database to a High Availability Large Database (HALDB).
Identify features and functions of the Generalized Sequential Access Method (GSAM).
Identify features and functions of a High Availability Large Database (HALDB).
Identify advantages of the Hierarchical Direct Access Method (HDAM).
Identify advantages of the Hierarchical Indexed Direct Access Method (HIDAM).

Unit 4: Other DL/I Functions 1.5 - 2 hours

Identify reasons for using a logical database.
Identify characteristics of a secondary index.
Identify reasons for using sparse indexing.
Identify characteristics of a variable-length segment.
Identify advantages of segment compression.