Preparing your external Db2 database

Prepare your external IBM Db2 database by using the provided the database preparation scripts.

1. Install your Db2 database by using the provider's documentation.
2. Configure the Db2 instance by creating and running the following script as the instance owner, for example db2inst1:

   ./db2configinst.sh <instance_name> <port> <db2_installation_directory>
   

   For example:

   ./db2configinst.sh db2inst1 50001 /home/db2inst1/sqllib
   

3. Create the Db2 database by creating and running the following script as the instance owner:

   ./db2createdb.sh <db_name> <instance_name> US <db2_installation_directory> <linux_user_who_owns_db>
   

   For example:

   ./db2createdb.sh mrefdb db2inst1 US /home/db2inst1/sqllib mref
   

4. Connect to the Db2 database by creating and running the following script as the instance owner:

   db2 connect to $DB_NAME

   Ensure that you replace $DB_NAME with the required value.

5. Create the Db2 table space instance by creating and running the following script as the instance owner:

   db2 -tvf create-ts.sql
   

6. Set up SSL and extract the certificate by creating and running the following script as the instance owner:

   ./ssl-setup.sh <instance_name>