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:
- The system option, Show all catalog table columns, affects which columns ZDT/Db2 displays when you use the Object List utility.
- 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 |
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 |