Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    27

    Unanswered: Optimizing DB2 V7.2

    I Have a problem optimizing my DB2 database. Currently I am running on an NT machine,Multiprocessor, using 1 G. of memory. I have 3 instances, DB2 instance, DAS instance and another instance for our production Database. When we start to connect to any Database, my Physical Memory is jumping to around 60% is that normal? How do i tune it to make it run faster?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Optimizing DB2 V7.2

    Your question is too generic .... Though I feel that your scenario is not uncommon ...

    Well, for Performance Tuning DB2, there the following resouces on the web will help
    (1) http://www.redbooks.ibm.com (DB2 UDB V7.1 Performance Tuning Guide, in particular)
    (2) http://www.db2mag.com/dbadmin/
    (3) http://www.idug.org/journal/index.cfm


    Originally posted by ken_ken
    I Have a problem optimizing my DB2 database. Currently I am running on an NT machine,Multiprocessor, using 1 G. of memory. I have 3 instances, DB2 instance, DAS instance and another instance for our production Database. When we start to connect to any Database, my Physical Memory is jumping to around 60% is that normal? How do i tune it to make it run faster?

  3. #3
    Join Date
    Oct 2001
    Posts
    68
    You can thank Windows memory management for you spike. Our AIX environment shows increased memory usage but nowhere near 600Mb (60%) per connect. Sathyaram_s is correct, your question is very generic and understanding bufferpool management and the wealth of DB2 options out there and their impact is a good starting point.

    BTW: Your reference to the 60% spike, was that for *one* single connection or multiple. DB2 will not start everything straight away and the first connect always results in additional processing. We have a "starter" process that is fired from the startup scripts to simmulate the first connection so the users don't get upset.

    WP

Posting Permissions

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