DB\DBM cfg while Moving from 8.2.7 and 32 bit windows server to 64 bit Db2 9.3

rahul_s80 · #1 (**permalink**) 10-03-07, 09:17

now our client is seriously considering of moving to 64 bit Db2 9.3
we are at present on 8.2.7 and 32 bit windows server.
we have plans to migrate to db2 9 at first without using the automated tuning and auto table maintenance features.
But since we are also moving from 32 to 64 bit, we will now be having far more memory space to play with.
i want to know which parameters i should condider changing with the added space available now ?
would appreciate any pointers on the topic

grofaty · #2 (**permalink**) 10-04-07, 03:31

Hi,
try out the following command:

Code:

db2 AUTOCONFIGURE APPLY NONE

this command suggest how parameters shout be set. It is good starting point. Look into additional parameters, for example:

Code:

db2 AUTOCONFIGURE USING MEM_PERCENT 80 WORKLOAD_TYPE
 MIXED NUM_STMTS 2 TPM 8 ADMIN_PRIORITY PERFORMANCE 
IS_POPULATED YES NUM_LOCAL_APPS 1 NUM_REMOTE_APPS 0 
ISOLATION RR APPLY NONE

If you would like to apply recommended settings then use "apply db only" instead of "apply none".

Read documentation to see what kind of system you have:
http://publib.boulder.ibm.com/infoce...e/r0008960.htm

Hope this helps,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech