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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest

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

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

cobol-db2 runjcl please?

2 Answers   DELL,

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

What does db2 mean?

0 Answers  

What is the syntax for creating a table in the db2 database?

0 Answers  

What does reorg do in db2?

0 Answers  

What is a cursor?

2 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

Can we delete records from view?

0 Answers  

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

What will the DB2 optimizer do?

2 Answers  

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

For more DB2 Interview Questions Click Here
Categories