Connecting to a database

You can analyze performance data that is produced by CICS® Performance Analyzer for z/OS® and stored in a database such as DB2. You must connect to the database before you can analyze the data, to do this you must create a credential, a set of information that you use to authenticate a connection to the PA plug-in.

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.

You must have your database connection details, the correct level of authorization, and be connected to your company's network.

Procedure

  1. Open the Connections pane. Click Window > Preferences, expand CICS Explorer, and select Connections:
    PA Data sources dialog showing sample connection details to a DB2 database.
  2. From the Type drop-down list, select Performance Analyzer, and click New to create a new connection.
  3. Complete the fields with the details provided by your system administrator:
    Option Description
    Name The local name used to identify this database connection. The name can be anything you choose and is used 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. By default, DB2 on z/OS® listens for connections on port 448.
    Credentials Your credentials for the database.
    DB2 Location The name of the DB2 location on the server.
    DB2 Schema (Qualifier) The name of the schema used for the database.
  4. Click Apply to save the configuration.
  5. Click Connect.

What to do next

When you click Connect, the CICS PA plug-in attempts to connect to the database you have configured. If you did not previously enter your password in your credential settings, 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.

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

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.