How is a typical DB2 batch pgm executed ?

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

(Continued from previous question...)

How is a typical DB2 batch pgm executed ?

1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown:
DSN SYSTEM(DSP3)
RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED 01T.OBJ.LOADLIB')
END
2. Use IKJEFT01 utility program to run the above DSN command in a JCL.
Assuming that a site’s standard is that pgm name = plan name, what is the easiest way to find out which pgms are affected by change in a table’s structure ?
Query the catalogue tables SYSPLANDEP and SYSPACKDEP.

(Continued on next question...)

Other Job Interview Questions

• Give some example of statistics collected during RUNSTATS?
• What is sqlcode -922 ?
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• What is 'LIKE' used for in WHERE clause? What are the wildcard characters? –
• What does it mean if the null indicator has -1, 0, -2? –
• Can you have more than one cursor open at any one time in a program ? –
• When do you use a LIKE statement?–
• What is CHECK PENDING ?
• How do you insert a record with a nullable column?
• When you COMMIT, is the cursor closed? - drona questions–
• More...