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

Is db2 a database?

0 Answers  

What is coalesce in db2?

0 Answers  

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

what is Static and dynamic linking

1 Answers   Virtusa,

What is bind plan?

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,

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

How can you compare table column after update and before update?

5 Answers   Satyam,

Is there any advantage to denormalizing DB2 tables?

1 Answers  

What is cursor?

2 Answers  

What is reorg in database?

1 Answers