Saturday, August 16, 2014

DB2 DISPLAY DATABASE CLAIMERS Command


This command displays, in addition to the information related to the status of the database, information about all the claims on the database objects (table spaces, indexes and partitions) and the logical partitions that have logical claims, and the claims associated with them.

The syntax of the command is:
DISPLAY DATABASE(db) SPACENAM(sp) CLAIMERS

where db is the database name and sp is the space or index space name. Specifying SPACENAM is optional. If not specified, or SPACENAM(*) is specified, DB2 displays information about claimers on all the objects in the database.

For example, Figure shows the display resulting from the DISPLAY DATABASE CLAIMERS command.




CLAIMINFO is the type and duration of currently held claims. The claim is composed of a claim class descriptor (CC) and a claim duration (CD) descriptor in
the format: (CC,CD).

The CC descriptor has one of the following values:
• CS claim class (A CS claim is acquired when data is read from a package or plan bound specifying ISOLATION(CS))
• RR claim class (An RR claim is acquired when data is read from a package or plan bound specifying ISOLATION(RR))
• Write (WR) claim class (A write claim is acquired when data is deleted, inserted, or updated)

The CD descriptor describes the duration of the claim as follows:
• A, the claim is held until deallocation.
• C, the claim is held until the next commit point.

• H, the claim is held across commit points.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.