Selecting the Db2® subsystem by using the Db2 SSID field

When you start FM/Db2, the Primary Option Menu panel is displayed.

Figure 1. Primary Option Menu panel
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                Primary Option Menu

 0  Settings      Set processing options               User ID . : FMNUSER
 1  View          View Db2 object                      System ID : MVS8
 2  Edit          Edit Db2 table                       Appl ID . : FMN2
 3  Utilities     Perform utility functions            Version . : 14.1.21
 4  SQL           Prototype, execute and analyze SQL   Terminal  : 3278
 5  Db2I          Start Db2 Interactive                Screen  . : 1
 6  Command       Enter and execute a Db2 Command      Date  . . : 2019/01/07
 7  Template      Template utilities                   Time  . . : 08:54     
 X  Exit          Terminate FM/Db2 
                                                       Db2 SSID  . DFG2
                                                       SQL ID  . . FMNUSER   +






 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

The Db2 SSID field shows the ID of the Db2® subsystem to which FM/Db2 is currently connected. (The Db2® subsystem is also shown before the panel title.) In Primary Option Menu panel, FM/Db2 is connected to the DFG2 subsystem.

To select a Db2® subsystem using the Db2 SSID field, you can use any of the following methods:
  • Overtype the SSID that is currently displayed with the ID of another active Db2® subsystem, and then press Enter.

    For example, in Primary Option Menu panel, to connect to the Db2® subsystem DFB2, overtype DFG2 with DFB2, and then press Enter.

  • Enter an asterisk (*) or blanks in the Db2 SSID field, and then press Enter. FM/Db2 displays the Db2 Subsystem Selection panel showing a list of all the Db2® subsystems in your environment from which you can select the Db2® subsystem you want.
  • Enter a partial ID, starting or ending with an asterisk (*), or enclosed within two asterisks, in the Db2 SSID field, and then press Enter. FM/Db2 displays the Db2 Subsystem Selection panel showing a restricted list of Db2® subsystems from which you can select the Db2® subsystem you want.
    The following examples demonstrate how you can use the (*) wildcard if specifying a partial Db2® subsystem ID:
    DB*
    Lists all Db2® subsystems whose ID starts with DB
    *TST
    Lists all Db2® subsystems whose ID ends with TST
    *2*
    Lists all Db2® subsystems whose ID contains 2
Note: To change the Db2® subsystem from a panel other than the Primary Option Menu panel, use the SSID command.

Related tasks

Related references