What is a DB2 bind?

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

(Continued from previous question...)

What is a DB2 bind?

Bind is a process that builds "access paths " to DB2 tables. A bind uses the Database Request Modules (s) (DBRM (s)) from the DB2 pre-compile step as input and produces an application plan. It also checks the user's authority and validates the SQL statements in DBRM(s).

(Continued on next question...)

Other Job Interview Questions

• What do you mean by NOT NULL WITH DEFUALT? When will you use it ?
• What is a correlated sub query?
• What keyword does an SQL SELECT statement use for a string search?
• What is REORG? When is it used
• What should be specified along with a cursor in order to continue updating process after commit ?
• How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
• What Utility is used to migrate DB2 from one release to the next?
• How is the status of a utility reset after it has been stopped by DB2?
• What is a cursor ?
• an I alter a table when other user is selecting some columns ...
• More...