Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is a VSAM slot?
- Correct Answer
- 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
- 1. Assuming that the DEFINE JCL is not available, how do you get info about a VSAM files organisation? Discuss
- 2. Name some common VSAM error conditions and codes? Discuss
- 3. During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do? Discuss
- 4. How do you convert flat files to VSAM files? Discuss
- 5. What is purpose of VSAM? Discuss
- 6. How do you fix the problem associated with VSAM out of space condition? Discuss
- 7. What are the three levels of definition for the VSAM DEFINE? Discuss
- 8. What are the different types of VSAM files available? Discuss
- 9. How can we distinguish between an online and batch program in IMS environment? Discuss
- 10. What are the two types of fields available in IMS DB? Discuss
Technology problems
Search Results
Correct Answer: Use the LISTCAT command
Correct Answer: End of file (10) Duplicate key (22) Record not found (23) VSAM logic error (90) Open problem (92) Space problem (93)
Correct Answer: Run VERIFY
Correct Answer: Use IDCAMS REPRO to load the flat file into the VSAM file
Correct Answer: VSAM acts as an interface between Application program & Operating System
Correct Answer: Define new VSAM dataset allocated with more space Use IDCAMS to REPRO the old VSAM file to new VSAM dataset Use IDCAMS to ALTER / RENAME the old VSAM dataset to DELETE the old VSAM datset Use IDCAMS to ALTER / RENAME the new VSAM dataset to the name of the original VSAM dataset
Correct Answer: They are DEFINE CLUSTER, DATA and INDEX
Correct Answer: ESDS: Entry Sequence Data Set KSDS: Key Sequence Data Set RRDS: Relative Data Set
Correct Answer: If in application program IO-PCB is there then it is a online program In ENTRY statement IO-PCB must be listed first and then DB-PCB
Correct Answer: Key Fields - (PROCOPT=K) - Used to sequence the database and can't be changed - It is the field within a segment, used to identify the occurrence of the segment - Used to maintain the IMS segments in ascending sequence Search Fields - (PROCOPT=G) - Used to search for a segment, without the segment being sequenced on that field - A segment need not have a key or search field Both types of fields can be used to search the database
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.