Interview Questions.

Question 1. What Do You Mean By Include Statement In Jcl?

Answer :

An INCLUDE assertion identifies a member of a PDS that contains this set of JCL statements is referred to as an INCLUDE group. The system replaces the INCLUDE statement with the statements inside the INCLUDE group.

Question 2. What Are S0c1, S0c4, S0c5, S0c7 Abends?

Answer :

S0C1 (Operation Exception Error) - May be because of Missing or misspelled DD name ,Read/Write to unopened dataset ,Reading a dataset opened output mode Writing into a dataset opened input mode ,Called subprogram now not found.
S0C4 may be because of Missing Select statement (in the course of assemble) ,Bad Subscript/index ,Protection Exception Missing parameters on referred to as subprogram ,Read/Write to unopened document ,Move information from/to unopened report;
S0C5 May be due to Bad Subscript/index ,Close an unopened dataset ,Bad go out from a carry out ,Access to I/O region (FD) earlier than examine;
S0C7 can be because of Numeric operation on non-numeric statistics ,Un-initialized operating storage ,Coding beyond the maximum allowed subscript
S0CB is probably because of 1.Division by using Zero.
VSAM Interview Questions
Question three. Why Do You Use A Control Card?

Answer :

A CONTROL CARD can be a member of a PDS or a sequential dataset and is used for storing the date fields, definitions of VSAM documents etc., We use CONTROL CARD because we cannot use an in-movement procedure in a method. Generally you'll be calling a PROC from your JCL and you cannot code instream technique inside the PROC and so that you will point to the dataset, which is known as controlcard.

Question four. How Do You Submit Jcl Via A Cobol Program?

Answer :

In your JCL outline as:

//JOBA JOB 1111,JOB1 //STEP01 EXEC PGM=PROG1 //ddname DD SYSOUT=
(*,INTRDR)....And your COBOL (PROG1) must appear like this: SELECT JCL-FILE ASSIGN TO ddname.
Open this document and write the JCL statements into this file.

Example: MOVE '//TESTJOB JOB 1111,VISVEISH' TO JCL-REC.MOVE '//STEP01 EXEC
PGM=IEFBR14' TO JCL-REC.And near this report. Then TESTJOB could be submitted.

VSAM Tutorial
Question 5. How Do You Submit A Jcl Under Cics Environment?

Answer :

Pass all the JCL codes to a COBOL variable (must be declared the usage of OCCURS clause) and then write the line one at a time to the spool the usage of CICS commands like SPOOLClose, SPOOLOpen and SPOOLWrite. For more assist refer CECI of CICS or CICS guide.

IBM - VSAM Interview Questions
Question 6. What Is The Parameter To Be Passed In The Job Card For The Unlimited Time, Irrespective Of The Job Class?

Answer :

TIME=1440

Question 7. Define Cond Parameter In Jcl?

Answer :

COND is a situation parameter, includes 2 subparameters, 1st - return code from the previous step, 2d - condition. If COND is actual, the step on which COND is coded could be BYPASSED. It is as compared with device go back code of preceding step //STEP1 EXEC PGM=ABCD //STEP2 EXEC PGM=XYZ, cond=(4,lt) STEP 2 may be done whilst machine return code of step1 is less than four.

IBM-CICS Tutorial IBM-CICS Interview Questions
Question 8. What Is Meant By S0c-07 System Abend Codes?

Answer :

S0C7 - Data exception errors - you will get it every time you are trying to move the low values or spaces into the numeric discipline, or examine the numeric fields with low values, or try to perform a little mathematics operations on the low values. To keep away from this you need to always initialize the numeric fields in any other case they will incorporate the low values.

Question 9. How To Pass The Temp Dataset Form One Job Step To Another?

Answer :

By specifying the DISP as PASS for the temp dataset.

 

JCL Interview Questions
Question 10. Write A Jcl To Execute A Job By 7:00 Am On Jan 20,1986?

Answer :

The code is: //*MAIN DEADLINE=(0700,B,012086)

IBM DB2 Tutorial
Question eleven. How Many Types Of Libraries Are There In Jcl?

Answer :

Libraries are of 3 sorts: System

Libraries:- together with SYS1.LINKLIB Private 
Libraries:- Specified in a JOBLIB or STEPLIB DD STATEMENTS.
Temporary Libraries:- Created in a preceding step of the Job.
IBM DB2 Interview Questions
Question 12. What Do You Mean By The Repro Command?

Answer :

Whenever a new cluster is created the usage of IDCAMS, the cluster will be empty. By the usage of REPRO command, we are able to load statistics into the cluster. REPRO is used to:

