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's the best lock size that you could use when you
create a tablespace?

Answers were Sorted based on User's Feedback



what's the best lock size that you could use when you create a tablespace?..

Answer / kums

If we specify LOCKSIZE(ANY), DB@ will decide the optimum
locking Mechanism for the best use.

Is This Answer Correct ?    6 Yes 0 No

what's the best lock size that you could use when you create a tablespace?..

Answer / s

PAGE lock size performs well in most situations. Use Row
level locking if there is lock contentions.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More DB2 Interview Questions

select 100 records from million records ?

2 Answers   Verizon,


What is the function of buffer manager?

1 Answers  


How do I delete a table in db2?

0 Answers  


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,


What is a bind card?

0 Answers  


How does one remove entries from the SCT02 table?

1 Answers  


What is the format (internal layout) of ?TIMESTAMP??

1 Answers  


What is a host variable?

3 Answers  


What is a DB2 catalog?

2 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


What is db2?

0 Answers  


Categories