
126 Unveil Your e-business Transaction Performance with IBM TMTP 5.1
Ensure adequate heap size of the TWH_CDW database
The applications control heap size on the TWH_CDW database must be set to at
least 512, as follows:
1. Log on using the DB2 administrator user ID to your TEDW Server machine, in
our case db2admin, and connect to the TWH_CDW database:
db2 connect to TWH_CDW user db2admin using <db2pw>
where <db2pw> is the database administrator password.
2. In order to determine the actual heap size issue, use this command:
db2 get db cfg for TWH_CDW | grep CTL_HEAP
Output should be similar to Example 5-1.
Example 5-1 Current applications control heap ...