What is the easiest way to find out which progra

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

(Continued from previous question...)

What is the easiest way to find out which programs are affected by change in a table's structure ??

Q: Assuming that a site's standard is that program name = plan name, what is the easiest way to find out which programs are affected by change in a table's structure ??

AN:
Query the catalogue tables SYSPLANDEP and SYSPACKDEP.

(Continued on next question...)

Other Job Interview Questions

• What is FREEPAGE and PCTFREE in TABLESPACE createion?
• Give the COBOL definition of a VARCHAR field.
• What is the difference between join and union ?
• What does it mean if the null indicator has -1, 0, -2??
• What is filter factor?
• Can you access the DB2 Directory table using SQL?
• I use CS and update a page. Will the lock be released after I am done with that page ?
• What is the self-referencing constraint ?
• What is EXPLAIN?
• What are the contents of a DCLGEN?
• More...