Copy Datasets (VSAM or NON-VSAM), replica catalogs.
Conversion of sequential and index sequential Datasets to VSAM format.
Backup VSAM catalog
Conversion of VSAM and Index sequential Datasets to sequential layout
Read a backup copy of VSAM catalogs.
VSAM Interview Questions
Question 13. What Do You Mean By Recovery And Speed Parameters In Define Cluster Command?

Answer :

The parameters RECOVERY (default) and SPEED are mutually exceptional. Recovery is used to pre-layout the manipulate areas in the course of the preliminary DataSet load, if the activity fails, you could restart however you have to have a recovery ordinary already written to restart the activity. SPEED does no longer pre-format the CAs. It is advisable that you specify SPEED to speed up your initial records load.

COBOL Tutorial
Question 14. Is It Slower If You Access A Record Through Alternative Index As Compared To Primary Index?

Answer :

Yes it slower because the trade Key might first discover the number one Key, which in turn locates the actual record. It requires two times the number of I/Os.

Question 15. What Do You Mean By A Shareoptions Parameter (shr) In Define Cluster Command?

Answer :

It is used to outline the cross-area and pass-gadget sharing skills of the DataSet. Syntax is SHR (CRvalue CSvalue)

way a couple of read OR unmarried write (read integrity).
Means a couple of study AND unmarried write (Write integrity).
Means Multiple examine AND more than one write.
Is same as 3, which refreshes the buffer with each random get entry to. Default is SHR(1 3).
COBOL Interview Questions
Question sixteen. Explain What Are The Optional Parameters To The Input Dataset While Loading The Empty Cluster With The Data Records?

Answer :

i) Skip and Count :
Syntax:
SKIP(2)
COUNT(four)

In this situation, the first  facts are skipped and the subsequent four statistics are published. The default for SKIP is zero, and for COUNT can be printing data from beginning to quit.

Ii) FromKey and ToKey :
PRINT -
INDATASET (CUSTOMER.KSDS.CLUSTER) -
FROMKEY (111111) -
TOKEY (444444)
Will print all facts with Key fee ranging from 111111 to 444444.
Iii) FROMADDRESS and TOADDRESS.
Iv) FROMNUMBER and TONUMBER.

DB2 Using SQL Tutorial
Question 17. Is Delete Operation Supported In An Esds? Is Rewrite Operation Possible In Esds?

Answer :

The delete operation isn't always supported. Delete operation is not possible in VSAM ESDS. Yes, rewrite operation is possible in an ESDS.

DB2 Using SQL Interview Questions
Question 18. Can You Delete Vsam Files With The Delete Option Of The Disposition Parameter Of Jcl?

Answer :

 

We can't delete, you have to give a separate DELETE command inside the VSAM cluster.

IBM - VSAM Interview Questions
Question 19. What Do You Mean By Gdg In Vsam?

Answer :

GDG means Generation Data Group.

IMS/DB Tutorial
Question 20. Can You Tell Me What Are The Codes Returned By The Ams (get right of entry to Method Services) Command During The Execution In Vsam?

Answer :

Every AMS command troubles a circumstance code. If multiple instructions are being done successively, there is probably a demand to execute or pass certain instructions at the Success or failure of a preceding command. The everyday condition codes lower back through AMS commands are :

0 - The function became finished correctly.
Four - A problem changed into encountered even as executing the feature, WARNING.
Eight - The requested function become completed, however main specifies had been unavoidably bypassed,ERROR.
12 - The requested command could not be achieved because of a logical blunders, SEVERE.
Sixteen - A excessive errors passed off inflicting the the rest of the command flow to be bypassed., FATAL.

IMS/DB Interview Questions
Question 21. Explain In Brief How You Can Create A Vsam File?

Answer :

You use the IDCAMS application with the DEFINE CLUSTER alternative.

Question 22. How Can You Copy To A Vsam Cluster?

Answer :

With the help of the IDCAMS utility with the REPRO option.

Question 23. Can You Tell Me How Many Buffers Are Allocated To Vsam Ksds And Esds?

Answer :

There are 2 records buffers by default for ESDS. For KSDS it allots 2 facts buffers and 1 index buffers. Each buffer is ready 4k.

Mainframe DB2 Interview Questions
Question 24. Explain In Brief What Are The three Types Of Vsam Files?

Answer :

Below are the three forms of VSAM documents.

ESDS (Entry sequenced dataset). DB2 makes use of a special sort of ESDS.
RRDS (Relative report dataset). Records are accessed the usage of a relative variety.
KSDS (Key sequenced dataset) is the maximum not unusual kind encountered. The record sequence is decided via a completely unique key area.
IBM-CICS Interview Questions
Question 25. Explain What Do You Mean By A Upgrade Set In Vsam?

Answer :

