Prerequisites for creating an Amazon RDS for Db2 DB instance
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 ACCESSCTRL
authority to this local database
administrator account.
The administrator account has the following characteristics, capabilities, and limitations:
-
Is a local user and not an Amazon Web Services account.
-
Doesn't have Db2 instance-level authorities such as
SYSADM
,SYSMAINT
, orSYSCTRL
. -
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 a single Db2 database.
-
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 use Amazon RDS stored procedures to create or drop a database.
-
You want to create a database that uses an EBCDIC collation sequence. For more information, see EBCDIC collation for Db2 databases on Amazon RDS.
-
You want to restore backups from Amazon S3.
-
You are migrating from AIX or Windows. For more information, see Migrating from AIX or Windows to Linux for Amazon RDS for Db2.
-
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 Amazon Web Services Marketplace model, you need an active Amazon Web Services Marketplace subscription for the particular IBM Db2 edition that you want to use. If you don't already have one, subscribe to Db2 in Amazon Web Services Marketplace for the IBM Db2 edition that you want to use. For more information, see Db2 license through Amazon Web Services Marketplace.