Known issues and limitations for Amazon RDS for Db2 - Amazon Relational Database Service
Authentication limitationNon-fenced routinesNon-automatic storage tablespaces during migrationSetting the db2_compatibility_vector parameter

Known issues and limitations for Amazon RDS for Db2

The following items are known issues and limitations for working with Amazon RDS for Db2:

Authentication limitation

Amazon RDS sets db2auth to JCC_ENFORCE_SECMEC by default. However, if you don't want to enforce userid and password encryption over the wire, you can override this setting by changing the db2auth parameter to CLEAR_TEXT in the parameter group. For more information, see Modifying parameters in a DB parameter group in Amazon RDS.

Non-fenced routines

RDS for Db2 doesn't support the creation of non-fenced routines and the migration of these routines by backing up and restoring data. To check if your database contains any non-fenced routines, run the following SQL command:

SELECT 'COUNT:' || count(*) FROM SYSCAT.ROUTINES where fenced='N' and routineschema not in ('SQLJ','SYSCAT','SYSFUN','SYSIBM','SYSIBMADM','SYSPROC','SYSTOOLS')

Non-automatic storage tablespaces during migration

RDS for Db2 doesn't support the creation of new non-automatic storage tablespaces. When you use native restore for a one-time migration of your database, RDS for Db2 automatically converts your non-automatic storage tablespaces to automatic ones, and then restores your database to RDS for Db2. For information about one-time migrations, see Migrating from Linux to Linux for Amazon RDS for Db2 and Migrating from AIX or Windows to Linux for Amazon RDS for Db2.

Setting the db2_compatibility_vector parameter

With Amazon RDS, you can create an initial database when you create the DB instance and then modify parameters in an associated parameter group. However, for Db2, if you want to set the db2_compatibility_vector parameter in a parameter group, you must first modify the parameter in a custom parameter group, create the DB instance without a database, and then create a database using the rdsadmin.create_database stored procedure.

To set the db2_compatibility_vector parameter

  1. Create a custom parameter group. (You can't modify parameters in default parameter groups.)

  2. Modify the parameter.

  3. Create a DB instance.

  4. Create a database using the rdsadmin.create_database stored procedure.

  5. Associate the parameter group with the DB instance that contains the database.