Required settings for DB2 database on Linux, UNIX, and Windows operating systems
When you are creating DB2® database on Linux®, UNIX, and Windows operating systems, use the required settings to ensure IBM® Sterling Control Center Monitor can use the database.
| Required setting | Production DB | 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 Large Table spaces may optionally be used. |
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 |
||
|
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 IBM Sterling Control Center Monitor configuration must have these permissions for the database. |