Working with Informix databases

If you created a Informix database deployment in your IBM Cloud Pak for Data cluster, you can access the integrated console to manage user access and determine connection information.

When your database is running, you can complete the following tasks:

Accessing the database

Database users and administrators can access the database.

To access the database:
  1. Sign in to the Cloud Pak for Data web client.
  2. From the navigation menu, select Collect > My data.
  3. Open the Databases tab.
  4. Open the actions menu for the database that you want to access and select Open database.
  5. From the menu, select Status to get specific details about your Informix instance.

Connecting to the database from another application

You can use Informix client drivers to connect to the database from another application.

To find out the connection details for all the Informix listeners:
  1. Sign in to the Cloud Pak for Data web client.
  2. From the navigation menu, click My instances.
  3. Click on the name of the instance you want to work with.

The connection URL is displayed under the Access Information section of the Database details page.

Alternatively, you can use the JDBC URL to connect to the database from another application.

Note: For security reasons the password is no longer displayed in the connection URL. To achieve it you will need to extract it from a secret:
$ oc extract secret/informix-<id>-<username>-cpdauth --keys=password --to=-
# password
SQPjGokaBD7HXwsR
where you need to replace <username> by the username that you will find in the connection URL.
To connect to the database:
  1. From the navigation menu, select Collect > My data.
  2. Open the Databases tab.
  3. Open the actions menu for the database that you want to connect to and select Details.

    The connection URL is displayed under the Access Information section of the Database details page.

Note: For security reasons password is no longer displayed in the connection URL. To achieve it you will need to extract it from a secret:
$ oc extract secret/informix-<id>-<username>-cpdauth --keys=password --to=-
# password
5YfXY1aPWqgur3wZ
where you need to replace <username> by the username that you will find in the connection URL.

Deleting a database

A database administrator can delete a database.

To delete a database:
  1. Sign in to the Cloud Pak for Data web client.
  2. From the navigation menu, click My instances.
  3. Open the actions menu for the database that you want to access and select Delete.