Creating, viewing, or editing Db2 subsystems

About this task

On the Db2® Subsystems panel (ETI$SSLS), you can create, select, delete, edit, view, or copy information about a Db2 subsystem on which to run Db2 Table Editor.

Procedure

  • To create a new Db2 subsystem entry, specify CREATE on the Command line and press Enter.
    Figure 1. The New DB2 Subsystem panel (ETI$SSCR)
    
                  New DB2 Subsystem            
     ETI$SSCR                                  
     Enter new DB2 subsystem profile options:  
       DB2 SSID . ._____________               
                                               
     Press ENTER to process                    
     Press F12 to cancel                       

    On the New DB2® Subsystem panel (ETI$SSCR), specify a new Db2 subsystem on which to run Db2 Table Editor, and press Enter.

  • To select, delete, edit, view, or copy information, on the Db2 Subsystems panel (ETI$SSLS), specify S (Select), D (Delete), E (Edit), V (View), or C (Copy) in the Cmd field next to an existing SSID and press Enter.

    If you specify E (Edit) or V (View), you can edit or view information for the Db2 subsystem on the Db2 Subsystem Parameters panel (ETI$SSPR).

    Figure 2. Db2 Subsystem Parameters panel (ETI$SSPR)
    
     ETI$SSPR                   DB2 Subsystem Parameters       2016/03/08  15:20:46 
     Option ===> __________________________________________________________________ 
                                                                                   
     SSID . . . . . : TST                                                           
     Description  . . _________________________________________________             
                                                                                    
     Plan name  . . . ETIPLAN                                                      
                                                                                    
     DB2 Loadlib1 . . _________________________________________________             
     DB2 Loadlib2 . . _________________________________________________             
     DB2 Loadlib3 . . _________________________________________________             
     DB2 Loadlib4 . . _________________________________________________             
     DB2 Loadlib5 . . _________________________________________________             
                                                                                    
    

    On the Db2 Subsystem Parameters panel (ETI$SSPR), you can view or edit information in the following fields:

    Field Description
    SSID The Db2 subsystem being edited, viewed, or created.
    Description A meaningful description of the subsystem; this value can be up to 44 alphanumeric characters.
    Plan name (Required) The product plan to be used when connecting to the Db2 catalog; this value can be up to 8 alphanumeric characters. There is no default value.
    DB2 Loadlib (Required) The name of the data set that comprises the current load library concatenation for Db2, and is used during batch job processing; this value can be up to 47 alphanumeric characters. There is no default value. The load library usually consists of a subsystem-specific DSNEXIT library, the base DSNEXIT library for the current Db2 version, and the base DSNLOAD library for the current Db2 version.
    DB2 Loadlib2,3,4,5 (Optional) The names of additional libraries that are required for the subsystem during batch job processing.