Table Spaces panel

You use the Table Spaces panel to list table space object types in the Db2® catalog.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSTABLESPACE.

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                     Table Spaces
 Location:                                                          Format TABL


 SEL    NAME     CREATOR            DBNAME     DBID   OBID   PSID BPOOL
        *        *                  *             *      *      * *       
 ----   #1--+--- #2--+----1----+--- #3--+--- ----#4 ----#5 ----#6 #7--+---
 ****  Top of data  ****
        DEPTRV8R YEH                DSNDB04       4     41     42 BP0
        DSN32K01 CJUNELL            DSNDB07       7      3      4 BP32K
        DSN4K01  CJUNELL            DSNDB07       7      1      2 BP0
        DSN8S81C CJUNELL            DSN8D81P    260      1      2 BP0
        DSN8S81D CJUNELL            DSN8D81A    259      1      2 BP0
        DSN8S81E CJUNELL            DSN8D81A    259      3      4 BP0
        DSN8S81P CJUNELL            DSN8D81A    259      7      8 BP0
        DSN8S81Q CJUNELL            DSN8D81P    260      3      4 BP0
        DSN8S81R CJUNELL            DSN8D81A    259      5      6 BP0
        DSN8S81S CJUNELL            DSN8D81A    259      9     10 BP0
        DSNASDMA CJUNELL            DSNATPDB    257      5      6 BP0
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
Note:
  1. The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
  2. You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager Customization Guide.

To view other columns on this panel, press the Right function key (F11).

For a complete list of columns, refer to Db2® catalog tables in the DB2 for z/OS SQL Reference relevant to your version of Db2®.

SEL
Line command area.
For a list of the line commands you can use on this panel, see Object list line commands.

Parent panels

Child panels

To display this panel… Use/do this
Alter Table Space panel Line command A
Create Table Space panel Line command CR
Create Table panel Line command CRT
Databases panel Line command D
See Drop panels Line command DR
Database Structure panel Line command DS
Grant privileges panels Line command G
Generate SQL From Db2 Catalog panel Line command GEN
Details panels Line command I
Recovery Information panel Line command ICS
Privileges panels Line command P
Table Space Parts panel Line command PT
Revoke privileges panels Line command R
Display Row panel Line command ROW
Tables, Views and Aliases panel Line command T
Db2 Utilities panel Line command UTL
Sort Fields panel Primary command SORT

Related tasks

Related references