Select to specify the maximum number of messages.
Type a maximum number of messages. The
default value is 50. To set the limit to the maximum number, type an asterisk (*).
Select this to limit the display to table spaces or index
spaces that have had internal DB2 resources
allocated
to applications and are in a started state.
Select this to limit the display to databases, table spaces,
or indexes in a restricted status. This set
includes page sets that have logical page
list entries.
Specify this to display a summary of information.
Specify this to display information about the space:
- 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.
- The LUWID and location of any remote threads accessing the local database.
Specify this to display 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.
Specify this to display 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.
Specify this to display a list of pages that cannot be referenced
by applications until the pages are recovered.
The page is in 'logical error' because there
may be nothing wrong with the media (coupling
facility or DASD) itself. Usually a connection
to the media has been lost.
Generates output to the display area based
on your selected options. If you change your
options, click this push button again to
generate a new report.
Displays a report here. Use the scroll
bar to navigate through the report, if report
is larger than the window. Resize the window
to display more text without scrolling.
Closes the window.