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?

A DB2 bind is a process that builds an access path to DB2 tables
A BIND process establishes a relationship between an APPLICATION PROGRAM and its RELATIONAL DATA.

(Continued on next question...)

Other Job Interview Questions

• Is there any advantage to denormalizing DB2 tables?
• What is the difference between SYNONYM and ALIAS?
• What is FREEPAGE and PCTFREE in TABLESPACE creation?
• When is the access path determined for dynamic SQL? –
• At what stage DB2 must be up?
• What is index cardinality? –
• What are the 2 sqlcodes that are returned? –
• Will precompile of an DB2-COBOL program bomb, if DB2 is down?
• If I have a view which is a join of two or more tables, can this view be updateable?
• How to read last record in vsam file.,I don't know how many records are there?
• More...