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
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/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 ZDT/Db2 displays when you use the Object List utility.
  2. You can also customize which columns ZDT/Db2 displays when you use the Object List utility. For details, see the Z Data Tools 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
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