472,354 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

Performance problem (maybe cos of Terminal services?)

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

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!
Nov 12 '05 #1
0 2283

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Sara_S | last post by:
I am ready to move my ASP web site onto a remote host. The problem is that when I use Terminal Services to see the host machine, the error does not show up. (I was told that debugging info is only...
by: Josh Schmidt | last post by:
How can one set the terminal services profile and home directory path in AD using VB.NET? I can set the usual profile paths, but terminal services properties are not supported with ADSI. Any...
by: Bob Darlington | last post by:
It has been suggested to me (by a potential client) that my app (which he is considering buying) should be web enabled to improve performance, particularly regarding screen refreshes. My initial...
by: Paul H | last post by:
Say I have a Windows 2000 server running Terminal Services with a single file Access DB (not front end/back end) on it, could multiple users access the data base simultaneously? Paul
by: TPoise! | last post by:
Using: .NET 1.1, Visual Studio 2003, C#, Microsoft Windows 2000 Server (SP4 and all latest windows updates), Terminal Server running in application mode. I have a C# application that I've...
by: Brian Young | last post by:
My department is responsible for creating custom internal applications for many of our departments. Our strategy has always been to develop our applications as ActiveX controls (VB6) that get...
by: OHM | last post by:
Hi peoples, I dont know where to place this question, so as I know you guys are all resourceful experts, I thought I would try here. I am writing some code which will be run usingh remote...
by: shawn | last post by:
In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How can I make this work with SQL and Terminal and...
by: NAdir | last post by:
Hi, thank you for your help. My VB.Net application contains a document that the user can refresh at any time. The refresh works fine and needs to loop through few datatables (hundreds of rows)....
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made but the http to https rule only works for...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.