answersLogoWhite

0


Best Answer

If one application holds a lock on a database object, another application might not be able to access that object. For this reason, row-level locks, which minimize the amount of data that is locked and therefore inaccessible, are better for maximum concurrency than block-level, data partition-level or table-level locks. However, locks require storage and processing time, so a single table lock minimizes lock overhead. The LOCKSIZE clause of the ALTER TABLE statement specifies the scope (granularity)of locks at the row, data partition, block, or table level. By default, row locks are used. Only S (Shared) and X (Exclusive) locks are requested by these defined table locks. The ALTER TABLE statement LOCKSIZE ROW clause does not prevent normal lock escalation from occurring. A permanent table lock defined by the ALTER TABLE statement might be preferable to a single-transaction table lock using LOCK TABLE statement in the following cases: * The table is read-only, and will always need only S locks. Other users can also obtain S locks on the table. * The table is usually accessed by read-only applications, but is sometimes accessed by a single user for brief maintenance, and that user requires an X lock. While the maintenance program runs, the read-only applications are locked out, but in other circumstances, read-only applications can access the table concurrently with a minimum of locking overhead. For an MDC table, you can specify BLOCKINSERT for the LOCKSIZE clause in order to use block-level locking during INSERT operations only. When this is specified, row-level locking is performed for all other operations, but only minimally for INSERT operations. That is, block-level locking is used during the insertion of rows, but row-level locking is used for next-key locking if RR scans are encountered in the indexes as they are being updated. BLOCKINSERT locking might be beneficial in the following cases: * There are multiple transactions doing mass insertions into separate cells. * Concurrent insertions to the same cell by multiple transactions is not occurring, or it is occurring with enough data inserted per cell by each of the transactions that the user is not concerned that each transaction will insert into separate blocks. The ALTER TABLE statement specifies locks globally, affecting all applications and users that access that table. Individual applications might use the LOCK TABLE statement to specify table locks at an application level instead.

parant post http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.perf.doc/doc/c0005271.html

my blog http://jacksparrowcode.blogspot.com/

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Define Granularity in database management system?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why do Database Management is related to MS Access?

Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.


About oracle database management system?

database management is a system


What is a database management system?

Database management system is a software system that creates,expands and maintains the database.


Are database and database management system identical?

No. Database is a data itself, organized according to rules of database management system. And Database Management System is a software used to organize a database, and to acces it too.


Functions of a typical database management system?

Functions of a typical database management system?


What are the differences between database management system Vs relational dbms?

the database management system analysis the data or record but relational database management system links the database to each other.


What is full form of rdbms?

Relational Database Management System Relational Database Management System


Is a database and a database management system the same why why not?

A database is a collection of data. A database management system controls how those data are collected, stored and retrieved.


Four differences between fileprocessing system and database management system?

four differences between fileprocessing system and database management system


What do you means DataBase Management System?

A system that allows you maintain and administer a database.


History of database management system?

top 10 significant people,event,history development in database management system


What are the main functions of a database management system?

create the database