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 'HFM0I*' in the Name field and change the "Object type" value to '1'. This will show all databases that start with "HFM0I". See Figure 1
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  . . . . . . . . . HFM0I*                                            +
    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 Figure 2
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  ****
        HFM0IVD  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 HFM0IVD database entry and press Enter. See Figure 3.
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 Figure 4.
Figure 4. Database Structure for HFM0IVD panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 ZDT/Db2 (DFF2)          Database Structure for HFM0IVD                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---   HFM0IVD----------------    PERTHAP   16716      0      0
         S       HFM0IVSC                 PERTHAP   16716      6      0
          T        Employee-Detail-Copy   HFM0USR   16716      0     24
         S       HFM0IVSD                 PERTHAP   16716      2      0
          T        Department-Information HFM0USR   16716      0      9
           I         Dept Info Index N2   HFM0USR   16716      0     13
           I         Dept Info Index N3   HFM0USR   16716      0     15
           I         Dept Info Index U1   HFM0USR   16716      0     11
         S       HFM0IVSE                 PERTHAP   16716      4      0
          T        Employee-Detail        HFM0USR   16716      0     16
           I         Employee Index N2    HFM0USR   16716      0     23
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

Press PF3 repeatedly to return to the ZDT/Db2 main menu.

This completes the ZDT/Db2 IVP.