Hi Steve,
You *really* need more memory to run UDB properly, but if this is a "test"
server you can live with it if you go through the dbm config and reduce heap
sizes and various memory allocations etc. Use task manager to check how
much memory various processes are using - if your memory use is high you may
be going to your swapfile, which is relatively slow. The GUI is generally a
little slow - particularly with the new Java code. Java is fun, but
slooooow.
If this is a real server (with 128Mb - nah?!) then kick it up to at least
512Mb. You also want a *physically* separate drive for DB2 logs, so that the
data and logs aren't sharing a disk array. If your NT guru tells you it's a
RAID disk so it doesn't matter, smack them with a 2x4 until they listen to
reason.
regards,
Greg Palgrave
Database Administrator
Unisys WEST
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 July 2001 08:12
To: [EMAIL PROTECTED]
Subject: DB2EUG: Running like the proverbial dog.
Can anyone point me in the right direction please?
I have UDB (7.1) installed pretty much out of the box on a Pentium III with
128Mg.
Anything I do seems to take an age, I have checked out the DBA certification
guide
and listened to a webcast on performance but they are aimed at application
performance with which I am already familiar (several years m/f DBA).
As an example; if, in the control centre, I click on tables it takes 20-30
secs to
show a table list. A visual explain of a very simple select take about 45
secs.
Do I just need heaps more memory or are there some basic tuning parameters
which I should attack first? As I said earlier just some pointers to the
correct part of the doco would be good.
Or is this normal for little DB2 and I just have to get used to it?
TIA
Steve T
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
