In JCL, Region is an Optional Keyword Parameter which can be specified at JOB and/or Step Level. Region Parameter in JCL indicates that the amount of storage (Virtual or Real) that the JOB or step can use to execute. It specifies an upper limit of memory to be used and thus the job/step can use
CICS Scenario Based Interview Questions Apart from the basics, CICS has scope to ask many questions by giving a scenario. Here I am giving the list of few scenario based ones. I have two CICS PROGRAMS – PROGA & PROGB. 1st Prog should pass some data to Program B and using this data Program B
Apart from reading forward, VSAM KSDS file can be read Backwards starting from a specified Key value. READPREV command is used for this purpose. To read a record in reverse order starting from a key needs to establish a starting point first which can be done using STARTBR, then READNEXT and READPREV does the backwards
VSAM Share Options defines the VSAM datasets accessibility among different users. Share options are like the DB2 locking system, by using these options different levels of shared access can be given to different jobs/users on a single VSAM dataset. Where to Set these options? Can be set while defining the VSAM cluster using IDCAMS. These
Restart Logic in COBOL DB2 Program: Restarting a program when it has abended after processing some number of records becomes necessary many times as it would be waste of resources to process them again. Rolling back the processed records is also a headache if there is no logic to start the program from the next
JCL SPACE Parameter is one of the important parameters to be specified for a NEW dataset which request the storage required for that dataset on a Direct Access Volume. SPACE Parameter in JCL is an Optional Keyword parameter that indicates the OS, the amount of memory allocation needed for a dataset while creating it and
Below are the few Tricky ones faced at CapGemini. 1. I have 1000 steps in a cataloged procedure. I want to run only a few steps (say from 8th step to 16th Step). How this can be achieved? 2. A cobol db2 program takes a flat file as input and updates a DB2 table and
TIME Parameter in JCL is a Keyword parameter which indicates the Processor Time required to execute the job/step in a JCL. This can be used either in JOB or in STEP or in both the places. If it is specified in a JOB, it tells the systems that this job can use the specified amount
DB2 stored procedures mainframe–> Stored procedures are the programs that contains one or more SQL statements to perform a business functionality and can be called by any application with SQL call statements. These are ALSO considered as the programs that are compiled and stored in a DB2 server which can be called/INVOKED from any application
JCL DISP (Disposition) parameter is a Keyword parameter which is used to describe the status of a data set used in JCL to the OS. It indicates the OS on what should be done with the dataset after JOB/STEP termination. It has 3 sub parameters which indicates THE STATUS,Normal & abnormal termination ACTIVITIES of the
