why should we bind the DB2 program . What if we did not
BIND a BD2 program ??

Answers were Sorted based on User's Feedback



why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / rock

if we didnt bind the program ,there is possibility of
getting 805 error also

Is This Answer Correct ?    19 Yes 2 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / sangeetha

A bind plan contains the optimised access path to the DB2
resources for the application program.
Hence,the SQLs within the program will fail,if the
application program is not bound with a plan.

Is This Answer Correct ?    15 Yes 0 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / harish

ACTUALLY BIND PLAN CONSISTS OF DBRM SO IN DB2 WE NEED TO
CREATE UNIQUE PLAN NAME TO GET EXECTABLE LOAD MODULE AND
DURING RUN PROG WE NEED TO GIVE PLANNAME AND MODIFIED
SOURCE LIB .

IF WE DIDNOT BIND WE WILL GET -805 ERROR I,E PROG NAME OR
DBRM NOT FOUND IN PLAN

SUPPOSE IF YOU MADE ANY CHANGES IN ANY PROGRAM THEN COMPILE
AND BIND PACKAGE ,BIND PLAN .SUPPOSE IF U DONE EVERYTING
AND FORGOT TO BIND IN THAT CASE YOU WILL GET -818 ERROR I,E
TIMESTAMP ERROR...

pls let me know if u have any queries

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

Is This Answer Correct ?    13 Yes 1 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / harsha

if we dont bind a program there is a possibiliy of getting -
818 error.

Is This Answer Correct ?    12 Yes 7 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / guest

We dont bind the DB2 program, we bind the subproduct DBRM
that is output during the precompile step. Without the
final step of BIND the DB2 program will not execute because
the program looks for a DBRM with matching contoken from
the load module. If it cannot find one, the DB2 issues an -
818.

Is This Answer Correct ?    6 Yes 1 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / sk

during compilation of a DB2 program. The host language (eg
COBOL) code and SQL code will be separated.
The SQL codes will be processed and optimised access path
will be generated; the path forms the plan.
The host code will be compiled with its own host compiler
and the executable code will be generated.
The BIND step binds both the executable codes of SQL and
host language; the outcome is the final executable code.
Without bind a DB2 program will not execute.

Is This Answer Correct ?    9 Yes 4 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / hareesh

Bind is a compulsory step in DB2 programming, because only
after the Bind step you will get the executable load module.

Is This Answer Correct ?    17 Yes 13 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / srinivas g

Bind is type of compiler for the SQL statement.
It reads the SQL Statements from the DBRM and produces a mechanism to access data as directed by the SQL statements being bound.
Also checks Syntax, check for correctness of table & column definitions against the catalog information & performs authorization validation.

Is This Answer Correct ?    4 Yes 0 No

why should we bind the DB2 program . What if we did not BIND a BD2 program ??..

Answer / ram.g

can u plz share more about plan package collection with
examples will be gr8 help...

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


What are some SQL aggregates and other built-in functions?

2 Answers  


How are write I/Os from the buffer pool executed?

1 Answers  


What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  


cobol-db2 runjcl please?

2 Answers   DELL,


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,


What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


What is clone table?

0 Answers  


What is db2 look?

0 Answers  


What is meant by concurrency?

1 Answers  


Categories