Logging in to the database in Cloud Pak for Data

Important: IBM Cloud Pak® for Data Version 4.6 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.6 reaches end of support. For more information, see Upgrading IBM Software Hub in the IBM Software Hub Version 5.1 documentation.

You can log in to the database from any application server pod. After you log in, you can run SQL commands by using CLPPlus.

Procedure

Log in to any of the application server pods.
Use one of the following methods:
Using the web client

In the Red Hat® OpenShift® console, go to an application server pod and open a terminal.

Using the command line
1. Log in to your Red Hat OpenShift cluster as a project administrator:
  oc login OpenShift_URL:port
2. Change to the project where the Cloud Pak for Data control plane is installed:
  oc project <Project>
3. Log in to the application server pod and open a terminal:
  oc exec -it openpages-<instance_name>-sts-<N> -- /bin/bash
  To find the pod name, run oc get sts and look for a name that starts with openpages-.
Log in to the database by running the following commands:
If you're using an internal database:
```
clpplus -nw openpage/$(cat /var/run/op-secrets/op-db-secret/openpage-pw)@OPX
```
If you're using an external database:
```
source /opt/ibm/OpenPages/bin/provision-dbsecrets.sh
clpplus -nw openpage/${OPDB_PASSWORD}@EXTDB
```
You are now logged in to the database and you can run SQL commands.