What information is used as input to the bind pr

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

(Continued from previous question...)

What information is used as input to the bind process?

The database request module produced during the pre-compile. The SYSIBM.SYSSTMT table of the DB2 catalog.

(Continued on next question...)

Other Job Interview Questions

• How could one combine a set of incremental image copies into a single copy?
• What is cursor stability?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What are the three DB2 date and time data types and their associated functions?
• What is DCLGEN?
• What does the REORG Utility?
• Where besides the DB2 catalog is database object information stored by DB2?
• What is the Manimum number of volumes that can be added to a STOGROUP?
• What is the STOSPACE Utility used for ?
• What is a clustering index?
• More...