YouTube Icon

Interview Questions.

Ibm-jcl&vsam Placement Papers - Ibm-jcl&vsam Interview Questions and Answers - Jul 28, 2022

fluid

Ibm-jcl&vsam Placement Papers - Ibm-jcl&vsam Interview Questions and Answers

Q1. Explain In Brief What Are The three Types Of Vsam Files?

Below are the three sorts of VSAM files.

ESDS (Entry sequenced dataset). DB2 uses a unique form of ESDS.

RRDS (Relative report dataset). Records are accessed the usage of a relative wide variety.

KSDS (Key sequenced dataset) is the maximum common kind encountered. The file collection is determined through a completely unique key discipline.

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

There are 2 records buffers with the aid of default for ESDS. For KSDS it allots 2 records buffers and 1 index buffers. Each buffer is set 4k.

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

They are give up of report (10), duplicate Key (22), report no longer observed (23), Out of space condition is raised (28) ,VSAM good judgment mistakes (90), open hassle (92) and area trouble (93).BIt is a COBOL II enhancement to VSAM batch processing expanding the FILE STATUS discipline.It is defined in WORKING - STORAGE as a six byte group item with 3  byte factors, the regular go back code, the characteristic code and the feedback code.

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

It must be opened Input/Output mode.

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

VSAM will increase the disk area requirements of structures. This is due to the fact VSAM gives positive abilities like partial self-reorganization to make things extra green in information units that may be changed.

Q6. Name The Utility Program Closely Associated With Vsam?

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

Q7. What Do You Mean By Include Statement In Jcl?

An INCLUDE assertion identifies a member of a PDS that contains this set of JCL statements is called an INCLUDE organization. The machine replaces the INCLUDE assertion with the statements inside the INCLUDE institution.

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

It is used to define the cross-region and cross-device sharing abilties of the DataSet. Syntax is SHR (CRvalue CSvalue)

me more than one examine OR unmarried write (study integrity).

Me more than one examine AND unmarried write (Write integrity).

Me Multiple study AND a couple of write.

Is equal as 3, which refreshes the buffer with every random get entry to. Default is SHR(1 three).

Q9. What Is Meant By S0c-07 System Abend Codes?

S0C7 - Data exception errors - you may get it every time you are attempting to move the low values or spaces into the numeric discipline, or compare the numeric fields with low values, or attempt to do a little mathematics operations on the low values. To keep away from this you have to always initialize the numeric fields otherwise they may contain the low values.

Q10. What Is The Parameter To Be Passed In The Job Card For The Unlimited Time, Irrespective Of The Job Class?

TIME=1440

Q11. What Do You Mean By The Repro Command?

Whenever a brand new cluster is created the use of IDCAMS, the cluster can be empty. By using REPRO command, we're able to load data into the cluster. REPRO is used to:

Copy Datasets (VSAM or NON-VSAM), copy 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 replica of VSAM catalogs.

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

The index and the distributed unfastened space. CI and CA splits upon updates. Record period can be modified all through the time of replace. The statistics are accessed by using a selected Key in KSDS.

Q13. Define Cond Parameter In Jcl?

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

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

For a KSDS, the ORGANIZATION is INDEXED.

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

Dynamic processing me one program uses each sequential and random processing for a VSAM KSDS record. It is but rarely used in VSAM.

Q16. Can You Tell Me What Are The Three Levels Of Definition For The Vsam Define?

They are INDEX, DEFINE CLUSTER and DATA.

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

For loading we can use the REPRO command.

Q18. How Many Types Of Libraries Are There In Jcl?

Libraries are of 3 types: System

Libraries:- which includes SYS1.LINKLIB Private 

Libraries:- Specified in a JOBLIB or STEPLIB DD STATEMENTS.

Temporary Libraries:- Created in a previous step of the Job.

Q19. Explain The Meaning And Syntax For The Start Command?

In VSAM, the START command is used to read apart from the subsequent VSAM document. For this, A price have to be moved into the RECORD KEY. However, the KEY clause is non-obligatory, but it could be used to specify a relational operator.

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

We can restore it by using the subsequent. 

By defining new VSAM Dataset allocated with greater space.

By the usage of IDCAMS to REPRO the old VSAM document to new VSAM Dataset.

