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

  1. Click Window > Preferences from the workbench menu bar, and click IBM CICS Performance Analyzer > Data sources. The Data sources dialog for CICS Performance Analyzer is displayed in the Preferences view. If it has been pre configured, you see the connection details displayed, otherwise the fields are blank. The example below shows a screen capture of the PA Data sources dialog containing sample connection details to a DB2® database.
    PA Data sources dialog showing sample connection details to a DB2 database.
  2. 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.
    Server Address The TCP/IP host name of your database server.
    TCP/IP Port Number The port used to access the server.
    Database Name The name of the database on the server.
    Schema (Qualifier) The name of the schema used for the database.
    Userid Your authorized user ID for the database.
    Password Your password for the system. If you leave this field blank, you are asked to enter your password when the connection is attempted.
    Save Password Clicking this box saves your password on your computer.
  4. Click Apply to save the configuration.
  5. Click Test Connection.
What to do next
When Test Connection 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 box opens at the bottom of the Data sources dialog showing the status, and you can now select data for analysis. See the related link below for further information.

If the connection is not successful, the message box displays an error message providing a reason for the failure. Check the values in the fields, correct any errors, and click Connect to test 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.

Related information
Selecting, viewing, and sorting data in the PA sheet view