Connecting to your Amazon RDS for Db2 DB instance with IBM Db2 Data Management Console

Connect to the rdsadmin database. In the following example, replace master_username and master_password with your own information.

db2 connect to rdsadmin user master_username using master_password  

Create a buffer pool for IBM Db2 Data Management Console. In the following example, replace database_name with the name of the repository you created for IBM Db2 Data Management Console to monitor your RDS for Db2 DB instances.

db2 "call rdsadmin.create_bufferpool('database_name', 
     'BP4CONSOLE', 1000, 'Y', 'Y', 32768)"

Create a user tablespace for IBM Db2 Data Management Console. In the following example, replace database_name with the name of the repository you created for IBM Db2 Data Management Console to monitor your RDS for Db2 DB instances.

db2 "call rdsadmin.create_tablespace('database_name', 
     'TS4CONSOLE', 'BP4CONSOLE', 32768)"

Create a system temporary tablespace for IBM Db2 Data Management Console. In the following example, replace database_name with the name of the repository you created for IBM Db2 Data Management Console to monitor your RDS for Db2 DB instances.

db2 "call rdsadmin.create_tablespace('database_name',
    'TS4CONSOLE_TEMP', 'BP4CONSOLE', 32768, 0, 0, 'S')" 

Download IBM Db2 Data Management Console from IBM Db2 Data Management Console Version 3.1x releases on the IBM Support website.

Install IBM Db2 Data Management Console.

Open IBM Db2 Data Management Console and use the IP address of your Amazon EC2 machine and the port number you used for the HTTP or HTTPS connection to your Amazon EC2 instance. For example, use http://xx.xx.xx.xx:11080 or https://xx.xx.xx.xx.11081. Replace xx.xx.xx.xx with the IP address of your Amazon EC2 machine. 11080 and 11081 are the default ports for HTTP and HTTPS connections.

(Optional) If you want to use port 80 or 443 on your Amazon EC2 instance, you can use either Apache httpd or a Nginx HTTP server to proxy the IBM Db2 Data Management Console port to either port 80 or 443. For more information, see Apache HTTP Server Project and the nginx website.

To allow connection to IBM Db2 Data Management Console, you must edit the inbound rules in your security group. If you use a proxy, change the TCP/IP port 80 or 443 to redirect to the IBM Db2 Data Management Console ports. If you aren't using a proxy, change the TCP/IP port 80 or 443 to the default ports 11080 (HTTP) or 11081 (HTTPS).

Log in to IBM Db2 Data Management Console with the credentials you set during installation.

Configure the repository.

1. In the Connection and database section, enter the following information for your RDS for Db2 DB instance:

   • For Host, enter the DNS name of the DB instance.

   • For Port, enter the port number for the DB instance.

   • For Database, enter the name of the database.

   

2. In the Security and credential section, enter the following information for your RDS for Db2 DB instance:

   • For Security type, choose Encrypted user and password.

   • For Username, enter the name of the database administrator for the DB instance.

   • For Password, enter the password of the database administrator for the DB instance.

3. Choose Test connection.

   Note

   If the connection is unsuccessful, confirm that the database port is open through the inbound rules in your security group. For more information, see Considerations for security groups with Amazon RDS for Db2.

   If you didn't manually create a buffer pool, a user tablespace, and a system temporary tablespace in RDS for Db2, you might see the following error message:

   

   Make sure that you created a buffer table, a tablespace, and objects for an IBM Db2 Data Management Console repository to monitor your RDS for Db2 DB instance. Or, you can use an Amazon EC2 Db2 DB instance to host an IBM Db2 Data Management Console repository to monitor your RDS for Db2 DB instance. For more information, see Step 1: Creating a repository database to monitor DB instances.

4. After you successfully test your connection, choose Next.

   

If IBM Db2 Data Management Console finds the buffer pool, the user tablespace, and the system temporary tablespace in the RDS for Db2 DB instance, then IBM Db2 Data Management Console automatically configures the repository database. If you use your Db2 instance on your Amazon EC2 instance as the repository database, then IBM Db2 Data Management Console automatically creates the buffer pool and other objects.

In the Set statistics event monitor opt-in window, choose Next.

(Optional) Add new connection. If you want to use a different RDS for Db2 DB instance for administration and monitoring, then add a connection to a non-repository RDS for Db2 DB instance.

1. In the Connection and database section, enter the following information for the RDS for Db2 DB instance to use for administration and monitoring:

   • For Connection name, enter the Db2 database identifier.

   • For Host, enter the DNS name of the DB instance.

   • For Port, enter the port number for the DB instance.

   • For Database, enter the name of the database.

   

2. In the Security and credential section, select Enable monitoring data collection.

3. Enter the following information for your RDS for Db2 DB instance:

   • For Username, enter the name of the database administrator for the DB instance.

   • For Password, enter the password of the database administrator for the DB instance.

4. Choose Test connection.

5. After you successfully test your connection, choose Save.

After the connection is added, a window similar to the following appears. This window indicates that your database was successfully configured.

Choose Go to Databases. A Databases window similar to the following appears. This window is a dashboard that shows metrics, statuses, and connections.

In the left navigation bar, choose SQL.

Enter a SQL command.

Choose Run all.

To view the results, choose the Results tab.