Connecting to Db2 subsystems

BMC AMI Command Center

 discovers all Db2 subsystems available for use based on the installation configuration defined for your site. The DB2 connections menu lists the discovered subsystems. You can also add connections to remote Db2 subsystems.

When you initially open the Connection Manager, a table of discovered connections is displayed. An icon indicates the type of connection (See the following table). Unless you are a superuser, you can see only your own connections, public connections, and the discovered connections. You can use the following procedure to add connections.

Connection type icons

Icon

Description

NW_user_green.png

Db2 connections that you own

NW_lock_gold.png

Db2 connections that Connection Manager discovered and that no one (not even a superuser) can remove

NW_users_green.png

Public Db2 connections that a superuser created

NW_user_orange.png

Non-public Db2 connections visible to superusers, but owned by other users

NW_circle_line_square.png

An unsupported version of a Db2 connection

BMC AMI Command Center supports Db2 Version 12.1 and later.

To add a Db2 connection

You might want to give an easily identifiable name to a local Db2 connection or create a remote Db2 connection. Only you and superusers can view, use, and edit connections that you have created.

  1. In the upper left corner of the console, click Apps.
  2. On the App bar, click NW_plug_connect_square_green.png.
  3. Click NW_plus_circle_o.png.
  4. Complete the Add DB2 Connection dialog box:
    1. Enter a name that describes the connection.
    2. Select a local subsystem.
    3. If you want to connect to a remote subsystem, enable Remote Subsystem and select from the menu a remote subsystem that is connected to the selected local subsystem.
    4. (superusers only) Select  Public if you want to enable creating public connections that all users can use.
    5. Click OK.
  5. Click NW_floppy.png.

To remove a Db2 connection

Important

You cannot remove a Db2 connection if a workspace is using it. Also, unless you are a superuser, you can edit or remove only Db2 connections that you created. See Connection type icons.

  1. In the upper left corner of the console , click Apps.
  2. On the App bar, click NW_plug_connect_square_green.png.
  3. Select a Db2 connection that you can edit.
  4. Click NW_minus_circle_o.png.
  5. When asked to confirm, click Yes.
  6. Click NW_floppy.png

To edit the list of favorite Db2 connections

You can filter the list of favorite Db2 connections to display only those that are relevant to you. This list populates the menu of Db2 connections from which you select a connection. Until you make a selection, no favorite connections are set and all connections are available in the DB2 Connections field.

Tip

In many dialog boxes where you must select a DB2 connection, you can also edit the list of favorites by clicking NW_plug_connect_square_green.png next to the DB2 Connection field.

  1. In the upper left corner of the console , click Apps.

  2. On the App bar, click NW_plug_connect_square_green.png.
    The Connection Manager displays all subsystems that are automatically discovered, public DB2 connections, and any DB2 connections that you create.

    • NW_star.png next to a Db2 connection indicates that the Db2 connection is included in the list of favorites. This icon ( NW_star_o.png ) is displayed if the connection is excluded from the list.
    • NW_circle_line_square.png indicates a connection to an unsupported Db2 version. (BMC AMI Command Center supports Db2 Version 10.1 and later.)

    Tip

    Click NW_restart.png to update the list of discovered subsystems. For example, you might update the list after restarting a Db2 server or to see public connections that a superuser has added during your session.

  3. Select a Db2 connection and use the command bar to edit the list of favorite connections:
    • Click NW_star.png to include a connection in the list.
    • Click NW_star_o.png to exclude a connection from the list.
  4. Continue adding or excluding connections in your favorites list, and click NW_floppy.png when finished.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*