Setting up DB2 databases
When you are creating DB2® databases on Linux®, UNIX, and Windows operating systems, use the required settings defined below for Control Center Director to use the DB2 databases.
Required setting | Database Schema | More information |
---|---|---|
Code set |
UTF-8 |
Set this setting during database creation. |
Buffer Pools |
One buffer pool with the page size of 32K One buffer pool with the page size of 16K One buffer pool with the page size of 8K One buffer pool with the page size of 4K |
A default buffer pool is created as part of the database creation. The page size of the buffer pool defaults to the page size specified during database creation. |
Regular Table Spaces |
One regular table space with the page size of 32K One regular table space with the page size of 16K One regular table space with the page size of 8K One regular table space with the page size of 4K |
One regular default table space is created as part of the database creation. The size of the table space defaults to the page size specified during database creation. |
User Temporary Table Spaces |
One user temporary table space with a page size of 32K |
|
System Temporary Table Spaces |
One system temporary table space with a page size of 32K |
|
Table Space permissions |
The database user must have access permissions to the newly created table spaces |
|
Database user permissions |
CREATETAB, BINDADD, CONNECT, IMPLICIT_SCHEMA |
The database user ID that will be specified during Control Center Director configuration must have these permissions for the database. |