Results 1 to 4 of 4

Thread: DB2 Slow

  1. #1
    Join Date
    Apr 2008
    Posts
    21

    Unanswered: DB2 Slow

    Hi All,

    My database is running slow.

    I have HRMS application in house made. The server setup & configuration details are :


    server 1 contains :
    AIX 5.3 ML 4.
    WAS 5.1

    Server 2 Contains :
    AIX 5.3 ML 4
    DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08021"
    with level identifier "03020106".
    Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
    Product is installed at "/usr/opt/db2_08_01".


    The DBM and DB parameter files are attahced here :

    Please look into the DBM and DB parameter files and suggest the chnages in the parameters.



    Thnaks,

    Mohan Reddy
    Attached Files Attached Files

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Run this and post results:
    "select * from syscat bufferpools"
    Also post the amount of memory on your server.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2008
    Posts
    21
    Bufferpool details :

    IBMDEFAULTBP 1 [Null] 1000 4096 N 0 0
    EDBBP 2 [Null] 500 32768 N 0 0
    LABP 3 [Null] 500 32768 N 0 0
    PRBP 4 [Null] 500 32768 N 0 0
    SPBP 5 [Null] 250 32768 N 0 0
    SRVBP 6 [Null] 250 16384 N 0 0
    IBMDEFAULTBP1 7 [Null] 250 32768 N 0 0

    Memory Usage Details :

    db2mtrk -i -d -v
    Tracking Memory on: 2008/10/06 at 13:59:09

    Memory for instance

    Database Monitor Heap is of size 245760 bytes
    Other Memory is of size 2310144 bytes
    Total: 2555904 bytes

    Memory for database: TRVPROD

    Backup/Restore/Util Heap is of size 16384 bytes
    Package Cache is of size 14745600 bytes
    Catalog Cache Heap is of size 393216 bytes
    Buffer Pool Heap is of size 8437760 bytes
    Buffer Pool Heap is of size 4440064 bytes
    Buffer Pool Heap is of size 753664 bytes
    Buffer Pool Heap is of size 491520 bytes
    Buffer Pool Heap is of size 360448 bytes
    Buffer Pool Heap is of size 294912 bytes
    Lock Manager Heap is of size 491520 bytes
    Database Heap is of size 4915200 bytes
    Other Memory is of size 0 bytes
    Total: 35340288 bytes

    Memory for database: HRMPRODU

    Backup/Restore/Util Heap is of size 32768 bytes
    Package Cache is of size 173703168 bytes
    Catalog Cache Heap is of size 999424 bytes
    Buffer Pool Heap is of size 8437760 bytes
    Buffer Pool Heap is of size 4341760 bytes
    Buffer Pool Heap is of size 8437760 bytes
    Buffer Pool Heap is of size 16662528 bytes
    Buffer Pool Heap is of size 16662528 bytes
    Buffer Pool Heap is of size 16662528 bytes
    Buffer Pool Heap is of size 4440064 bytes
    Buffer Pool Heap is of size 753664 bytes
    Buffer Pool Heap is of size 491520 bytes
    Buffer Pool Heap is of size 360448 bytes
    Buffer Pool Heap is of size 294912 bytes
    Lock Manager Heap is of size 8503296 bytes
    Database Heap is of size 5619712 bytes
    Other Memory is of size 0 bytes
    Total: 266403840 bytes

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Your buffer pools are rather small. I suggest you run the DB2 Configuration Advisor to get a good base line setup of your system.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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