How do you fix the problem associated with VSAM

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you fix the problem associated with VSAM out of space condition ?

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 or se IDCAMS to DELETE the old VSAM datset.
Use IDCAMS to ALTER / rename the new VSAM dataset to the name of the original VSAM dataset.

(Continued on next question...)

Other Job Interview Questions

• If FSPC(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both CI and CA are specified to be empty ?
• Syntax of AMS modal commands ?
• How do you fix the problem associated with VSAM out of space condition ?
• What is a CI, control interval?
• What are the three levels of definition for the VSAM DEFINE?
• Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation ?
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• Is a delete operation possible in an ESDS ? B, is rewrite operation possible in ESDS ?
• Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.
• More...