IMS DB FOR MAINFRAME By Simon Sara Books,

SpÃ©cification du produit

Audience: Adult
Genre: Science Technology
Brand Name: Simon Sara

Book :ims db
Book:mainframe

La description

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

Pays:	India
N Â° de modÃ¨le:	-
Prix FOB:	90 / Piece (Negotiable) Obtenir le dernier prix
LocalitÃ©:	BANGALORE
Prix de commande minimale:	90 per Piece
Commande minimale:	1 Set
Packaging Detail:	HARDCOPY BOOK
Heure de livraison:	5 DAYS
Capacité de Fournir:	50 Piece per Week
Payment Type:	Other, Money Gram, Western Union
Groupe de produits :	-