The improve set is the listing of all AIXs that VSAM ought to be maintaining for a selected base cluster, so that once data within the base cluster is modified or updated, the AIX documents are also up to date.

Question 26. Explain What Is A Base Cluster In Vsam?

Answer :

The base cluster in VSAM consists of the information aspect as well as the index thing that is required for the number one index of a KSDS.

Question 27. In A Cobol Select Statement, Can You Tell What Is The Organization For A Ksds?

Answer :

For a KSDS, the ORGANIZATION is INDEXED.

JCL Interview Questions
Question 28. In A Cobol Select Statement For A Ksds Can You Tell Me What Are The three Possibilities For Access?

Answer :

The 3 possibilities for ACCESS can be RANDOM, SEQUENTIAL or DYNAMIC.

Question 29. What Will Happen If There Is No Secondary Allocation Made For Datasets?

Answer :

VSAM will inform COBOL software of the problem and terminate the processing of the program.

Question 30. What Do You Mean By Idcams? Explain Its Purpose?

Answer :

IDCAMS, also known as Access Method Services, is used to carry out the subsequent tasks noted under.

Createing a VSAM statistics set, VSAM trade index, or catalog.
Conversion of non-VSAM to VSAM statistics set.
Listing a catalog access for a records set, Dataset/catalog contents.
Copy a Dataset or catalog.
Loading of a VSAM Dataset from VSAM statistics
Renaming of VSAM statistics units.
Question 31. Why Ci And Ca Splits Are Not Possible In Esds And Rrds?

Answer :

In ESDS the new report is added on the cease of last report. And no embedded loose space is allocated on the time of Dataset definition. In the case of RRDS the slots for the information are pre-allotted and so the CI and CA break up isn't always possible.

Question 32. Is It Required That Primary Key Values Have To Be Unique? Do Alternate Key Values Have To Be Unique?

Answer :

Primary Key values ought to continually be specific but change Key values want no longer be specific all the time.

Question 33. What Do You Mean By The Cobol Record Key Clause In Vsam?

Answer :

The RECORD KEY in the SELECT clause identifies the documents Primary Key as it can be made available to the program.

IBM DB2 Interview Questions
Question 34. What Is The Use Of The File Status Clause In The Select Statement In Vsam?

Answer :

The FILE STATUS subject is used to discover the sector that VSAM makes use of to provide data approximately each I/O Operation for the record.

Question 35. To Use The Rewrite Command, How Should The Vsam File Be Opened?

Answer :

It ought to be opened Input/Output mode.

Question 36. What Do You Mean By A Vsam Split?

Answer :

If there is a reminiscence crunch and there isn't always sufficient space in the Control Interval, VSAM performs a Control Interval cut up by means of transferring a few statistics to the free Control Intervals. If there is not a free Control Interval,then VSAM plays a manipulate area break up with the aid of allocating a new manipulate area and transferring 1/2 of the Control Intervals to it.

COBOL Interview Questions
Question 37. Explain The Meaning And Syntax For The Start Command?

Answer :

In VSAM, the START command is used to read aside from the subsequent VSAM document. For this, A cost need to be moved into the RECORD KEY. However, the KEY clause is optional, however it could be used to specify a relational operator.

Question 38. Explain What Is The Meaning Of Dynamic Processing In Vsam?

Answer :

Dynamic processing way one software makes use of both sequential and random processing for a VSAM KSDS record. It is but rarely used in VSAM.

Question 39. Can You Name Some Common Vsam Error Conditions And Codes?

Answer :

They are give up of document (10), replica Key (22), document not found (23), Out of area circumstance is raised (28) ,VSAM common sense blunders (ninety), open hassle (92) and space problem (93).BIt is a COBOL II enhancement to VSAM batch processing expanding the FILE STATUS subject.It is defined in WORKING - STORAGE as a six byte group object with three two byte elements, the everyday return code, the feature code and the feedback code.

Question forty. What Do You Mean By A Vsam Slot?

Answer :

VSAM slot is a relative file Dataset (RRDS) consists of a distinct wide variety of regions called slots. Each slot is diagnosed by a relative document quantity (RRN) which shows its relative role in the document.

DB2 Using SQL Interview Questions
Question 41. Name The Utility Program Closely Associated With Vsam?

Answer :

IDCAMS is the utility, the get right of entry to approach services software.

Question 42. There Are Seven Idcams Commands In Vsam. Can You Name And Explain Each Of Them?

Answer :

ALTER is used for change of information for a catalog, alternate index, cluster or route.
BLDINDEX is used to construct the change index.
DEFINE is used for ALTERNATEINDEX, CLUSTER or PATH.
DELETE is used to take away the catalog entry for a catalog, cluster, exchange index or direction.
LISTCAT is for list Information about the Dataset.
PRINT is used to print the Dataset contents.
REPRO is used to copy records from one report to some other.
IMS/DB Interview Questions
Question 43. Can You Tell Me What Are The Three Levels Of Definition For The Vsam Define?

