Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

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

    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
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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
    Last edited by grofaty; 10-04-07 at 04:35.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •