Displaying table space status

Use the Display Table Space or Display All Table Spaces window to show the current status of one or more DB2 table spaces.

Authorities. Authorities and privileges

To customize the status output for a table space:

  1. Open the Display All Table Spaces or Display Table Space window.

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

  3. Type the Maximum number of messages that you want to see, or accept the default value. Each informational line of the display database 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.

  4. If you want to select the Display only database information check box, this show only database information. No space information is in this display.
  5. If you want to select the Active table spaces check box, this limits the display to table spaces that have had internal DB2 resources allocated to applications and are in a started state.

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

  7. 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.
  8. Click the Display push button to display the status of the selected table space or table spaces 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