Adding an archive connection

Follow these steps to add an archive connection.

Procedure

  1. From any window within the CAE browser client, click Application menu > Archive Connections > Manage.
  2. Click Add.
  3. In the Name field, type a name for your archive connection.
  4. Define the Db2®connection using one of the following methods:
    1. Choose from a list of discovered Db2 subsystems.
      The Choose DB2 From List tab shows the Db2 locations, ports, and hosts that Db2 Query Monitor has automatically discovered. Select the appropriate values from the following lists:
      System
      The system where the performance history database to which you want to connect resides.
      DB2
      The Db2 subsystem where the performance history database to which you want to connect resides.
    2. Enter connection information.
      If the Db2 subsystem to which you want to connect is not available on the Choose DB2 From List tab, you can enter the connection information on the Enter Connection Information tab instead tab. Specify the following fields:
      Location
      The location name where the performance history database resides.
      Host
      The host where the performance history database resides.
      Port
      The data listener port of the Db2 subsystem where the performance history database resides.
  5. Specify secure connection settings.
    1. Check the Use SSL box to use SSL for the connection.
    2. From the Truststore list, select the appropriate truststore.
    3. Type the appropriate secure port in the Secure Port field.
  6. Specify table information.
    1. In the Schema field, type the schema associated with the performance history database to which you are creating a connection.
    2. If you want to override default table names, click Edit Table Names and modify the table names as needed.
      Note: This option is not commonly used. If, when creating the performance history database, you specified alternate table names, you would use this dialog to enter those table names.
    3. Select the Calculate Percent Columns check box if you want to calculate the percent columns.
  7. Specify user defined function settings.
    1. Type the creator of the UDF that is used to format host variables in the UDF Creator field.
    2. Type the name of the UDF that is used to format the host variables in the UDF Name field.
  8. Click Save.