The machine is a PIII, I think 1000. It has 5 drives; 3 SCSI, 2 IDE.
Larger drives are IDE actually. Runs under Linux Mandrake 7.2, has 512M of
RAM. UDB 7.2.3 EE is able to insert about 7 million records in a table
that has 3-4 indexes, consists of 3 columns of integers, in about 1-2
hours of wall clock time.
There is little else going on on the machine, looking at the processes,
the first five processes of that machine belong to db2sysc, using between
70MB and 3K of RAM :) Most of the db2sysc's that I see, about 5 of them,
are using between 15MB and 70MB. The other 3 are using negligeable
amounts, like 3-5KB, according to 'top' , the unix process monitor.
What else, CPU wise, I see that most CPU is used up by 'System', about
85%, with only 11% used by the User. The db2sysc processes all appear to
be using between 7 and 13% of CPU.
This all seems strange to me, and too slow; first off I dont know why the
'System' is using up so much CPU on that machine, and why it takes so long
for these LOADs to finish.
I did not do too much UDB tuning on the version 7; namely because of my
db2admin problems I mentioned earlier - I am unable to use the
'performance optimization wizard' of the control center.
Any ideas what I should change from default or do otherwise?
Thanks, -turgut
PS: Here is a recent snaphot:
PPS: the same machine is also running UDB 6.1; under the instance name
"db2".. The UDB 7.2 is running as "db7" ..
123 processes: 120 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 11.0% user, 88.4% system, 0.5% nice, 0.0% idle
Mem: 516792K av, 514056K used, 2736K free, 410708K shrd, 134540K buff
Swap: 401584K av, 23836K used, 377748K free 146928K cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
2 root 8 0 0 0 0 SW 0 13.0 0.0 444:27 kflushd
17694 db7 6 0 63488 59M 60264 S 0 11.1 11.6 3:28 db2sysc
20165 db2 17 0 22060 15M 13248 R 0 10.4 3.1 1:03 db2sysc
17692 db7 10 0 66684 61M 62476 D 0 9.2 12.2 10:08 db2sysc
19261 db7 10 0 77932 70M 68032 S 0 7.8 14.0 7:34 db2sysc
17691 db7 10 0 66472 61M 62264 D 0 7.6 12.2 10:33 db2sysc
20329 db2 10 0 8640 2868 2640 S 0 7.6 0.5 0:01 db2sysc
20330 db2 9 0 8348 2576 2340 S 0 7.1 0.4 0:01 db2sysc
20331 db2 9 0 7720 1948 1720 S 0 7.0 0.3 0:00 db2sysc
20322 db7 14 0 944 944 696 R 0 6.3 0.1 0:03 top
17693 db7 1 0 63332 58M 60108 S 0 1.1 11.6 3:33 db2sysc
20252 db2 1 0 1916 1916 88 S 0 1.0 0.3 0:00 db2bp
1 root 1 0 112 76 56 S 0 0.9 0.0 6:41 init
4333 root 5 5 768 28 20 S N 0 0.9 0.0 1:05 httpd
-----
Turgut Kalfaoglu: http://www.kalfaoglu.com
EgeNet Internet Services: http://www.egenet.com.tr
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
