VSAM Interview Questions and Answers For Experienced | Mostly Asked in An Interview | Mainframe Guru

VSAM Interview Questions and Answers For Experienced | Mostly Asked in An Interview | Mainframe Guru
Q1. Is VSAM a database? And why do we use VSAM?
Q2. Is it necessary that data loaded into a vsam file should have sorted key?
Q3. How can we edit the VSAM File?
Q4. What is differences between Control Interval (CI) and Control Area (CA)?
Q5. What is the ORGANIZATION for a KSDS in COBOL SELECT statement?
Q6. What do you think will be the output if an empty VSAM file is opened in a COBOL program?
Q7. Why do we use the REPRO command?
Q8. What is REPLACE in VSAM dataset?
Q9. VSAM File Status - 21, 22, 23, 24, 02, 98
Q10. What are Functions of ESDS, KSDS, RRDS?
Q11. Which type of VSAM file are supported by CICS?
Q12. Can we use the Join Key on VSAM files?
Q13. Why do we use Alternate Index? How can we create an AIX?
#VSAMinterview, #VSAMInterviewQuestions, #MainframeGuru

[@AbhiChopade]

its helpful

[@udayakiranupanayan]

Pls upload more interview real time scenario imsdb,cics brother

[@MainframeGuru]

Yes Udaykiran, we will upload the video regarding IMS DB & CICS soon. Thank You.

[@muthulakshmi2217]

Why we can use only vsam files in CICS

[@MainframeGuru]

Thanks @Muthu Lakshmi for watching the video. I think that we use the VSAM files in CICS because it makes easier for application program to execute an input-output operation. VSAM is a high performance access method used to organize data in form of files in Mainframes. VSAM is used by COBOL and CICS in Mainframes to store and retrieve data. All the files used in CICS application, should be registered in FCT with the complete attributes. CICS commands use the FCT entries to get the file DSN and for performing the operations on the file. All the best for your future. 🙏

[@sanjyottambekar7895]

In a Vsam file how to change the single record without copying the file into another file?

[@MainframeGuru]

Thanks Sanjyot for watching the video. You can use the fileaid tool to edit/change the record.🙏

[@MainframeGuru]

You can also change like below. //STEP02 EXEC PGM=FILEAID //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSLIST DD SYSOUT=* //SYSABEND DD SYSOUT=* //SYSOUT DD SYSOUT=* //DD01 DD DSN=INPUT.FILE,DISP=OLD //SYSIN DD * $$DD01 UPDATE KEY=C'IND #########KB',IN=1,REPL=(121,C'Y') //*

[@adeshtiwari5152]

how to insert a record in between KSDS file?

[@MainframeGuru]

You can insert the records manually through FileAid based on the primary key sort data. KSDS VSAM key contains the data in the sorted order. So If you will try to insert record manually, then it would check the key sequence (i.e. whether data is in sorted order based on key). Next way is to use the repro replace command through IDCAMS utility. All the best for your future. 🙏