Hi there.
We are running DB2 v7.2 for Win NT on Windows 2000 SP3 machine with
poor configuration AMD 1800+, 512MB RAM and usual IDE harddisk. During
tests of migration our batch programmes written in Visual Age
Generator by IBM from OS390 to Win2000 was this machine our test
machine and migrated programmes ran quick enough there. Batch
programmes are generated into C++ code from VaGen 3.1, compiled by
MSVC++ and run on the machine with IBM VaGen server 3.1 using
Smalltalk environment 4.5 (if i remember exactly).
For real application we are using 2x Intel Xeon 2200MHz, 2 GB memory,
5x 36GB SCSI in RAID 5, Win2000 SP4 with Terminal Services connecting
by Remote Desktop from WinXP wrkstn and running our batchs remotely
(test machine didn't run Terminal Services).
Part of one of our batches is reading a file and inserting rows into
table. Usually it's about 100.000 lines. After that those lines are
evaluated, several queries are made and data is inserted into other
tables.
Performance problems occur while reading the file and inserting into
table. Table is not temporary and resides in SMS tablespace. Insertion
process takes about 3x more time, than on the test machine. I tried to
configure database completely the same way, as on the test machine,
but nothing changed. I tried various configurations of DB2, but didn't
see any improvements. CPU's are usually idle (just 3-7% of load).
Considering SCSI drives, there should not be a problem with drives'
performance. DB2 configuration was the same as the test machine's.
There is no configuration of VaGen server (or I didn't find any),
configuration of ODBC driver is the same as well. So where is the
problem? Only difference I know about is Terminal Services access on
the server; we accessed the test machine locally. I always start the
batch (using FCWRUN.EXE - VaGen launcher) and close the Remote Desktop
clien. I can't test performance of the server locally, it is located
in the customer's server hall.
Do you have any advice for me, or experiences with Terminal Services?
Thanks a lot!