By the use of IDCAMS to ALTER / rename the antique VSAM Dataset or set IDCAMS to DELETE the antique VSAM Dataset.

By using IDCAMS to ALTER / rename the new VSAM Dataset to the name of the original VSAM Dataset.

Q21. What Do You Mean By Recovery And Speed Parameters In Define Cluster Command?

The parameters RECOVERY (default) and SPEED are collectively distinctive. Recovery is used to pre-format the manipulate regions in the course of the preliminary DataSet load, if the activity fails, you could restart however you must have a restoration routine already written to restart the process. SPEED does no longer pre-format the CAs. It is really useful that you specify SPEED to speed up your initial facts load.

Q22. Can You Tell Me What Are The Codes Returned By The Ams (get entry to Method Services) Command During The Execution In Vsam?

Every AMS command problems a circumstance code. If more than one commands are being carried out successively, there might be a demand to execute or pass certain instructions on the Success or failure of a previous command. The ordinary condition codes lower back through AMS instructions are :

0 - The characteristic was carried out effectively.

Four - A hassle became encountered at the same time as executing the function, WARNING.

Eight - The asked function turned into finished, however principal specifies were necessarily bypassed,ERROR.

12 - The requested command couldn't be finished because of a logical error, SEVERE.

16 - A extreme mistakes happened inflicting the the rest of the command circulate to be bypassed., FATAL.

Q23. In A Cobol Select Statement For A Ksds Can You Tell Me What Are The three Possibilities For Access?

The three opportunities for ACCESS may be RANDOM, SEQUENTIAL or DYNAMIC.

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

The RECORD KEY inside the SELECT clause identifies the files Primary Key because it can be made available to this system.

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

ALTER is used for modification of information for a catalog, exchange index, cluster or path.

BLDINDEX is used to construct the exchange index.

DEFINE is used for ALTERNATEINDEX, CLUSTER or PATH.

DELETE is used to eliminate the catalog access for a catalog, cluster, alternate index or course.

LISTCAT is for listing Information approximately the Dataset.

PRINT is used to print the Dataset contents.

REPRO is used to copy records from one document to another.

Q26. Explain How Do You Define A Gdg In Vsam?

We can use the DEFINE GENERATIONDATAGROUP command. In the same IDCAMS step, any other dataset must be described whose DCB parameters are used when new generations of the GDG are created. This dataset is called the model dataset. The ds call of this model dataset should be similar to that of the GDG, so use a disp of keep in preference to catlg and additionally specify area=(trk,zero) 

Q27. Explain How Can You Initialize A Vsam File Before Any Operation?

You can write a dummy application in an effort to simply open the document for output and thereafter closes it.

Q28. Explain In Brief How Are Different Versions Of Gdg Named?

Base-report-name.GnnnnnV00 in which nnnn= technology variety (upto 255). Nnnn may be 0000 for the 1st era.

Q29. Explain What Do You Mean By A Upgrade Set In Vsam?

The improve set is the list of all AIXs that VSAM ought to be maintaining for a specific base cluster, so that after statistics in the base cluster is changed or updated, the AIX files also are updated.

Q30. What Do You Mean By Idcams? Explain Its Purpose?

IDCAMS, additionally referred to as Access Method Services, is used to perform the following tasks stated underneath.

Createing a VSAM information set, VSAM alternate index, or catalog.

Conversion of non-VSAM to VSAM facts set.

Listing a catalog entry for a information set, Dataset/catalog contents.

Copy a Dataset or catalog.

Loading of a VSAM Dataset from VSAM statistics

Renaming of VSAM data sets.

Q31. What Do You Mean By Define Model Parameter?

DEFINE MODEL parameter specifies whether the MODEL parameter permits you to model your cluster by using modelling it after an existing cluster.

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

VSAM will tell COBOL software of the problem and terminate the processing of this system.

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

By specifying the DISP as PASS for the temp dataset.

 

Q34. What Are S0c1, S0c4, S0c5, S0c7 Abends?

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 right into a dataset opened input mode ,Called subprogram no longer discovered.

S0C4 may be because of Missing Select announcement (all through bring together) ,Bad Subscript/index ,Protection Exception Missing parameters on called subprogram ,Read/Write to unopened report ,Move data from/to unopened document;

