IBM DB2 Database Configuration Considerations

The following table describes IBM DB2 database configuration considerations.

Product	Tablespace Considerations
General—All products	Minimum tablespace requirements: A buffer pool and a tablespace with a 32 KB page size A system temporary buffer pool and a system temporary tablespace with a 32 KB page size Note: The default tablespace for the database user that owns the repository must not be partitioned. Increase settings as follows: bufferpool_name buffer pool from 1000 (default) to 32000 (about the size of the largest audit table and indexes) IBMDEFAULTBP buffer pool from 1000 (default) to 100000 tmp_bufferpool_name buffer pool from 1000 (default) to 8000 (temporary space buffer pool) DBHEAP from 1200 (default) to 33000 SORTHEAP from 256 (default) to 2000 LOGBFSIZ from 16 (default) to 128 Increase the heap size: DRDA_HEAP_SZ parameter — 2048 or greater STMHEAP, APPLHEAPSZ, and APP_CTL_HEAP_SZ parameters — 8096
Shared Services and Essbase Studio	Increase PAGESIZE to 32K. Increase bufferpool to 32768.
Performance Management Architect	Increase the heap size: LOGFILSZ to 4096 APPLHEAPSZ to 8192 STMTHEAP to 10240 Ensure that the user has privileges to create tablespaces and buffer pools. Ensure that the user has been granted the right to use the temporary tablespace.
Planning	Before you configure Planning, you must configure the database with a large enough tablespace (having a page size of at least 32 K) in order to support the Planning tables. The following sample SQL script creates the necessary buffer pool and tablespace. Change the names and the disk location to reflect your needs. By default, the tablespace is named HSPSPACE8_1 and is created in the C:\DB2DATA\HSPSPACE8_1 directory. The other settings are also defaults; the administrator should adjust the settings as appropriate for the environment. Example: CREATE BUFFERPOOL hsppool8_1 SIZE 250 PAGESIZE 32 K; CREATE REGULAR TABLESPACE hspspace8_1 PAGESIZE 32 K MANAGED BY SYSTEM USING ('c:\db2data\hspspace8_1') EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL HSPPOOL8_1; The database administrator must ensure that the user who logs on to the Planning relational database has rights to use the new tablespace.

Performance Scorecard–Specific IBM DB2 Database Configuration Requirements

You must complete the following procedure before you configure Performance Scorecard.

To prepare the IBM DB2 server:

Increase the database log size to 6500.

Modify this script with information specific to your database:

SET HPSDB=<hpsdatabase>
SET ADMIN=<adminusername>
SET ADMINPWD=<adminpassword>
SET TBSFILE=<table space file location>
SET TMPFILE=<temp file location>
DB2 CONNECT TO %HPSDB% USER %ADMIN% USING %ADMINPWD%
DB2 UPDATE DATABASE CONFIGURATION FOR %HPSDB% USING APPLHEAPSZ 512
DB2 CREATE BUFFERPOOL HPS_BP SIZE 250 PAGESIZE 32 K
DB2 TERMINATE
DB2STOP
DB2START
DB2 CONNECT TO %HPSDB% USER %ADMIN% USING %ADMINPWD%
DB2 CREATE REGULAR TABLESPACE HPS_SPACE1 PAGESIZE 32 K MANAGED BY SYSTEM USING ('%TBSFILE%') EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL HPS_BP
DB2 COMMENT ON TABLESPACE HPS_SPACE1 IS 'HPS Table Space'
DB2 GRANT USE OF TABLESPACE HPS_SPACE1 TO PUBLIC 
DB2 CREATE SYSTEM TEMPORARY TABLESPACE HPS_TEMP PAGESIZE 32 K MANAGED BY SYSTEM USING ('%TMPFILE%') EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL HPS_BP DB2 COMMENT ON TABLESPACE HPS_TEMP IS 'HPS Temporary Table Space'
DB2 TERMINATE
DB2STOP
DB2

Save the file as name.bat.
From the Command Center, execute the script.
Windows 2003 users, perform these steps:
1. Select Control Panel, then Computer Management, and then Users and Groups.
2. On the User Accounts box, click Advanced.
3. Select DB2Admin, right-click and select Properties.
4. On the Properties box, select Member Of.
5. Select Users, click Remove, and click Save.