I have not found much on this new database type. I'm hoping someone is using toad for this today as we have been unable to establish any connections. (NOTE: I can connect using the command line and using other SQL software.. just not Toad)
I believe this requires the connection IBM DB2 LUW. Can anyone verify this is the correct connection to use. We are getting the 64bit driver error even after installing the most recent IBM client and have tried an unsuccessful ticket with Toad Support.
Toad Data Point does not officially list Amazon RDS for DB2 as a supported database in its documentation. However, it may still function with Amazon RDS for DB2 since RDS uses the standard IBM DB2 LUW (Linux, Unix, and Windows) engine, which Toad Data Point does support.
To connect to IBM DB2 LUW, you’ll need a supported DB2 Client installed on the host machine. The client’s architecture must match the version of Toad Data Point you’re using:
For 32-bit Toad, install a 32-bit DB2 Client
For 64-bit Toad, install a 64-bit DB2 Client
When configuring the connection in Toad, select IBM DB2 LUW as the database type. Use the endpoint, port, and credentials provided by Amazon RDS.
While this setup should work in theory, please note that Amazon RDS for DB2 is not officially supported, so we cannot guarantee full compatibility or functionality.