why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
- 9 Answers
- 32767 Views
- Infosys, TCS, Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rock
if we didnt bind the program ,there is possibility of
getting 805 error also
| Is This Answer Correct ? | 19 Yes | 2 No |
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 |
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 |
Answer / harsha
if we dont bind a program there is a possibiliy of getting -
818 error.
| Is This Answer Correct ? | 12 Yes | 7 No |
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 |
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 |
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 |
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 |
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 |
How to see the structure of db2 table??
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is the use of value function?
How can you display the current date & current time ?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What does an outer join do?
What is the difference between cursor stability and repeatable read isolation levels?
Can we update view in db2?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
How to create db2 table in mainframe?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
i have a db2 variable how do u declare tht into working storage section ?
COBOL 
