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.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is pid? 20.11.08
Unix identifies every process by a Process Identification Number (pid) which is assigned when the process is initiated. When we want to perform an operation on...What does CURRENTDATA option in bind indicate ? 26.03.08
CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been changed to NO. Therefore it is necessary to change all t...What are the functions of Bind ? 24.03.08
BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart fro...What are the advantages of using a PACKAGE ? 16.03.08
The advantages of using PACKAGE are: 1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid cost of a large bind 3. Avoid the entire tra...What is a DBRM, PLAN ? 16.03.08
DBRM: Data Base Request Module, has the SQL statements extracted from the host language program by the pre-compiler. PLAN: A result of the BIND process. It...When do you specify the isolation level ? 14.03.08
During the BIND process(ISOLATION LEVEL is a parameter for the bind process). ISOLATION ( CS/RR )......What is a Database Request Module(DBRM)? 09.03.08
A DBRM is a DB2 component created by the DB2 pre-compiler containing the SQL source statements extracted from the application program. DBRMs are input to the bi...What is a DB2 bind? 07.03.08
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 an...Explain what a plan is? 07.03.08
Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name....What are session method and call transaction method and explain about them? 29.03.07
Session method – Use the BDC_OPEN_GROUP to create a session. Once we have created a session, then we can insert the batch input data into it with BDC_INSERT....