Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are the various locks available?

Answers were Sorted based on User's Feedback



What are the various locks available?..

Answer / sudha

share,exclusive and update

Is This Answer Correct ?    14 Yes 0 No

What are the various locks available?..

Answer / lakshmisudha

locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update

Is This Answer Correct ?    2 Yes 0 No

What are the various locks available?..

Answer / nag(igate)

They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release

Is This Answer Correct ?    1 Yes 1 No

What are the various locks available?..

Answer / muthusamy

share,exclusive and update

Is This Answer Correct ?    0 Yes 0 No

What are the various locks available?..

Answer / satya narayana

Three. 1. mode , 2.size , 3.duration.

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More DB2 Interview Questions

what are the bind parameters?

5 Answers   IBM,


In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


What is meant by dclgen?

0 Answers  


If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


What is a page in db2?

0 Answers  


i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  


How can you get the number of rows impacted by the last executed query?

1 Answers  


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


can you use symbolic parameters in JOB?

5 Answers   IBM,


What is correlated subquery?

1 Answers  


Categories