Answer :

They are INDEX, DEFINE CLUSTER and DATA.

Question 44. Explain What Is The Significance Of The Shareoptions Parameter?

Answer :

SHAREOPTIONS parameter specifies how the report may be shared between jobs and between batch and CICS Environments.

Question forty five. What Do You Mean By Define Model Parameter?

Answer :

DEFINE MODEL parameter specifies whether the MODEL parameter lets in you to model your cluster with the aid of modelling it after an present cluster.

Question 46. Can You Tell Me How Do You Fix The Problem Associated With Vsam Out Of Space Condition?

Answer :

We can repair it with the aid of the subsequent. 

By defining new VSAM Dataset allocated with extra space.
By using IDCAMS to REPRO the old VSAM record to new VSAM Dataset.
By using IDCAMS to ALTER / rename the vintage VSAM Dataset or set IDCAMS to DELETE the vintage VSAM Dataset.
By the use of IDCAMS to ALTER / rename the brand new VSAM Dataset to the name of the authentic VSAM Dataset.
Question forty seven. Explain How Many Ways You Can Load Data In A Vsam Cluster?

Answer :

 There are two ways to gain that.Firstly by way of the usage of the REPRO command and secondly through the use of COBOL software.

 

Question 48. What Will Happen When You Try To Open An Empty Vsam File In A Cobol Program For Input?

Answer :

A VSAM report that has never contained a document is treated as unavailable. Attempting to open for input will fail. An empty document may be opened for output handiest. When you open for output, COBOL will write a dummy document to the document & then delete it out.

Question forty nine. Explain How Can You Initialize A Vsam File Before Any Operation?

Answer :

You can write a dummy program to be able to just open the file for output and thereafter closes it.

Question 50. Can You Tell Me What Does A File Status Of 02 On A Vsam Signifies?

Answer :

It indicates reproduction exchange key. It occurs on each enter and output operation.

Question 51. How Can You Load A Vsam Data Set With Records ?

Answer :

For loading we are able to use the REPRO command.

Question 52. Differentiate Between Sequential Files And Esds Files In Vsam?

Answer :

In VSAM, Sequential(QSAM) documents may be created on tape whilst ESDS documents can't be created. Again, you may have ALTINDEX for an ESDS even as no such facility that exists for QSAM documents.

Question fifty three. Explain How Do You Define A Gdg In Vsam?

Answer :

We can use the DEFINE GENERATIONDATAGROUP command. In the same IDCAMS step, another dataset should be defined whose DCB parameters are used while new generations of the GDG are created. This dataset is called the model dataset. The ds name of this version dataset have to be similar to that of the GDG, so use a disp of preserve in place of catlg and also specify space=(trk,0) 

Question 54. Is It Necessary That All Versions Of The Gdg Have To Be Of The Same Record Length?

Answer :

It isn't always required, the DCB of the version dataset may be overridden whilst you allocate new variations.

Question fifty five. Explain In Brief How Are Different Versions Of Gdg Named?

Answer :

base-record-name.GnnnnnV00 wherein nnnn= technology wide variety (upto 255). Nnnn may be 0000 for the first technology.

Question fifty six. What Are The Additional Information You Should Give In The Dd Statement While Defining The Next Generation Of A Gdg?

Answer :

Give (+1) as the generation quantity, supply (new,catlg) for disp, supply area parameter, can provide the dcb parameter if you want to override the dcb of the version dataset.

Question 57. When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File’s Organisation ?

Answer :

You can use the LISTCAT command.

Question fifty eight. What Are The Different Types Of Vsam Datasets?

Answer :

Entry sequenced Datasets (ESDS),
Key sequenced Datasets (KSDS) and relative record
Dataset (RRDS), LDS (linear Data Set)
Question fifty nine. Can You Tell Me How Are Records Stored In An Esds, Entry Sequenced Dataset?

Answer :

They are saved with out admire to the contents of the data and inside the order in which they're protected inside the record.

Question 60. Explain In Brief Why Do Vsam Take More Disk Space Than Other Utilities?

Answer :

VSAM will increase the disk area necessities of structures. This is because VSAM gives positive abilties like partial self-reorganization to make matters more green in records units that may be modified.

Question sixty one. Can You Specify Some The Distinctive Features Of A Ksds, Key Sequenced Dataset?

Answer :

The index and the distributed unfastened area. CI and CA splits upon updates. Record length can be modified in the course of the time of update. The information are accessed by a particular Key in KSDS.