Select to specify the maximum number of messages
Specify a maximum number of messages. The default value is 50.
Show status of table spaces alone, without index space information.
Show databases with spaces that have resources allocated and are in a started state.
Show databases, table spaces, or indexes in restricted status.
Limits the display to indexes and table spaces to which read/write access is allowed, but for which some action is recommended.
Display summary.
Displays information about:
- Applications and subsystems of the database or space that have internal DB2 resources allocated
- Applications and subsystems of the database or space on whose behalf locks for the space are held or waited upon
- Connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces and partitions whose statuses are displayed
- LUWID and location of any remote threads accessing the local database
Displays information about:
- Applications and subsystems on whose behalf locks are held, waited upon, or retained for the database or space
- Transaction locks for all table spaces, tables, index spaces and partitions whose statuses are displayed
- Connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces whose statuses are displayed
- LUWID and location of any remote threads accessing the local database
- Drain locks for a resource held by running jobs
- Logical partitions that have drain locks and the drain locks associated with them
- Retained locks for a resource
- Page set or partition physical locks (P-locks) for a resource
Displays information about:
- Claims on all table spaces, index spaces and partitions whose statuses are displayed
- LUWID and location of any remote threads accessing the local database
- Connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces whose statuses are displayed
- Logical partitions that have logical claims and the claims associated with them
Displays logical page list entries.
Displays 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.
The report is displayed 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.
Displays output. If you make changes in the window, click Refresh again to update the display.
Closes the window.