Displays information about:
-
Spaces that have internal DB2 resources allocated
-
Spaces on whose behalf locks for the space are held or waited upon.
-
The connection IDs, correlation IDs, and authorization IDs for all applications
allocated to spaces and partitions whose status is displayed.
Displays information about:
-
The applications and subsystems on whose behalf locks are held, waited
upon, or retained for the database or space
-
The transaction locks for all table spaces, tables, index spaces and partitions
whose statuses are displayed
-
The connection IDs, correlation IDs, and authorization IDs for all applications
allocated to spaces whose status is displayed
-
The LUWID and location of any remote threads accessing the local database
-
The drain locks for a resource held by running jobs
-
The logical partitions that have drain locks and the drain locks associated
with them
-
The retained locks for a resource
-
The page set or partition physical locks (P-locks) for a resource
Displays information about:
-
The claims on all table spaces, index spaces, and partitions whose status
is displayed
-
The LUWID and location of any remote threads accessing the local database
-
The connection IDs, correlation IDs, and authorization IDs for all applications
allocated to spaces whose statuses are displayed
-
The logical partitions that have logical claims and the claims associated
with them
Displays a list of pages that cannot be referenced by applications
until the pages are recovered. The page is in 'logical error' because there
might be nothing wrong with the media (coupling facility or DASD) itself.
Usually a connection to the media has been lost.
Displays a information about physical write errors.
Limits the display to:
Table spaces or index spaces that have had internal DB2 resources allocated
to applications and that are in a started state
Databases that contain such spaces
Limits the display to databases, table spaces, or indexes in a restricted
status. This set includes page sets that have logical page list entries.
Select to specify the maximum number of messages.
Limits the display to index information only. If you specify the Locks
setting, DB2 displays tables with table locks
Limits the display to spaces which allow read/write access, but for which some
action is recommended.
Displays information about the status of index spaces.
Specify a maximum number of messages. The default value is 50.
The index report displays in this box. Click the Refresh
push button to generate a new report.
Closes the notebook or window.
Updates the information if you change settings.