How can I use certificates when Db2 or PostgreSQL is in SSL mode?
How can I use certificates when Db2 or PostgreSQL is in SSL mode?
If you have Db2 or PostgreSQL set up in
SSL mode on a UNIX operating system, you can add the database certificate to the
existing certificates. You can use this configuration on the following components:
- master domain manager
- dynamic domain manager
- Dynamic Workload Console
When configuring Db2 new version driver (DB2 4.34.30) in SSL mode, ensure your certificates specify the hostname of the workstation hosting the Db2 database.
Proceed as follows:
- On the workstation where you plan to install the master domain manager, create a folder for storing the certificates.
- Within this folder, create a subfolder named additionalCAs.
- Obtain the certificates from the database administrator.
- Store the certificates in .crt format in the additionalCAs folder.
- Log in to the component for which you are configuring the database, as listed above.
- Run the configureDb script as explained in
- Creating and populating the database for DB2 for the master domain manager and Creating and populating the database for DB2 for the Dynamic Workload Console OR
- Creating and populating the database for PostgreSQL or PostgreSQL cloud-based databases for the master domain manager and Creating and populating the database for PostgreSQL or PostgreSQL cloud-based databases for the Dynamic Workload Console
- Proceed with the installation as described in Typical installation scenario.