Connecting to your Amazon RDS for Db2 DB instance with DBHawk

This blog post explains how to connect to your AWS RDS Db2 database with DBHawk.

First login to your AWS account and create a Db2 database.

Choose the right license version and database version

Choose the right credentials

After successfully creating your database, find out endpoint and port number

Now go to DBHawk and configure this connection

Here important is how to pass JDBC parameters to the JDBC URL

jdbc:db2://db2.cngaig57t2r1.us-east-1.rds.amazonaws.com:50000/dsparc:encryptionAlgorithm=2;securityMechanism=7;

encryptionAlgorithm=2

securityMechanism=7

Click on Test to make sure that connection is working

Connect to the Db2 database and run query to get the Db2 version information

Download sample books schema and create tables and insert data

Insert the data

For more examples and tutorials, visit https://www.db2tutorial.com/