Connecting to the host CICS PA database

You must connect to the host CICS PA database to analyze the statistics alerts. You must create a credential which is a set of authentication information that you use to connect to the host PA database.

Before you begin

You must have your database connection details, the correct level of authorization, and be connected to your company's network. See the topic "Defining connection credentials" in the CICS Explorer® User Guide for further information.

Procedure

  1. Open the CICS® PA plug-in to the CICS Explorer.
  2. Click Window > Preferences, expand CICS Explorer, and select Connections.
  3. From the Type drop-down list, select Performance Analyzer, and click New to create a new connection.
  4. 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.
  5. Click Apply to save the configuration.
  6. Click Connect.

What to do next

When you click Connect, the CICS PA plug-in to the CICS Explorer 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. Click OK to close the Preferences view.

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.

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.



connecting_to_db.html | Timestamp icon Last updated: Sunday, 4 June 2017