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.
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