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

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

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)

Answer / harsha

and VERSION --- for different versions to bind

Answer / saloni

QUALIFIER

What is the purpose of the DSNC transaction ?

1 Answers  

What is cursor stability?

1 Answers  

Explain the contention situations caused by locks?

0 Answers  

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

How do you check for a null value in a db2 column?

2 Answers  

What is db2 isolation?

2 Answers  

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

What is db2 look?

0 Answers  

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,