VSAM interview Questions

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Hi,

Can someone please help me with these questions?

VSAM Interview Questions.

1.The record keys in a CI are 100,200 and 300. The CI is full and there is no free space allocated.What will happen when key 250 is added to the dataset?

a.Record 300 will be moved to a new CI, and record 250 will be placed in the place where 300 was.
b.Record 200 will be moved to a new CI. Record 300 will be moved to the new CI, leaving space for record 250. It will be placed between records 200 and 300.

2.VSAM internal security may be applied to which of the following levels?

a.Path, cluster, I
b.Read,update,CI,Master
c.Delete,update,write,Master

3.What is meant by FREESPACE(10,15)
A.That 10% of the CI’s per CA and 15% of each CI will be reserved.
B.That 10% of each CI and 15% of the CI’s in each CA will be reserved.

4.Control Area #1 has all of its free space expended. CA#2 is unused. The allocation is FREESIZE(25 25).,And the processing method is direct access.
What happens when the next CI split occurs?
A.The last half of the CI’s from CA1 are moved to first half of CA2
B.The new CI is inserted into CA2
C.The last CI from CA1 is moved to CA2, and the new CI is inserted into the slot created.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Apologise.. Missed my Options.. Just want to confirm with you guys..

1. a
2. c
3. b
4. b

Robert Sample · Posted: Tue Mar 31, 2009 5:04 pm

From the VSAM Demystified Redbook (SG24-6105):

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Thanks a lot Rob.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Hi Rob,

Just a query on Question 1. As there are 3 records (100,200,300).

Robert Sample · Posted: Wed Apr 01, 2009 4:41 pm

If there are 3 records in the Ci, approximately half could be 2 records or 1 record. However, the quote also states that the inserted record goes into the original CI, so only the 1 (300) record would be moved.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Thanks a lot Rob.
You have hit the nail on the head.

THINKSRINIII · New User Joined: 09 Jan 2009 Posts: 88 Location: India

Hi Guys,

Could some one help me in getting the answers for these.

1. What happens when an VSAM dataset is opened for an update. IS the entire CI is locked containg the record to be updated is locked or only that particular record.

2. What is the Maximum number of A.I's a ESDS can have? A KSDS

3. What is the difference between SHAREOPTIONS(3 3),SHAREOPTINS(3 4),SHAREOPTIONS(4 3),SHAREOPTIONS(4 4)
( I have had a look at the manual and can see the Difference between other share options but this is not crisp).

Thanks in Advance

enrico-sorichetti · Posted: Thu Apr 02, 2009 3:45 pm

1) none as far as VSAM itself is concerned

2) read the manual
( certainly the limit will be higher than your need, if not so You have a case of bad application design)

3) SHAREOPT(x y) the x and y are independent
so it is enough to read the two paragraphs independently from each other

dbzTHEdinosauer · Posted: Thu Apr 02, 2009 3:47 pm

why don't you take a look at the links provided by ES in your previous post.

not many of us have an interest in helping you avoid reading the manuals.

especially VSAM demystified - which is a redbook, easy to read, is indexed.............