In an IBM®
DB2® for Linux, UNIX and Windows environment, the database administrator creates the
database, table space, and user account.
Procedure
To create a database, table space, and user account for content
federation:
- Log on as the database instance owner.
- Create a database, giving it a unique name of 1 to 8 characters.
- Within this database, create a regular and a system temporary table space. Use the UTF-8 code set for the DB2 for Linux, UNIX and Windows
database server.
- Specify a table space page size of 8 KB and a table space
size of at least 50 MB.
- Create a user local to the operating system and add it to any DB2 Users group that exists. This user is referred to as cfs_db_user.
- Add this user to DB2 for Linux, UNIX and Windows as
a database user.
- Assign the regular and system temporary table spaces that you created to this user and grant
this user the following permissions:
- CONNECT database authority
- CREATETAB database authority
- USE privilege on the table space