Discussion
Home ‣ Interview ‣ Technology Comments
- Question
How do you fix the problem associated with VSAM out of space condition?
- 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
- 1. What is a VSAM slot? Discuss
- 2. Assuming that the DEFINE JCL is not available, how do you get info about a VSAM files organisation? Discuss
- 3. Name some common VSAM error conditions and codes? Discuss
- 4. During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do? Discuss
- 5. How do you convert flat files to VSAM files? Discuss
- 6. What are the three levels of definition for the VSAM DEFINE? Discuss
- 7. What are the different types of VSAM files available? Discuss
- 8. How can we distinguish between an online and batch program in IMS environment? Discuss
- 9. What are the two types of fields available in IMS DB? Discuss
- 10. What are the processing modes available in IMS DB? Discuss
Technology problems
Search Results
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
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: 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
Correct Answer: Batch DL/I MPP Mode - (Message Processing Program) BMP Mode - (Batch Message Processing)
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.