S0C5 May be due to Bad Subscript/index ,Close an unopened dataset ,Bad exit from a carry out ,Access to I/O vicinity (FD) earlier than read;

S0C7 can be due to Numeric operation on non-numeric data ,Un-initialized running storage ,Coding past the most allowed subscript

S0CB is probably because of 1.Division by Zero.

Q35. Explain What Is A Base Cluster In Vsam?

The base cluster in VSAM consists of the statistics element in addition to the index aspect this is required for the number one index of a KSDS.

Q36. How Can You Copy To A Vsam Cluster?

With the assist of the IDCAMS software with the REPRO alternative.

Q37. Differentiate Between Sequential Files And Esds Files In Vsam?

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

Q38. Write A Jcl To Execute A Job By 7:00 Am On Jan 20,1986?

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

Q39. How Do You Submit A Jcl Under Cics Environment?

Pass all of the JCL codes to a COBOL variable (should be declared the usage of OCCURS clause) after which write the line one by one to the spool the usage of CICS commands like SPOOLClose, SPOOLOpen and SPOOLWrite. For extra assist refer CECI of CICS or CICS manual.

Q40. What Are The Different Types Of Vsam Datasets?

Entry sequenced Datasets (ESDS),

Key sequenced Datasets (KSDS) and relative report

Dataset (RRDS), LDS (linear Data Set)

Q41. Explain What Are The Optional Parameters To The Input Dataset While Loading The Empty Cluster With The Data Records?

I) Skip and Count :

Syntax:

SKIP(2)

COUNT(four)

In this example, the primary  facts are skipped and the subsequent 4 data are published. The default for SKIP is 0, and for COUNT will be printing information from beginning to stop.

Ii) FromKey and ToKey :

PRINT -

INDATASET (CUSTOMER.KSDS.CLUSTER) -

FROMKEY (111111) -

TOKEY (444444)

Will print all statistics with Key price starting from 111111 to 444444.

Iii) FROMADDRESS and TOADDRESS.

Iv) FROMNUMBER and TONUMBER.

Q42. How Do You Submit Jcl Via A Cobol Program?

In your JCL define as:

//JOBA JOB 1111,JOB1 //STEP01 EXEC PGM=PROG1 //ddname DD SYSOUT=

(*,INTRDR)....And your COBOL (PROG1) must appear to be this: SELECT JCL-FILE ASSIGN TO ddname.

Open this record and write the JCL statements into this report.

Example: MOVE '//TESTJOB JOB 1111,VISVEISH' TO JCL-REC.MOVE '//STEP01 EXEC

PGM=IEFBR14' TO JCL-REC.And close this report. Then TESTJOB could be submitted.

Q43. Is It Slower If You Access A Record Through Alternative Index As Compared To Primary Index?

Yes it slower because the trade Key could first locate the number one Key, which in flip locates the actual document. It requires twice the range of I/Os.

Q44. What Do You Mean By Gdg In Vsam?

GDG me Generation Data Group.

Q45. Why Do You Use A Control Card?

A CONTROL CARD may be a member of a PDS or a sequential dataset and is used for storing the date fields, definitions of VSAM files and many others., We use CONTROL CARD because we can't use an in-move technique in a process. Generally you will be calling a PROC out of your JCL and also you cannot code instream process in the PROC and so you will point to the dataset, that is referred to as controlcard.

Q46. Can You Delete Vsam Files With The Delete Option Of The Disposition Parameter Of Jcl?
 

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

Q47. Explain How Many Ways You Can Load Data In A Vsam Cluster?

 There are  approaches to gain that.Firstly with the aid of using the REPRO command and secondly by way of the usage of COBOL application.

 

Q48. Explain What Is The Significance Of The Shareoptions Parameter?

SHAREOPTIONS parameter specifies how the record can be shared between jobs and between batch and CICS Environments.

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

Give (+1) as the era wide variety, supply (new,catlg) for disp, supply area parameter, can deliver the dcb parameter if you need to override the dcb of the version dataset.

Q50. Explain In Brief How You Can Create A Vsam File?

You use the IDCAMS software with the DEFINE CLUSTER alternative.




CFG