VSAM Questions And Answers

21⟩ What is a VSAM split?

If there isn't enough space in the control interval VSAM performs a control interval split by moving some records to the free control intervals. If there isn't a free control interval VSAM performs a control area split by allocating a new control area and moving half of the control intervals to it.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

111 views

22⟩ What is a cluster?

A cluster is the combination of the index, sequence set and data portions of the dataset. The operating system gives program access to the cluster, ie. to all parts of the dataset simultaneously.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

137 views

23⟩ What is a sequence set?

This is the part of the index that points to the CA and CI of the record being accessed.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

127 views

24⟩ What are the distinctive features of a KSDA, key sequenced dataset?

The index and the distributed free space.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

130 views

25⟩ What is the base cluster?

The base cluster consists of the data component and the index component for the primary index of a KSDS.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

162 views

26⟩ What is free space?

Free space is reserved within the data component of a KSDS to accommodate inserting new records.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

157 views

27⟩ In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?

the ORGANIZATION is INDEXED.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

133 views

28⟩ What is a CI, control interval?

A control interval is the unit of information that VSAM transfers between virtual and auxilliary storage.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

146 views

29⟩ What is a path?

A path is a file that allows you to access a file by alternate index - the path provides an association between the AIX and the base cluster.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

136 views

30⟩ What is the index set?

This is the other part of the index. It has multiple levels with pointers that ultimately reach to the sequence set.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

128 views

31⟩ What is a CA, control area?

A group of control intervals makes up a control area.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

152 views

32⟩ What is the catalog?

The catalog contains the name of all datasets. VSAM and non-VSAM. It is used to access these datasets.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

140 views

33⟩ In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?

ACCESS can be SEQUENTIAL, RANDOM or DYNAMIC.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

120 views

34⟩ What is the purpose of the FILE STATUS clause in the SELECT statement?

The FILE STATUS field identifies the field that VSAM uses to provide information about each I/O operation for the file.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

130 views

35⟩ What is a VSAM slot?

A relative record dataset (RRDS) consists of a specified number of areas called slots. Each slot is identified by a relative record number (RRN) which indicates its relative position in the file.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

157 views

36⟩ What is File Status in VSAM?

The File STATUS clause of the FILE-CONTROL paragraph allows for each file to be associated with a file status key (i.e., the 2-character data item specified in the FILE STATUS clause). If the FILE STATUS clause is specified for a given file, a value indicating the status of each I/O operation against that file is placed in the accociated file status key. This value is stored in the file status key as soon as the I/O operation is completed (and before execution of any EXCEPTION/ERROR declarative or INVALIDKEY/AT END phrase associated with the I/O request).

Note: This element may behave differently when the CMPR2 compiler option is used. The file status key is divided into two status keys: the first character is known as file status key1; the second character is file status key 2.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

123 views

37⟩ Name some common VSAM error conditions and codes?

They are end of file (10), duplicate key (22), record not found (23), VSAM logic error (90), open problem (92) and space problem (93).

Is this answer helpful? 0 Yes | 0 No

Answer This Question

139 views

38⟩ If you wish to use the REWRITE command haw must the VSAM file be opened?

It must be opened as I/O.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

144 views

39⟩ What is the COBOL RECORD KEY clause?

The RECOED KEY in the SELECT clause identifies the files primary key as it will be known to the program.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

141 views

40⟩ How do you define an ALTINDX? How do you use ALTINDXs in batch, CICS programs?

DEFINE ALTERNATEINDEX. Impartant parameters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE, SHAREOPTION, UNIQUEKEY (or NONUNIQUEKEY), DATA (DS NAME for the data component), INDEX(DS name for the index component). Then DEFINE PATH. Important paramters are NAME (DS name for the path). PATHENTRY (DS name of the alternate index name). UPDATE (or NOUPDATE) which specifies whether an ALT index is updated when a update to the vase cluster takes place. Then BLDINDEX. Paramters are INDATASET (DS name of base cluster), OUTDATASET (DS name of AIX).

Is this answer helpful? 0 Yes | 0 No

Answer This Question

150 views

VSAM

Home Mainframes VSAM

86 VSAM Questions And Answers

21⟩ What is a VSAM split?

22⟩ What is a cluster?

23⟩ What is a sequence set?

24⟩ What are the distinctive features of a KSDA, key sequenced dataset?

25⟩ What is the base cluster?

26⟩ What is free space?

27⟩ In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?

28⟩ What is a CI, control interval?

29⟩ What is a path?

30⟩ What is the index set?

31⟩ What is a CA, control area?

32⟩ What is the catalog?

33⟩ In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?

34⟩ What is the purpose of the FILE STATUS clause in the SELECT statement?

35⟩ What is a VSAM slot?

36⟩ What is File Status in VSAM?

37⟩ Name some common VSAM error conditions and codes?

38⟩ If you wish to use the REWRITE command haw must the VSAM file be opened?

39⟩ What is the COBOL RECORD KEY clause?

40⟩ How do you define an ALTINDX? How do you use ALTINDXs in batch, CICS programs?

Quick Links:

VSAM

Home Mainframes VSAM

86 VSAM Questions And Answers

21⟩ What is a VSAM split?

22⟩ What is a cluster?

23⟩ What is a sequence set?

24⟩ What are the distinctive features of a KSDA, key sequenced dataset?

25⟩ What is the base cluster?

26⟩ What is free space?

27⟩ In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?

28⟩ What is a CI, control interval?

29⟩ What is a path?

30⟩ What is the index set?

31⟩ What is a CA, control area?

32⟩ What is the catalog?

33⟩ In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?

34⟩ What is the purpose of the FILE STATUS clause in the SELECT statement?

35⟩ What is a VSAM slot?

36⟩ What is File Status in VSAM?

37⟩ Name some common VSAM error conditions and codes?

38⟩ If you wish to use the REWRITE command haw must the VSAM file be opened?

39⟩ What is the COBOL RECORD KEY clause?

40⟩ How do you define an ALTINDX? How do you use ALTINDXs in batch, CICS programs?

BE THE FIRST TO KNOW

Quick Links: