More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What are three major types of JCL statements ? What are their functions
JOB - indicates start of jobstream to the operating system and through parms coded on it, certain details about the job ( time, region, message, level, job accounting data ).
EXEC - indicates the start of execution of a particular job step, be that step a program or a proc.
DD - is a data definition, which is used to describe the attributes of a data set ( name, unit, type, space, disposition ).
1. Distinguish between position and keyword parameters
2. How can you omit positional parameters ?
3. How do you define the identifier field for a delimiter statement ?
4. List some valid operation codes.
5. What is the purpose of the MSGLEVEL parameter ?
6. What is the function of the following parameters :
I) MSGLEVEL = (0,0)
II) MSGLEVEL = (2,1)
II) MSGLEVEL = (1,1)
7. What is the purpose of the MSGCLASS parameter
8. What are the parameters used with COND ?
9. List down the different types of comparison operator and their meaning.
10. What is the function of the TYPRUN parameter
11. What are the subparameters that can be used with TYPRUN?
12. What is the function of the TIME parameter ?
13. What is the purpose of the EXEC statement ?
14. What are the additional keyword parameters used on the EXEC statement ?
15. What is the difference between the following statements:
I) step#1 exec PGM = accpay
II) step#1 exec tbalance
16. What is the error in the following JCL statements :
I) //step#three exec pgm = hkbc762
II) //step#3 exec pgm = hkbc762
III) // step#3 exec pgr = hkbc672
17. Name the system library from while modules are retrieved at executiong time.
18. What is the purpose of the JOBLIB statement ?
19. IF JOBLIB and STEPLIB statements are both included in a job, then which statement would overide.
20. What is the purpose of the PARM parameter ?
21. What is the purpose of the DD statement ?
22. How would you specify the device for a dataset in a DD statement ?
23. What is the function of the following DD statement // ddname DD *
24. What is the purpose of the SYSOUT Parameter in the DD statement ?
25. What are the two ways of specifying Temporary Data Sets ?
26. What are the advantages of coding the DISP parameter with MOD rather than NEW ?
27. Explain the function of the following Statement : //ddname DD DISP = (NEW, CATLG, DELETE)
28. What is the default value of the third DISP subparameter ?
29. What is Backward Referencing ?
30. What is the purpose of Concatenating Data Sets ?
31. What is the result of a READ operation on a Dummy Data set ?
32. What are the functions of the following ddnames:
SYSUDUMP, SYSABEND, SYSMDUMP
33. What are GDGs ?
