Displaying database status

Use the Display Database or Display All Databases window to show the current status of one or more DB2 databases, table spaces, tables in segmented table spaces, index spaces within a database, and partitions of partitioned table spaces and index spaces.

Authorities and privileges

To customize the status output for a database:

  1. Open the Display Database or Display All Databases window.

  2. Type the Maximum number of messages that you want to see, or accept the default value. Each informational line of the database display output begins with a DB2 for OS/390 message number, of the form DSNTxxxI. The maximum number of messages that can be displayed is limited by the space available. You can type an asterisk (*) to set the limit at the maximum.
  3. If you want to select the Display only database information check box, this show only database information. No space information is in this display.

  4. If you want to select the Active spaces check box, this limits the display to table spaces or index spaces that have had internal DB2 resources allocated to applications and are in a started state or to databases that contain such spaces.

  5. If you want to select the Restricted databases and spaces check box, this includes those page sets that have logical page list entries.

  6. If you want to select the Advisory information check box, this limits the display to indexes and table spaces to which read/write access is allowed. Selecting this displays indexes and tables spaces for which some action is recommended.

  7. Select one of the radio buttons in the Space information to be displayed box relating to Usage, Locks, Current claims, Logical page list entries, or Write error page range. If you accept the Default, you get the error page range information for certain table spaces, index spaces, and partitions.

  8. Click the Display push button to display the status of the selected database or databases depending on your selections. You can change the options and click the Display push button again to produce different output.

  9. Click the Close button to close the window.

Related information