Results 1 to 6 of 6

Thread: DB2 Performance

  1. #1
    Join Date
    Nov 2011

    Unanswered: DB2 Performance


    DB2 9.7 /Win 2008 R2

    Only one 600GB database in the system.
    currently there are around 2500 concurrent session at a time.
    All users are web based (just read only) using the same query (static).
    (just viewing customer name, address, dob,and the photo graph (blob)).

    The question is, our customer is looking to double the users to 5000.
    can you please advise, what are the DATABASE / Instance CFG need to be consider tunning ?

    Currently the STMM is OFF.


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    That depends on what is your current bottleneck. I find MONREPORT.DBSUMMARY() to be a good starting point in determining that.
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    As well as the DB2 configurables e.g STMM, maintenance ON|OFF, INSTANCE MEMORY, also do a review of the Server Physical Memory - usage .
    Are you currently seeing any bottlenecks? If not , can you recreate on a Test system and monitor for bottlenecks?

  4. #4
    Join Date
    Nov 2011

    No bottlenecks

    4 CPU's and 6GB RAM in total on the server.
    CPU usage is very very minumal. During the RUNSTAT it use 70% usage (onfor for 30 min) otherwise it use below 10%.
    Memory usage is around 3GB. I have never seen it used over 3GB RAM.

    instance & database memory set to Automatic.

  5. #5
    Join Date
    Aug 2002
    Chennai, India
    Given that 50% of the memory is currently used for 2500 concurrent sessions, I would want to increase the physical memory by 50% to accommodate 5000 concurrent sessions. As CPU usage is predominantly 10% no change may be required here. Coming to the database, you may have to resize (increase) the existing buffer pools based on the hit ratio.

    During peak usage with 5000 concurrent users, you could also consider enabling STMM to autoconfigure related DB parameters and switch it off thereafter.

    Hope this helps.
    Last edited by ggnanaraj; 08-19-12 at 10:00.

  6. #6
    Join Date
    Nov 2011


    Thank you so much for your input, really help full.
    Thanks (Nanri) Gnanaraj

Posting Permissions

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