Known issues and limitations for Amazon RDS for Db2
The following items are known issues and limitations for working with Amazon RDS for Db2:
Topics
Authentication limitation
Amazon RDS sets DB2AUTH
to JCC_ENFORCE_SECMEC
. Because
JCC_ENFORCE_SECMEC
can't be modified, Amazon RDS enforces password
encryption on JDBC connections.
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 One-time migration from Linux to Linux environments and One-time migration from AIX or Windows to Linux environments.