Wednesday, January 7, 2009

BIND PARAMETERS

Explanation for Bind parameters:


DSN SYSTEM (DSN)

BIND PLAN(CBI018P) -

MEMBER(CBI018P, CBISOFM) -

ACQUIRE(USE) - --> Acquires table space locks only when the application program bound to the plan first uses them.

RELEASE(COMMIT)- --> Releases the table locks once commit is issued.

OWNER(OWNER) -

QUALIFIER(NAME) --> Used to qualify Un-qualified objects(without any schema name) in the query.

ACTION(REPLACE)- --> It replaces existing PLAN with a new PLAN with same name. If you change the SQL statements or recompile a program, you should use BIND PLAN with the option ACTION(REPLACE).

RETAIN - --> Preserves EXECUTE privileges when you replace the plan using ACTION(REPLACE).

VALIDATE(BIND)- --> DB2 verifies the authorization on the objects involved at bind time

ISOLATION(CS) - --> DB2 uses Cursor Stability phenomenon for locking purposes.

DYNAMICRULES(BIND)- -->DB2 checks necessary authorization at bind time to execute dynamic SQL statements .

DBPROTOCOL(PRIVATE) -->DB2 to use DB2 private protocol access for accessing remote data that is specified with three-part names.

END

1 comment: