Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

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.

QuickCourseArrow.png

For more information, view the Quick Course Workbench for DB2 - Using the Connection Manager.

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


New

Classic

Description

NW_user_green.png

g_gud_MyConnection.png

Db2 connections that you own

NW_lock_gold.png

g_gud_DiscoveredLockedConnection.png

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

NW_users_green.png

g_gud_SharedConnection.png

Public Db2 connections that a superuser created

NW_user_orange.png

g_gud_OthersConnection.png

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

NW_circle_line_square.png

g_gud_UnsupportedConnection.png

An unsupported version of a Db2 connection

BMC AMI Command Center supports Db2 Version 10.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.

New console
  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.
Classic console
  1. On the browser's main menu bar, click Apps .
  2. Click Connections connection_manager_app_64.png .
  3. Click Add-16.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 g_gud_save.png.

To remove a Db2 connection


Note

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.

New console
  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.
Classic console
  1. On the browser's main menu bar, click Apps .
  2. Click Connections connection_manager_app_64.png.
  3. Select a DB2 connection that you can edit.
  4. Click Delete-16.png.
  5. When asked to confirm, click Yes.
  6. Click g_gud_save.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.

New console

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.
Classic console

Tip

In many dialog boxes where you must select a Db2 connection, you can also edit the list of favorites by clicking ViewFavoritesList-24.pngnext to the DB2 Connection field.

  1. On the browser's main menu bar, click Apps.

  2. Click Connectionsconnection_manager_app_64.png
    The Connection Manager displays all subsystems that are automatically discovered, public Db2 connections, and any Db2 connections that you create.

    • g_gud_Favorite-on.png next to a Db2 connection indicates that the Db2 connection is included in the list of favorites. This icon is dimmed (g_gud_Favorite-off.png) if the connection is excluded from the list.
    • g_gud_status_major.png indicates a connection to an unsupported Db2 version. (BMC AMI Command Center supports DB2 Version 10.1 and later.)

    Tip

    Click refresh-24.pngto 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 g_gud_Favorite-Add.png to include a connection in the list.
    • Click g_gud_Favorite-Remove.png to exclude a connection from the list.
  4. Continue adding or excluding connections in your favorites list, and click  g_gud_save.png  when finished.

 

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