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 Catalog Manager for Db2 13.1.

Connecting to a specified SSID


You can connect the attached SSID to another SSID by using one of the following methods:

  • Specifying access values on a panel
  • Specifying the CONNECT command and parameters

To specify the access values on a panel

  1. From the Primary Menu panel, enter CONNECT (CON) on the Command line.The Change Access panel is displayed.
  2. In the Server field, type the server name or location name.A Server connection enables you to perform actions that are accomplished by using SQL.

    Tip

    You can enter a question mark (?) in the Server and Collection fields. Catalog Manager displays a Connection Selection List panel from which you can select a server and collection name.

  3. In the Collection field, type the collection name for the catalog, catalog view, or catalog copy that you want to use.
  4. (optional) In the Server SSID field, type the SSID of the server to which you want to connect.

    Note

    Enter the correct server SSID to enable generation of batch jobs such as utilities, BIND, REBIND, and FREE. Before you submit any jobs for execution, ensure that the JCL has the correct STEPLIB and routing information.

  5. Press Enter.The Change Access panel is displayed (see the following figure). The collection ID that Catalog Manager is using on the connected SSID is displayed in the Current Value column and in the short message area of the panel.

     DLK1-R ------------------------  Change Access  ------------------------------
     Command ===>                                                                   
                                                                                   
     Display quick connections list  . . . . . .  N (Y/N)                           
     Display product plans and connections table  N (Y/N)                           
                                                                                   
     The left column shows the current values of your Catalog Manager attach and    
     connection.  Enter in the right column the changes you want to make.  If a     
     "Change to" field is blank or the same as the "Current Value" field no action  
     will be taken.  If you are not sure of the correct values to enter, put a      
     question mark (?) in the field for a selection list.                           
                                                                                   
     The RESET command will attach you to your original SSID and open the original  
     plan, set to your original collection and reset the server to blanks.          
                                                                                   
            DB2V  Current Value       Change to             Changes                 
     SSID    12   DLK1                                      Call Attach             
     Plan         ACT1211M                                                          
                                                                                   
     Server                                                 Current Server          
     SQLid        RDACRJ2                                   SQLid on Server         
     Server SSID                                            SSID of Server          
     Collection                                             Direct/Indirect         
                                                                                    
  6. Press END to display the Primary Menu panel.The current connection is noted at the bottom of the panel.

To specify the CONNECT command and parameters

From the Primary Menu panel, enter CONNECT (CON) parameters on the Command line. The following table defines the parameters:

Parameter

Definition

Location

Identifies the remote Db2 SSID

The remote Db2 SSID must be defined in the SYSIBM.LOCATIONS table of the local Db2 SSID and must be connected by using the IBM distributed data facility (DDF).

Collection

(optional) Names the collection and package set for the remote Db2 SSID

The default value is the collection that the local Db2 SSID uses. If you are specifying a SQLID parameter, you can use the default value for the collection by specifying any single nonblank character (for example, ?, $, ., +, or =).

SQLID

(optional) Specifies the current SQLID for the remote DB2 SSID

The default value is the SQLID that the local DB2 SSID uses.

For the following examples, assume that the value of location is DEEG:

Example

Using the default collection and SQLID:

CONNECT DEEG

Using the default collection for SQLID RDACRJ:

CONNECT DEEG ? RDACRJ

Using the ACT101 collection for SQLID RDACRJ:

CONNECT DEEG ACT101 RDACRJ

Using the ACT101 collection for the default SQLID:

CONNECT DEEG ACT101



 

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