Name some common VSAM error conditions and codes

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

(Continued from previous question...)

Name some common VSAM error conditions and codes.

They are end of file (10), duplicate key (22), record not found (23), VSAM logic error (90), open problem (92) and space problem (93).

(Continued on next question...)

Other Job Interview Questions

• Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.
• What is IDCAMS ? and what is the purpose of it ?
• How do you define a GDG ?
• What are the distinctive features of a KSDA, key sequenced dataset?
• How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS program's ?
• If you wish to use the REWRITE command haw must the VSAM file be opened?
• What is free space?
• What is a path?
• How many times secondary space allocated ?
• If you wish to use the REWRITE command haw must the VSAM file be opened?
• More...