Connecting to your Amazon RDS for Db2 DB instance with IBM Db2 CLP

Run ./db2_install -f sysreq and choose yes to accept the license.

Choose the location to install the client.

Run clientInstallDir/instance/db2icrt -s client instance_name. Replace instance_name with a valid operating system user on Linux. In Linux, the Db2 DB instance name is tied to the operating system username.

This command creates a sqllib directory in the home directory of the designated user on Linux.

Sign in with the username that you specified during the IBM Db2 CLP client installation.

Catalog your RDS for Db2 DB instance. In the following example, replace node_name, dns_name, and port with a name for the node in the local catalog, the DNS name for your DB instance, and the port number.

db2 catalog TCPIP node node_name remote dns_name server port

Example

db2 catalog TCPIP node remnode remote database-1.123456789012.us-east-1.amazonaws.com server 50000

Catalog the rdsadmin database and your database. This will allow you to connect to the rdsadmin database to perform some administrative tasks using Amazon RDS stored procedures. For more information, see Administering your RDS for Db2 DB instance.

In the following example, replace database_alias, node_name, and database_name with aliases for this database, the name of the node defined in the previous step, and the name of your database. server_encrypt encrypts your username and password over the network.

db2 catalog database rdsadmin [ as database_alias ] at node node_name authentication server_encrypt
    
db2 catalog database database_name [ as database_alias ] at node node_name authentication server_encrypt

Example

db2 catalog database rdsadmin at node remnode authentication server_encrypt
    
db2 catalog database testdb as rdsdb2 at node remnode authentication server_encrypt

Connect to your RDS for Db2 database. In the following example, replace rds_database_alias, master_username, and master_password with the name of your database, the master username, and master password of your RDS for Db2 DB instance.

db2 connect to rds_database_alias user master_username using master_password

This command produces output similar to the following example:

Database Connection Information
    
    Database server        = DB2/LINUXX8664 11.5.9.0
    SQL authorization ID   = ADMIN
    Local database alias   = TESTDB

Run queries and view results. The following example shows a SQL statement that selects the database you created.

db2 "select current server from sysibm.dual"

This command produces output similar to the following example:

1
    ------------------
    TESTDB
    
    1 record(s) selected.

Locate the bind files on the client machine. Typically, these files are located in the bnd directory of the Db2 client's installation path and have the extension .bnd.

Connect to the Db2 server. In the following example, replace database_name with the name of your Db2 server. Replace master_username and master_password with your information. This user has DBADM authority.

db2 connect to database_name user master_username using master_password

Run the bind command to bind the packages.

1. Navigate to the directory where the bind files exist on the client machine.

2. Run the bind command for each file.

   The following options are required:

   • blocking all – Binds all packages in the bind file in a single database request.

   • grant public – Grants permission to public to execute the package.

   • sqlerror continue – Specifies that the bind process continues even if errors occur.

   For more information about the bind command see BIND command in the IBM Db2 documentation.

Verify that the bind was successful by either querying the syscat.package catalog view or checking the message returned after the bind command.