Connecting to a database

You can analyze CMF performance data that is produced by CICS® Performance Analyzer for z/OS® and stored in a database.

Before you begin

You must define at least one connection credential before you can configure a database connection. See the topic Defining connection credentials in the CICS Explorer User Guide for further information.

Before proceeding, ensure that you have all your database connection details, that you have the correct level of authorization, and that you are connected to your company's network.

Procedure

  1. Click Window > Preferences from the workbench menu bar, and click Connections. The Connections pane is displayed in the Preferences view. . The example below shows a screen capture of the PA Connections pane containing sample connection details to a DB2® database.
    PA Data sources dialog showing sample connection details to a DB2 database.
  2. From the Type pull down menu select Performance Analyzer, and click New to create a new connection.
  3. Fill in the fields with the details provided by your system administrator. The following table provides a description of the fields.
    Option Description
    Name The local name used to identify this database connection. The name can be anything you choose and is used only to help you distinguish between different database connections.
    Host name The TCP/IP host name of your database server.
    Port Number The port used to access the server.
    Credentials Your credentials for the database.
    Database name The name of the database on the server.
    Schema (Qualifier) The name of the schema used for the database.
    Table name The name of the table created by CICS Performance Analyzer for z/OS during the view creation step.
  4. Click Apply to save the configuration.
  5. Click Connect.

What to do next

When Connect is clicked, the CICS PA plug-in attempts to connect to the database you have configured. If you did not previously enter your password, you are asked to enter it now.

If the connection is successful, a message is displayed in the CICS Explorer™ status bar and the connection icon is green. You can now select data for analysis. See the related link below for further information.

If the connection is not successful, an error message is displayed in the CICS Explorer status bar providing a reason for the failure. Check the values in the fields, correct any errors, and click Connect to retry the corrections.

When the connection is successful, click OK to close the Preferences view.

If you have not clicked Apply, you can cancel the process and close the Preferences view without saving the new connection, by clicking Cancel. If you have already clicked Apply, you must click Delete to remove the connection.