There are at least seven IDCAMS commands; name a

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

(Continued from previous question...)

There are at least seven IDCAMS commands; name and explain each of them?

ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. DEFINE is used for ALTERNATEINDEX, CLUSTER or PATH. DELETE removes the catalog entry for a catalog, cluster, alternate index or path. LISTCAT lists information about the dataset. PRINT prints the dataset contents. REPRO copies records from one file to another.

(Continued on next question...)

Other Job Interview Questions

• In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?
• What is a path?
• Is it slower if you access a record through ALT INDEX as compared to Primary INDEX ?
• How do you decide on optimum values for CI, FREESPACE etc ... ?
• What is the meaning of the DEFINE MODEL parameter?
• Name some common VSAM error conditions and codes.
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• What is IDCAMS ?
• What is the VSAM-code field ?
• How do you define a GDG ?
• More...