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 / s

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between isnull and coalesce?

1059

What are the benefits of using the db2 database?

1234

Define db2.

1120

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

What is db2 catalog database?

1049

What does db2 plan contain?

1028

What is a db2 collection?

1052

What is the purpose of using commit?

1100

How to view db2 table structure?

1022

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1242

What language is db2 written in?

1049

Explain various types of locks in db2?

1159

How to check table size in db2 sap?

1042

What is the use of runstats in db2?

1112

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.

3218