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

Run this and post results:
"select * from syscat bufferpools"
Also post the amount of memory on your server.

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

Your buffer pools are rather small. I suggest you run the DB2 Configuration Advisor to get a good base line setup of your system.