 |
 |
 |
 |
 |
| Oakwood Computing Ltd 1 Dornton Road South Croydon Surrey CR2 7DR UK Tel: +44 (0) 20 8686 7266 courses@oakwoodcomputing.co.uk |
| Updated 17 November, 2003 |
IMS DB/DC programming
Duration: 5 days
Audience: Programmers who will be working with IMS/DB and IMS/DC
Prequisites: Good working knowledge of COBOL or PL/1
IMS/DC can be omitted, reducing the course duration to 4 days
Objectives: Top
Contents
On successful completion of this
course each student will be able to:
* explain the meaning of database terminology such as segment,
parentage, hierarchical path, PCB, PSB, DBD, ACB
* identify the principal database access methods and describe their use
* explain how segments are arranged in a database record
* given a description of segments in a database record, draw the appropriate
hierarchical chart
* list the calls which a program can issue to a database
* code calls which retrieve and update a database
* code qualified and unqualified SSAs
* use command codes within SSAs
* use boolean operators to form compound conditions in SSAs
* translate, compile,
and execute a program which processes the database
* describe how a database program may be tested
* explain how a database program should be modified if it is to operate under
CICS
* use the EXEC DLI interface
* explain how logically related databases are used
* describe the function and use of a secondary index
* state how parallel processing may be carried out
* describe the function of the I/O PCB mask
* code system service calls such as CHKP, XRST, ROLL, ROLB, ROLS
* use utility programs such as DFSDDLT0
* describe
the functions of: MID, MOD, DIF, DOF
* describe how IMS handles online message
processing
Contents: Top
Objectives
Introduction
Database records, segments, fields, keys, hierarchical structures, root, dependent,
twin, parent, child, hierarchical order, hierarchical path, access methods
(e.g. HIDAM, HDAM), DBD, PCB, PSB, ACB; IMS Connect for Web access; HALDB
(IMS Version 7).
Programming interface
Coding the PCB mask; accessing IMS from COBOL, PL/1, Assembler; specifying
segment search arguments; IMS calls: retrieving, inserting, deleting, replacing
segments; feedback area, status codes, error handling; command codes; path
calls; EXEC DLI; AIB and CEETDLI interfaces; CICS interface, sync points;
JCL needed to run batch programs, required libraries.
Advanced topics
Logically related databases; logical child, logical parent, physical child,
physical parent, logical relationships; secondary indexing, PROCSEQ; system
service calls: CHKP, XRST, SYNC, PCB, TERM, GSCD, INQY, STAT, SNAP, ROLB,
ROLL, ROLS, INIT, LOG, SETS, SETU; utility programs and tasks: DBDGEN, PSBGEN,
processing options, CMPAT=YES, DFSDDLT0, DFSRRC00.
IMS/DC
Components of an DB/DC system, control region, MPR, BMP, logs, database recovery
control, Fast Path; message queue, how IMS handles a message, message scheduling,
classes, priority, WFI; programming with IMS/DC, the I/O PCB mask, message
areas within the program, calls which access the message queue, status codes;
Message Format Services, DIFs, DOFs, MIDs, MODs, cursor control, attribute
management, repeated groups, DO, STACK usage; Alternate PCBs;
integrity, commit and backout, checkpoint and restart calls.
Top Objectives Contents
