Why can't I connect watsonx Code Assistant for Z to my Db2 database?

watsonx Code Assistant for Z

During the initial cloud setup of your watsonx Code Assistant for Z instance, the automated population of your Db2 account fails.

If your database is associated with a different account than your IBM Cloud instance, or if the automated population in the onboarding checklist fails, use these steps to manually connect your database.

First, you need to collect authentication and hostname information from your Db2 service instance:

1. Log in to cloud.ibm.com.

2. Open the IBM Cloud account that contains your Db2 instance.

3. Click the Resource list icon .

4. Open the Databases section, then click your Db2 instance.

5. Click Service Credentials.

   If don't have service credentials, click New credential, then click Add.

6. Click the expand icon for the credentials.

7. Locate the authentication section and make note of the:

   • username
   • password

8. Locate the hosts section and make note of the:

   • hostname
   • port

Second, create a connection in your deployment space:

1. In your watsonx Code Assistant for Z instance, open your deployment space.

2. Click the Assets tab.

3. Click Import Assets.

4. Click Data access, then click the Connection tile.

5. On the New tab, select IBM Db2 on Cloud, then click Select.

6. Enter the following values to create your connection:

   • Name: A meaningful name for your connection
   • Database: bludb
   • Hostname or IP address: The hostname from the service credentials
   • Port: The port number from the service credentials
   • Username: The username from the service credentials
   • Password: The password from the service credentials

7. Click Test Connection. If the test completes successfully, click Create.