Displaying table space status

Use the 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 window.
  2. Select one of the radio buttons in the Space information to be displayed group box relating to Usage, Locks, Current claims , and Logical page list entries . 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 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.
  5. If you want to select the Restricted table spaces check box, this includes those page sets that have logical page list entries.
  6. Click Refresh to update the display on your screen. Change the options and click Refresh again to produce different output.

Related information