DB2 configuration for MDS:
We have tested the MDS with Windows 2000 IBM DB2 Universal Database Version 8.1. If you use DB2 for your MDS database, you may face some problems while working with large dialogues. To avoid these problems please configure your DB2 as described below.
Configuration of DB2 database for large dialogues:
In order to store big dialogues, a table with a row width greater than 8k, more than 500 columns needs to be created in DB2. You wil then need a buffer pool greater than 4k. To create a bufferpool and a tablespace each with 16k page size, run the following in the command center of DB2 interfaces:
CREATE BUFFERPOOL highmem SIZE 32 PAGESIZE 16K
CREATE TABLESPACE mds_tbsp PAGESIZE 16K MANAGED BY SYSTEM USING ('D:\DB2\MDSTABLESPACE') BUFFERPOOL highmem
Now, add this tablespace to the user as follows:
Open DB2 Control Center, Explore database, Go to Users & Groups, Rightclick on username, Select Change users, Go to tablespace tab and add required tablespace