Step 9. Use the ZDT/Db2 Object List utility

Log on to ZDT/Db2, and connect to the same Db2® system specified in Verifying the customization of ZDT/Db2.

Select the ZDT/Db2 Object List utility by typing '3.4' on the ZDT/Db2 main menu panel and press Enter.

Type 'HFMCI*' in the Name field and change the Object type value to '1'. This will show all databases that start with HFMCI. See Object List Utility panel
Figure 1. Object List Utility panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/Db2 (DFF2)                Object List Utility
 Command ===>                                                                  
                                                                    More:     +
    blank Display object list                 P Print object list

 Object Identification Criteria:
    Location  . . . . . . .                     Enter * for list
    Owner . . . . . . . . .                   +
    Name  . . . . . . . . . HFMCI*                                            +
    Database/collect/schema                                                   +

 Additional Selection Criteria:
  . . . . . . . . . . . . . . . . . . . . . . . Enter * to list catalog columns
    Column  . . . . . . . .                                 +
    Operator  . . . . . . .            
    Value . . . . . . . . .                                                   +

 Processing Options:
    Object Type                                Enter ? to list all object types
    1    1. Database          8.  Package            15. Trigger
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Press Enter to display the list of databases. See Databases panel
Figure 2. Databases panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/Db2 (DFF2)                     Databases                           Top of 1
 Command ===>                                                       Scroll CSR 
 1 rows fetched                                                     Format TABL
                          STORAGE  BUFFER     INTERNAL AUTHID
        DATABASE DATABASE GROUP    POOL       DATABASE THAT     TYPE OF  GROU+
 SEL    NAME     CREATOR  NAME     NAME     IDENTIFIER CREATED  DATABASE MEMB+
        *        *        *        *                 * *        *        *
 ----   #1--+--- #2--+--- #3--+--- #4--+---     ----#5 #7--+--- #23-+--- #11-+
 ****  Top of data  ****
        HFMCIVD  PERTHAP  SYSDEFLT BP0           16716 PERTHAP
 ****  End of data  ****









  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

Type '?' against the HFMCIVD database entry and press Enter. See Object List Line Commands panel.

Figure 3. Object List Line Commands panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/Db2 (DFF2)             Object List Line Commands                Row 1 of 15
 Command ===>                                                       Scroll CSR 

 Type S against the required line command and press Enter.

 Sel Command  Description

     A        Alter database
     CR       Create a database
     CRS      Create a table space
     DR       Drop database
     DS       Show database structure
     G        Grant privileges
     I        Details about database
     ICS      Show recovery information (image copies)
     P        Show privileges
     ROW      Show all columns for this row
     S        Show table spaces
     SG       Show storage group
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel
Type an 'S' against the "DS" entry to show the database structure. Press Enter. See Database Structure for HFMCIVD panel.
Figure 4. Database Structure for HFMCIVD panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/Db2 (DFF2)          Database Structure for HFMCIVD                Top of 15
 Command ===>                                                       Scroll CSR 
 15 rows fetched                                                    Format TABL

               OBJECT                     OBJECT
 SEL    TYPE   NAME                       OWNER    DBID   PSID   OBID
        *      *                          *             *      *      *
 ----   #10-   #12-+----1----+----2----+- #13-+--- ----#5 ---#19 ---#20
 ****  Top of data  ****
        D---   HFMCIVD----------------    PERTHAP   379      0      0
         S       HFMCIVSC                 PERTHAP   379      6      0
          T        Employee-Detail-Copy   HFMCUSR   379      0     26
         S       HFMCIVSD                 PERTHAP   379      2      0
          T        Department-Information HFMCUSR   379      0     11
           I         Dept Info Index N2   HFMCUSR   379      0     15
           I         Dept Info Index N3   HFMCUSR   379      0     17
           I         Dept Info Index U1   HFMCUSR   379      0     13
         S       HFMCIVSE                 PERTHAP   379      4      0
          T        Employee-Detail        HFMCUSR   379      0     18
           I         Employee Index N2    HFMCUSR   379      0     25
           I         Employee Index U1    HFMCUSR   379      0     23
         S       HFMCIVSR                 PERTHAP   379      8      0
          T        Department-Info-Errors HFMCUSR   379      0     29
         S       HFMCIVSS                 PERTHAP   379     10      0
          T        Employee-Detail-Errors HFMCUSR   379      0     30
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

Press PF7/PF8 to scroll the content and PF3 repeatedly to return to the ZDT/Db2 main menu.

This completes the ZDT/Db2 IVP.