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.