VSAM Interview Questions And Answers
VSAM Interview Questions and Answers will guide us now that Virtual storage access method (VSAM) is an IBM disk file storage access method, first used in the OS/VS2 operating system, later used throughout the Multiple Virtual Storage (MVS) architecture and now in z/OS. Originally a record-oriented filesystem, VSAM comprises four data set organizations: KSDS, RRDS, ESDS and LDS. So learn Virtual storage access method by this VSAM Interview Questions with Answers guide
1 ► What are the different types of VSAM files available?
2 ► What is IDCAMS?
3 ► Can AMS commands be run from the TSO prompt?
4 ► Syntax of AMS modal commands?
5 ► Under IDCAMS , multiple functions can be executed, each of which returns a cond code. What will be the condition code returned to the operating system?
6 ► What is Control Interval, Control Area?
7 ► What is FREESPACE?
8 ► How do you decide on optimum values for CI, FREESPACE etc?
9 ► Would you specify FREESPACE for an ESDS?
10 ► What is SHAREOPTS?
11 ► What is the meaning of each of the values in SHAREOPTS(2 3)?
12 ► How do you define a KSDS?
13 ► How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgms?
14 ► What happens when you open an empty VSAM file in a COBOL program for input?
15 ► How do you initialize a VSAM file before any operation? a VSAM with alternate index?
16 ► What does a file status of 02 on a VSAM indicate?
17 ► What are the types of VSAM datasets?
18 ► How are records stored in an ESDS, entry sequenced dataset?
19 ► What are the distinctive features of a KSDA, key sequenced dataset?
20 ► What is a sequence set?
21 ► What is a cluster?
22 ► What is an alternate index?
23 ► What is the upgrade set?
24 ► What is a VSAM split?
25 ► Do primary key values have to be unique? Do alternate key values have to be unique?
26 ► In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?
27 ► What is the purpose of the FILE STATUS clause in the SELECT statement?
28 ► What is the catalog?
29 ► What is the index set?
30 ► What is a CA, control area?
31 ► What is a CI, control interval?
32 ► What is a path?
33 ► What is free space?
34 ► What is the base cluster?
35 ► In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
36 ► What is the COBOL RECORD KEY clause?
37 ► If you wish to use the REWRITE command haw must the VSAM file be opened?
38 ► What is File Status in VSAM?
39 ► What is the significance of the SHAREOPTIONS parameter?
40 ► There are at least seven IDCAMS commands name and explain each of them?
41 ► What is a VSAM slot?
42 ► Name some common VSAM error conditions and codes?
43 ► How do you define an ALTINDX? How do you use ALTINDXs in batch, CICS programs?
44 ► What is the meaning of each of the values in SHAREOPTS (2 3)?
45 ► Would you specify FREESPACE CE for an ESDS?
46 ► Under IDCAMS, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?
47 ► What is the meaning of dynamic processing?
48 ► What is the VSAM-code field?
49 ► What is the utility program closely associated with VSAM?
50 ► What are the three levels of definition for the VSAM DEFINE?
51 ► What is the meaning of the DEFINE MODEL parameter?
52 ► What is a LDS (Linear Data Set) and what is it used for?
53 ► Using Alternate Indexes in Batch program?
54 ► Using Alternate Indexes in CICS program?
55 ► Assuming that the DEFINE JCL is not available, how do you get info about a VSAM files organisation?
56 ► What more info you should give in the DD statement while defining the next generation of a GDG?
57 ► Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL?
58 ► Do all versions of the GDG have to be of the same record length?
59 ► How do you load a VSAM data set with records?
60 ► How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique?
61 ► What is the difference between sequential files and ESDS files?
62 ► How do you define a GDG?
63 ► How are different versions of GDG named?
64 ► Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now?
65 ► During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do?
66 ► How do you fix the problem associated with VSAM out of space condition?
67 ► What is the meaning of VSAM RETURN-CODE 28?
68 ► On which dataset You can have ALT INDEX?
69 ► How many ALternate Indexes you can have on a dataset?
70 ► Is it slower if you access a record through ALT INDEX as compared to Primary INDEX?
71 ► What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?
72 ► Describe SHAREOPTIONS parameter (SHR) in Define Cluster command?
73 ► What does the KEYRANGES parameter in Define Cluster commends do?
74 ► What are the optional parameters to the input dataset While loading the empty cluster with the data records?
75 ► What is IDCAMS? and what is the purpose of it?
76 ► How to delete a member using JCL?
77 ► What is the difference between LDS and ESDS?
78 ► Is a delete operation possible in an ESDS? B, is rewrite operation possible in ESDS?
79 ► What is an alternate index and path?
80 ► How many buffers are allotted to VSAM KSDS and ESDS?
81 ► What is the biggest disadvantage of using a VSAM dataset?
82 ► What is the device independent method to indicate where a Record is Stored?
83 ► How many times secondary space allocated?
84 ► What is the RRN for the first record in RRDS?
85 ► What is a Base Cluste?
86 ► If FSPC(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both CI and CA are specified to be empty?
- Ads By Google