Prerequisites for creating an Amazon RDS for Db2 DB instance (original) (raw)

The following items are prerequisites before creating a DB instance.

Administrator account

When you create a DB instance, you must designate an administrator account for the instance. Amazon RDS grants DBADM authority to this local database administrator account.

The administrator account has the following characteristics, capabilities, and limitations:

• Is a local user and not an AWS account.
• Doesn't have Db2 instance-level authorities such as SYSADM,SYSMAINT, or SYSCTRL.
• Can't stop or start a Db2 instance.
• Can't drop a Db2 database if you specified the name when you created the DB instance.
• Has full access to the Db2 database including catalog tables and views.
• Can create local users and groups by using Amazon RDS stored procedures.
• Can grant and revoke authorities and privileges.

The administrator account can perform the following tasks:

• Create, modify, or delete DB instances.
• Create DB snapshots.
• Initiate point-in-time restores.
• Create automated backups of DB snapshots.
• Create manual backups of DB snapshots.
• Use other Amazon RDS features.

Additional considerations

Before creating a DB instance, consider the following items:

• Each Amazon RDS for Db2 DB instance can host up to 50 Db2 databases. For more information, see Multiple databases on an Amazon RDS for Db2 DB instance.
• Initial database name
  • If you don't provide a database name when you create a DB instance, Amazon RDS doesn't create a database.
  • Don't provide a database name under the following circumstances:
    * You want to modify the db2_compatibility_vector parameter. For more information, see Setting the db2_compatibility_vector parameter.
• In the Bring Your Own License (BYOL) model, you must first create a custom parameter group that contains your IBM Customer ID and your IBM Site ID. For more information, see Bring Your Own License for Db2.
• In the Db2 license through AWS Marketplace model, you need an active AWS Marketplace subscription for the particular IBM Db2 edition that you want to use. If you don't already have one, subscribe to Db2 in AWS Marketplace for the IBM Db2 edition that you want to use. For more information, see Db2 license through AWS Marketplace.