Determining the database to which you are connected

QMF provides several ways for you to view the name of the database to which you are currently connected. Viewing the current database name can help you orient yourself if you are accessing data in more than one location.

Procedure

To determine the database to which you are connected, choose one of the following options:

  • View the current database location on the QMF home panel.

    When you connect to a new database, that location name is displayed below the Connected to heading on the QMF home panel.

  • View the current database location by using a global variable. Enter SHOW GLOBALS.

    If the location name does not appear on the QMF home panel (for example, if you are connected to a Db2® subsystem without a location name), you can view the database location name by displaying the global variable DSQAO_CONNECT_LOC.

    The GLOBALS panel displays with a list of all the global variables that are provided by QMF and defined by users. The value of the DSQAO_CONNECT_LOC variable is the name of the database to which you are connected.