what are the bind parameters?

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

Question Posted / anjireddyvinta

5 Answers
37691 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the bind parameters?..

Answer / amarnadh reddy

hi,

Bind parameters are:
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table

Is This Answer Correct ?

41 Yes

2 No

what are the bind parameters?..

Answer / ranju

One more important BIND parameter.
'OWNER' That is the table creator name,which specifies the
table needs to be accessed is dev,UAT or Prod

Is This Answer Correct ?

22 Yes

1 No

what are the bind parameters?..

Answer / ram

Bind Parameters are below...

Bind Package/Plan
Owner (Authorization ID)
Qualifier (qualifier name)
Member (member name)
Library (DBRM Pds name)
ACTION (ADD/REPLACE)
Explain (Yes/No)
Flag (I/W/E/C)
ISOLATION (RR/RS/CS/UR)
Release (Commit/Deallocate)
Validate(Run/Bind)
Acquire(Use/Allocate)

Is This Answer Correct ?

10 Yes

0 No

what are the bind parameters?..

Answer / harsha

and VERSION --- for different versions to bind

Is This Answer Correct ?

10 Yes

3 No

what are the bind parameters?..

Answer / saloni

QUALIFIER

Is This Answer Correct ?

3 Yes

1 No

Post New Answer