IMS DB FOR MAINFRAME

الوصف

This Book provides Background of databases, Background of IMS databases, IMS database concepts, IMS Segments and Fields, COBOL Coding for IMS, Secondary Index databases, Checkpoint & Restart, GSAM databases, JCL for IMS DB programs,  Application Programming for IMS, DBDGEN & PSBGEN Coding, Access Method of IMS Databases, Utility Programs, Database Recovery & DBRC, Sample IMS-DB programs, Sample JCLs, Sample PSBLIB & DBDLIBs, Sample Coding for AIBTDLI, IMS Database browsing, IMS Status Codes, Exercises & Answer Keys, Acronyms and Glossary for IMS terminologies.

CONTENTS
IMS DATABASE FOR COBOL PROGRAMMING    
CHAPTER 1: BACKGROUND OF DATABASES    
1.    WHAT IS DATABASE    
2.    OVERVIEW OF DATABASE
3.    WHAT IS DBMS    
4.    COMPONENTS OF DBMS    
5.    3 TYPES OF DATABASE STRUCTURES    
6.    DATABASE STRUCTURES – RELATIONAL & HIERARCHICAL    
7.    ADVANTAGES & DISADVANTAGES OF RELATIONAL VS HIERARCHICAL    
8.    RELATIONAL VS. HIERARCHICAL DATABASES    
9.    HOW TO SELECT DBMS    
*0.    DESIGN CONSIDERATIONS    
*1.    NORMALIZATION OF DATA    
CHAPTER 2: BACKGROUND OF IMS DATABASES    
1.    WHAT IS IMS    
2.    WHAT IS IMS DB    
3.    FUNCTIONS OF IMS DATABASE MANAGER    
4.    3 TYPES OF IMS HIERARCHICAL DATABASES    
5.    "FULL FUNCTION" DATABASES    
6.    "FAST PATH" DATABASES    
7.    HIGH AVAILABILITY LARGE DATABASES (HALDBS)    
8.    IMPLEMENTATION OF IMS DATABASES    
9.    IMS AND DB2    
*0.    IMS DB & DC SYSTEMS    
*1.    IMS OVERVIEW    
*2.    IMS COMPONENTS    
*3.    SEGMENT EDIT/COMPRESSION    
*4.    DATA RELATIONSHIPS    
*5.    HIERARCHICAL SEQUENCE    
*6.    HIERARCHICAL DATA PATH    
*7.    SEQUENCE / KEY FIELD    
*8.    POINTERS    
*9.    DEDB DATA ENTRY DATABASES    
*0.    PROCESS FLOW DIAGRAM FOR IMS DB & DC    
*1.    PROCESS FLOW COMPONENTS    
*2.    RUNNING OF IMS SUBSYSTEMS    
CHAPTER 3: IMS DATABASE CONCEPTS    
1.    IMS PROCESSING MODES    
2.    WHAT IS BMP    
3.    WHAT IS DL/I    
4.    BMP VS DLI
5.    BMP & RESTART    
6.    SCHEDULING A BMP    
7.    CONTROL BLOCKS – DBD AND PSB    
8.    DATABASE DESCRIPTION GENERATION (DBDGEN)    
9.    VARIABLE LENGTH SEGMENTS    
*0.    LOGICAL DATABASE    
*1.    LOGICAL RELATIONSHIPS    
*2.    PROGRAM SPECIFICATION BLOCK GENERATION (PSBGEN)    
*3.    APPLICATION CONTROL BLOCK GENERATION (ACBGEN)    
*4.    PROCOPT – PROCESSING OPTION PARAMETER IN PSB    
*5.    SECONDARY PROCOPT    
*6.    PROCOPT – N & T    
*7.    DL/I POSITIONING CONCEPT    
*8.    MULTIPLE DATABASE POSITIONING    
CHAPTER 4: IMS SEGMENTS & FIELDS    
1.    IMS DATABASE ORGANIZATION    
2.    RETRIEVAL OF SEGMENTS    
3.    SEGMENTS & FIELDS    
4.    SEGMENT TYPE & SEGMENT OCCURRENCE, LEVELS    
5.    ROOT, DEPENDANT, PARENT & CHILD SEGMENTS    
6.    DATABASE RECORDS    
7.    TWINS AND PATH    
8.    RANDOM ACCESS & CONCATENATED KEY    
9.    STANDARD FILE AND DLI DATABASE PROCESSING    
*0.    STANDARD FILE AND DLI DATABASE PROCESSING – SCHEMATIC DIAGRAMS    
*1.    SEGMENT STORAGE    
*2.    STORING IMS DATA – VSAM ESDS    
CHAPTER 5: COBOL CODING FOR IMS    
1.    ENTRY & GOBACK    
2.    PCB MASKS IN ENTRY STATEMENT    
3.    ENTRY STATEMENT AND CBLTDLI CALL    
4.    PL/I CALL    
5.    FUNCTION CODE    
6.    GU CALLS
7.    GU / GN CALLS – EXAMPLE    
8.    RETRIEVE 2ND & 3RD SEGMENT USING GU CALLS – EXAMPLE    
9.    GN CALLS    
*0.    GNP CALLS    
*1.    GNP CALL – EXAMPLE    
*2.    GHU / GHN / GHNP – GET HOLD CALLS    
*3.    GHN / GHNP CALLS – EXAMPLE    
*4.    ISRT CALLS    
*5.    ISRT CALLS – EXAMPLE    
*6.    INSERT RULE OPTIONS IN DBD    
*7.    DLET CALLS    
*8.    GHU / DLET CALLS – EXAMPLE    
*9.    GHN / GHNP CALLS – EXAMPLE    
*0.    GHU / DLET CALLS – EXAMPLE    
*1.    REPL CALLS    *9
*2.    GHU / REPL CALLS – EXAMPLE    
*3.    SYSTEM SERVICE CALLS    
*4.    CHKP CALLS    
*5.    CHKP CALL FORMAT    
*6.    XRST CALLS    
*7.    XRST CALL FORMAT    
*8.    STAT CALLS    
*9.    CHNG / ISRT / PURG CALLS AND ALTERNATE PCB    
*0.    CHNG / ISRT / PURG CALLS AND ALTERNATE PCB – EXAMPLE    
*1.    PCB MASK    
*2.    SEGMENT IO AREA    
*3.    QUALIFIED / UNQUALIFIED CALLS    
*4.    2 TYPES OF CALLS – EXAMPLE    
*5.    SSA – SEGMENT SEARCH ARGUMENTS    
*6.    UNQUALIFIED SSA – EXAMPLE    
*7.    QUALIFIED SSA – EXAMPLE    
*8.    QUALIFIED & UNQUALIFIED SSA’S COMBINED – EXAMPLE    
*9.    MULTIPLE QUALIFICATION    
*0.    QUALIFIED SSA BOOLEAN OPERATION – EXAMPLE    
*1.    COMMAND CODES    
*2.    COMMAND CODE – EXAMPLE    
*3.    CONCATENATED KEY ‘C’ COMMAND CODE – EXAMPLE    
*4.    ‘D’ – PATH CALL COMMAND CODE    
*5.    PATH CALL ‘D’ COMMAND CODE – EXAMPLE    
*6.    PATH CALL ‘D’ COMMAND CODE EXCLUDING MIDDLE SEGMENT – EXAMPLE    
*7.    SET PARENTAGE ‘P’ COMMAND CODE    
*8.    SET PARENTAGE ‘P’ COMMAND CODE – EXAMPLE    
*9.    ‘N’ – PATH CALL IGNORE COMMAND CODE    
*0.    ‘F’ – FIRST OCCURRENCE COMMAND CODE    
*1.    ‘L’ – LAST OCCURRENCE COMMAND CODE    
*2.    ‘–’ NULL COMMAND CODE    
*3.    F / ‘–’ COMMAND CODES – EXAMPLES    
*4.    ‘L’ COMMAND CODE – EXAMPLE    
*5.    U / V COMMAND CODES    
*6.    U / V COMMAND CODES – EXAMPLES    
*7.    Q COMMAND CODE    
CHAPTER 6: SECONDARY INDEXING DATABASES    
1.    INDEX DATABASES    
2.    SECONDARY INDEXING    
3.    SECONDARY DATA STRUCTURE    
4.    SECONDARY INDEXING    
5.    SECONDARY INDEXING – SCHEMATIC DIAGRAM 1    
6.    INDEX POINTER, INDEX SOURCE & INDEX TARGET SEGMENTS    
7.    SECONDARY KEY &  SECONDARY DATA STRUCTURE    
8.    SECONDARY DATA STRUCTURE – SCHEMATIC DIAGRAM    
9.    SECONDARY INDEXING BASED ON DEPENDANT SEGMENT    
*0.    SECONDARY INDEXING – SCHEMATIC DIAGRAM 2    
*1.    INDEPENDENT AND OPERATOR ‘#’    
*2.    ADVANTAGES OF AIB    
*3.    INQY CALL FOR AIBTDLI    
*4.    SUBFUNCTIONS OF INQY CALL    
CHAPTER 7: CHECKPOINT & RESTART    
1.    CHECKPOINT TYPES – BASIC & SYMBOLIC    
2.    SYMBOLIC CHECKPOINT & RESTART CALLS    
3.    CHECKPOINT & RESTART    
4.    ACTIONS ON CHECKPOINT TAKEN AND ABNORMAL TERMINATION    
5.    ADVANTAGES OF CHECKPOINT
6.    REQUIREMENT FOR CHECKPOINT    
7.    CHECKPOINT FREQUENCY    
8.    NORMAL START & RESTART    
9.    CHECKPOINT RECORDS IN IMSLOGR DDNAME / DASD    
*0.    CHKP CALL FORMAT    
*1.    XRST CALL FORMAT    
*2.    CKPTID VALUE DURING NORMAL START IN JCL PARM PARAMETER    
*3.    CKPTID VALUE DURING RESTART IN JCL PARM PARAMETER    
CHAPTER 8: GSAM DATABASES    
1.    GSAM    
2.    WHAT IS GSAM    
3.    PROCESSING GSAM DATABASES    
4.    GSAM FILE & RECORD SEARCH ARGUMENT (RSA)    
CHAPTER 9: JCL FOR IMS DB PROGRAMS    
1.    RUN IMS APPLICATION PROGRAM USING IMS LOADER PROGRAM DFSRRC*0.    
2.    REGION TYPE    
3.    DFSRRC*0 FORMAT & PARAMETERS    
4.    DDITV*2 DDNAME IN IMS-DB2 JCL    
5.    DDOTV*2 DDNAME IN IMS-DB2 JCL    
6.    RUN IMS-DB2 PROGRAM USING IMS LOADER PROGRAM DFSRRC*0, IMS DB2 LOADER PROGRAM DSNMTV*1 & DB2 INITIALIZATION MODULE DSNMIN*0    
7.    DFSVSAMP CODING    
8.    DFSRESLB DDNAME DATASETS    
9.    IMSLOGR LOG DATASET    
*0.    IEFRDER LOG DATASET    
*1.    IMSACB DDNAME DATASETS    
*2.    DBB    
*3.    DFSTAT DDNAME IN JCL    
*4.    IMS DDNAME DATASETS    
*5.    DYNALLIB DATASETS    
*6.    APPLICATION GROUP NAME (AGN) EXIT ROUTINE (DFSISIS0)    
*7.    APPLICATION CONTROL BLOCKS (ACB)    
*8.    JCL FOR IMS-DB PROGRAM    
CHAPTER *0: APPLICATION PROGRAMMING FOR IMS DB    
1.    APPLICATION PROGRAMMING USING BATCH CHECKPOINT/RESTART    
2.    COMPILE IMS PROGRAM    
3.    PASSING PARAMETER TO IMS COBOL PROGRAM USING SYSIN    
4.    PASSING PARAMETER TO IMS COBOL PROGRAM USING APARM    
5.    DATABASE DRIVEN PROGRAMS    
6.    FILE DRIVEN PROGRAMS    
7.    DLI BATCH UPDATE PROGRAMS    
CHAPTER *1: DBDGEN & PSBGEN CODING    
1.    IMS DATABASE CODING – DBDLIB
2.    DBDLIB CODING – SEGM    
3.    DBDLIB CODING – PTR    
4.    DBDLIB CODING – COMPRTN    
5.    DBDLIB CODING – FIELD    
6.    DBDLIB CODING – PTR    
7.    DBDLIB CODING – FIELD STATEMENT    
8.    DBDLIB CODING – /CK & /SK FIELDS    
9.    DBDLIB CODING – LCHILD    
*0.    XDFLD
*1.    TYPE – DATA TYPE PARAMETER IN DBDLIB    
*2.    PSBLIB CODING    
*3.    PSBLIB CODING – CMPAT=YES    
*4.    IO PCB CODING    
*5.    ALTERNATE PCB CODING    
*6.    GSAM PCB CODING    
CHAPTER *2: ACCESS METHODS    
1.    DATABASE ORGANIZATION / ACCESS METHODS    
2.    HDAM    
3.    HIDAM    
CHAPTER *3: IMS UTILITY PROGRAMS    
1.    IMS MODULES    
2.    DATABASE LOAD PROGRAM (DFSDDLT0)    
3.    DATABASE IMAGE COPY UTILITY (DFSUDMP0)    
4.    DATABASE RECOVERY UTILITY (DFSURDB0)    
5.    DATABASE CHANGE ACCUMULATION UTILITY (DFSUCUM0)    
6.    DATABASE BATCH BACKOUT UTILITY (DFSBBO*0)    
7.    DATABASE IMAGE COPY UTILITY (DFSUDMP0)    
CHAPTER *4: DATABASE RECOVERY AND DBRC    
1.    IMS RECOVERY    
2.    RECON DATASETS    
3.    DATABASE RECOVERY    
4.    WHEN RECOVERY NEEDED    
5.    DATABASE RECOVERY CONTROL (DBRC)    
6.    DATABASE REGISTERED TO DBRC    
7.    DBRC – DATABASE RECOVERY CONTROL FACILITY    
APPENDIX A – SAMPLE PROGRAMS    
I.    SAMPLE IMS-DB READ PROGRAM    
II.    SAMPLE IMS-DB UPDATE PROGRAM WITH CHECKPOINT – RESTART LOGIC    
APPENDIX B – SAMPLE JCLS    
I.    SAMPLE JCL TO RUN IMS-DB PROGRAM    
II.    SAMPLE JCL TO RUN IMS-DB PROGRAM WITH DB2    
III.    SAMPLE JCL TO UNLOAD IMS DATABASE    
IV.    SAMPLE JCL TO LOAD IMS DATABASE    
V.    SAMPLE JCL TO RELOAD IMS DATABASE    
VI.    SAMPLE JCL TO TAKE IMAGE COPY OF IMS DATABASE    
VII.    SAMPLE JCL TO REORG THE IMS DATABASE    
VIII.    SAMPLE JCL FOR RECOVERY OF IMS DATABASE
IX.    SAMPLE JCL TO BACKOUT IMS DATABASES AFTER PROGRAM HAS UPDATED IN ITS PRIOR STEP    
X.    SAMPLE JCL TO ACCUMULATE IMS LOG RECORDS    
XI.    SAMPLE JCL TO MONITOR & LOGGING FACILITY    
APPENDIX C – SAMPLE PSBGEN AND DBDGEN    
I.    SAMPLE PSBLIB    
II.    SAMPLE PSBLIB FOR IMS DATABASE WITH SECONDARY INDEX DATABASES    
III.    SAMPLE DBDLIB FOR IMS DATABASE & GET ROOT SEGMENT    
IV.    SAMPLE DBDLIB FOR IMS DATABASE FOR SECONDARY INDEXING WHERE INDEX SOURCE AND TARGET SEGMENTS ARE SAME USING PRIMARY KEY & GET INDEX POINTER SEGMENT    
V.    SAMPLE DBDLIB FOR IMS DATABASE FOR SECONDARY INDEXING WHERE INDEX SOURCE AND TARGET SEGMENTS ARE SAME USING SECONDARY KEY & GET INDEX POINTER SEGMENT    
VI.    SAMPLE DBDLIB FOR IMS DATABASE FOR SECONDARY INDEXING WHERE INDEX SOURCE AND TARGET SEGMENTS ARE DIFFERENT & GET TARGET SEGMENT    
VII.    SAMPLE DBDLIB FOR IMS DATABASE FOR SECONDARY INDEXING WHERE INDEX SOURCE AND TARGET SEGMENTS ARE DIFFERENT & GET INDEX POINTER SEGMENT    
APPENDIX D – AIBTDLI CALL FOR GETTING ADDRESS OF SECONDARY INDEX DATABASE PCB SINCE SECONDARY INDEX DB PCBS WILL NOT BE PASSED FROM PSB    
APPENDIX E – IMS DATABASE BROWS