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

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.
Note: System connections can now be secured using the SSL protocol. For more information, see Using SSL security for Explorer connections, and Managing SSL security and certificates.

Procedure

  1. Click Window > Manage connections.
  2. In the Host Connections view, select Performance Analyzer and click Add. The Add Performance Analyze Connection dialog opens.
    The Add Performance Analyze Connection dialog
  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.
    Secure connection (TLS/SSL) Select this field if the connection uses SSL security.
    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 Save and Close to save the configuration without connecting or Click Save and Connect to save the configuration and connect immediately.
  5. If you chose to connect immediately, you will need to select your user credentials.

What to do next

When you click Save and 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 try to connect again.