CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
VSAM Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM MAINFRAME INTERVIEW QUESTIONS VSAM INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

VSAM Interview Questions & Answers - Learning Mode

VSAM stands for Virtual Storage Access Method. VSAM is a file storage access method used in MVS, ZOS and OS/390 operating systems. It was introduced by IBM in 1970's. It is a high performance access method used to organize data in form of files in Mainframes. Virtual storage access method (VSAM) is an IBM DASD file storage access method, first used in the OS/VS1, OS/VS2 Release 1 (SVS) and Release 2 (MVS) operating systems, later used throughout the Multiple Virtual Storage (MVS) architecture and now in z/OS.

Try VSAM Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

VSAM Interview Questions & Answers - Learning Mode
Try VSAM Interview Questions & Answers - Exam Mode
Question: How do you compile a program in Endevor?



Answer: To compile a program through Endeavor.

We need tp prepare aan ADDSCL to compile a program through Endeavor.The following points to be noted while preparing ADDSCL.

1.In which environment are we going to add a program.?As you all know there are different environments in Endeavor such as Production, Test, Accpetance, QuickFix Etc., and it is installation dependent.

2.Select the environment, say if you are adding a program in Test environment

3.Goto Test environment => Source: CoolInterview.com
Question: What is the difference between sequential files and ESDS files?

Answer: Sequential(QSAM) files can be created on tape while ESDS files cannot.

Also, you can have ALTINDEX for an ESDS while no such facility exists for QSAM files. Source: CoolInterview.com
Question: What do you mean by RDW in VSAM?



Answer: VSAM Stands for Virtual Storage Acess Method...An Acess method is the component of operating system....it is the interface between Application Program and the physical opertaion of storage device.What is a VSAM? VSAM Stands for Virtual Storage Acess Method...An Acess method is the component of operating system....it is the interface between Application Program and the physical opertaion of storage device.[B][/B] Source: CoolInterview.com
Question: How can we read a KSDS file in a COBOL program in reverse order,that is from last record to the first record in KSDS file? Provided the keys are in unsorted order. And this has to be done without sorting the KSDS file. Could any one please help me for this?

Answer: Firstly, The Keys are in sorted order in KSDS .
Secondly , to acheive reverse reading
- Use StartBrowse to point it to last record with by moving Keys to HIGH values .
-Then use READPREV to read records ...
Source: CoolInterview.com
Question: What do you mean by dirty read



Answer: The "dirty read" technique can be used to provide a high degree of concurrent access to VSAM files while avoiding the complications associated with CI and CA splits. The dirty read protocol can be summarized as follows:
The VSAM file must be defined with cross-region SHAREOPTIONS 4.
The file must be allocated with DISP=SHR.
All operations on the file, including reads, must be preceded with an ENQ for the data set. The data set name is specified for the ENQ "rname", but any string can Source: CoolInterview.com
Question: How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgms ?

Answer: DEFINE ALTERNATEINDEX. Important paramters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE,SHAREOPTIONS,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 base cluster takes place.

Then BLDINDEX. Param Source: CoolInterview.com
Question: How do you define a GDG ?

Answer: Use the DEFINE GENERATIONDATAGROUP command. In the same IDCAMS step, another dataset must be defined whose DCB parameters are used when new generations of the GDG are created. This dataset is known as the model dataset. The ds name of this model dataset must be the same as that of the GDG, so use a disp of keep rather than catlg and also specify space=(trk,0) Source: CoolInterview.com
Question: What is the maximum record length for the VSAM dataset?



Answer: Max size of a record in VSAM is cylinder = 2880 bytes approx.
Source: CoolInterview.com
Question: How do you load a VSAM data set with records ?

Answer: Using the REPRO command. Source: CoolInterview.com
Question: Would you specify FREESPACE for an ESDS?

Answer: No. Because you cannot insert records in an ESDS, also when you rewrite a record, it must be of the same length. Thus putting any value for freespace does not make any sense. Source: CoolInterview.com
Question: What does a file status of 02 on a VSAM indicate?

Answer: Duplicate alternate key . Happens on both input and output operation Source: CoolInterview.com
Question: What is the maximum no. of records that can be allowed in VSAM



Answer: Its depand upon the CA. Every vsam file allocate record differently. so, its tuff to tell the answer. Source: CoolInterview.com
Question: In vsam why we use export-import utility?




Answer: It is used for the back-up purpose.Whenever there is a loss of data by accidental then we can restore it from the Exported/Imported data. Source: CoolInterview.com
Question: How do you decide on optimum values for CI, FREESPACE etc..?

Answer: CI size should be based on record length, type of processing. Usually CI is 4K. If record length is larger(>1K), chose 6K or 8K.

FREESPACE should be large if more number of insertions are envisaged. Usual values are (20 20) when heavy updates are expected. CI size can be calculated. Source: CoolInterview.com
Question: 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?

Answer: Relative generation numbers are updated only at the end of the job, not at the end of a step. To allocate a new generation, we would be using (+1) with a DISP of (NEW,CATLG,DELETE). To refer to this in a subsequent step in the same job, we would again use (+1) but with a DISP of SHR or OLD. Source: CoolInterview.com
Question: Assuming that the DEFINE jcl is not available, how do you get info about a VSAM file?s organisation ?

Answer: Use the LISTCAT command. Source: CoolInterview.com
Question: What is averange record legth in KSDS?




Answer: The average record length must be less than or equal to the maximum record length. The Maximum Record Length is 2046. Source: CoolInterview.com
Question: How do you initialize a VSAM file before any operation? a VSAM with alternate index?

Answer: Can write a dummy program that just opens the file for output & then closes it. Source: CoolInterview.com
Question: While designing vsam files,what's the best way to choose control interval size for the data and the index?



Answer: Well, it depends on whether the data will be accessed directly or sequentially.

for direct access use small ci

for sequential access use larger ci.
Source: CoolInterview.com
Question: What is FREESPACE ?

Answer: Coded in the DEFINE as FREESPACE(ci ca) where ci is the percentage of each control interval to be left free for insertions, ca is the percentage of control intervals in each control area to be left empty. Source: CoolInterview.com

1 2 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.34375 Seconds