Bind Parameters

What are the important bind parameters to be used in bind card? What is the significance of each parameter?

Questions by bhima123

Showing Answers 1 - 4 of 4 Answers

vitalreddy

  • Jan 8th, 2011
 

A DB2 bind is a process that builds an access path to DB2 tables.  
A plan is an executable module containing the access path logic produced by the Db2 optimizer.

  Was this answer useful?  Yes

The bind parameters are generally generic the most important is isolation level which is always CS and sometimes UR if you want to rock right thru.

  Was this answer useful?  Yes

I will say the Answer Depends barring a few parameters which are mostly used.
1) ISOLATION -> Isolation Level to decide level of locking used along with LOCK parameters on
the DB2 objects.
2) ACQUIRE -> When to acquire high level locks , ALLOCATE (when plan is allocated at run time)
or USE (when the first SQL is encountered at run time during Execution)
3) RELEASE - > When to release locks, DEALLOCATE (when program terminates) or COMMIT (when
explicit COMMIT is taken or if not taken, then at program termination, except for a CURSOR
WITHHOLD).
4) VALIDATE -> when to validate authorization and table constraints, BIND - at BIND time,
RUN=> at run time
5) QUALIFIER => Table QUalifer when using UnQualfied embedded SQL - which is recommended
6) OWNER = > The DB2 User/ID/Group which has appropriate table authorizations and BIND
authorizations to create the Access path (plan/package)
7) EXPLAIN -> (YES/NO -> if you want the DB2 to store information about the access path
generated by the DB2 optimizer in OWNER.PLAN_TABLE then YES, or NO)
8) PACKAGELIST -> Used when Plan is created and is used to relate to one or more Packages,so
that when a Package is re-bound due to some changes, Plan doesnt need to be re-bound again
9) MEMBER -> the program/module name which is to be bound, or whose DBRM is to be bound to
create the Plan/Package
10) -> LIBRARY , the PDS directory name where the DBRM used during BIND is located
11) -> FLAG (E/C/W/I/) -> Level of messages to be displayed as a result of BIND,
e.g. Warning, Information, Critical, Error, etc.. FLAG(I) Information displays all messages,
and if FLAG(E) is used, only Error messages if encountered during BIND are displayed
In some installations,where online regions (CICS/ DB2 Stored Procedures) are used, they also
use the below parameter
ENABLE/DISABLE -> e.g. ENABLE(BATCH) -> Enable only batch and disable program execution in
CICS or ONline Mode
ENABLE(CICS) or ENABLE(CICS1,CICS2). etc. will enable module execution only in listed CICS
regions or all regions if CICS is mentioned

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions