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

Allow privileges for buffer pool and tablespaces.

1. Make changes to scripts, particularly for buffer pools and tablespaces. For more information, see Configuring a repository database in the IBM Db2 Data Management Console documentation.

2. 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  

3. 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', 16384)"

4. Create a 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', 16384)"

5. Create a 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', 16384, 0, 0, 'T')" 

Manually create IBM Db2 Data Management Console objects. For more information, see Configuring a repository database in the IBM Db2 Data Management Console documentation.

Start IBM Db2 Data Management Console.

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 security group's inbound rules. For more information, see Considerations for security groups with Amazon RDS for Db2.

   The following error message indicates that the admin user connecting to the RDS for Db2 DB instance doesn't have privileges to create buffer pools or tablespaces. It also indicates that for Db2 repository databases, the user must have DBADM and DATACCESS on the database. The user must also have SYSCTRL on the database-instance privilege.

   

   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 Creating a repository database to monitor DB instances.

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

   

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.