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