EBCDIC collation for Db2 databases on Amazon RDS - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

EBCDIC collation for Db2 databases on Amazon RDS

RDS for Db2 supports EBCDIC collation for Db2 databases. You can only specify an EBCDIC collation sequence for a database when you create the database by using the Amazon RDS rdsadmin.create_database stored procedure.

When you create an RDS for Db2 DB instance by using the Amazon Web Services Management Console, Amazon CLI, or RDS API, you can specify a database name. If you specify a database name, Amazon RDS creates a database with the default collation of SYSTEM. If you need to create a database with EBCDIC collation, don't specify a database name when you create a DB instance.

The collation for a database in RDS for Db2 is set at the time of creation and is immutable. If you specified a database name when you created a DB instance and you want a database with EBCDIC collation, delete the DB instance and create a new one.

To create a Db2 database with EBCDIC collation

  1. Create an RDS for Db2 DB instance without specifying a database name by using the Amazon Web Services Management Console, Amazon CLI, or RDS API. For more information, see Creating a DB instance.

  2. Create a Db2 database and set the collation option to an EBCDIC value by calling the rdsadmin.create_database stored procedure. For more information, see rdsadmin.create_database.

    Important

    After you create a database using the stored procedure, you can't change the collation sequence. If you want a database to use a different collation sequence, drop the database by calling the rdsadmin.drop_database stored procedure. Then, create a database with the required collation sequence.