The following items are prerequisites before creating a DB instance.
Administrator accountWhen 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.
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:
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 (BYOL) 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.
Db2 local time zone
Multiple Db2 databases
Did this page help you? - Yes
Thanks for letting us know we're doing a good job!
If you've got a moment, please tell us what we did right so we can do more of it.
Did this page help you? - No
Thanks for letting us know this page needs work. We're sorry we let you down.
If you've got a moment, please tell us how we can make the documentation better.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4