473,594 Members | 2,799 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

7.2 client slower when connecting to 8.2

Hi
I have 2 servers
SERVER_A win 2000 UDB 7.2 db PRICE 14GB
SERVER_B win 2003 UDB 8.2 db PRICE_V8 14GB(Restored from backup of
PRICE on SERVER_A)

Connect from PC with admin client 7.2 fix pack 10
1. CONNECT TO PRICE_V8 run batch of 10 selects ,execution time 4
minutes
2. CONNECT TO PRICE run batch of 10 selects ,execution time 1
minute

Connect to PRICE_V8 directly on server SERVER_B
db2stop ,db2start , run same select (10 queris) ,execution time < 1
minute

Is it related to client version ?
LAN connection has same speed between PC and both servers

Thank you

Alex
Nov 12 '05 #1
2 1284
Alex wrote:
Hi
I have 2 servers
SERVER_A win 2000 UDB 7.2 db PRICE 14GB
SERVER_B win 2003 UDB 8.2 db PRICE_V8 14GB(Restored from backup of
PRICE on SERVER_A)

Connect from PC with admin client 7.2 fix pack 10
1. CONNECT TO PRICE_V8 run batch of 10 selects ,execution time 4
minutes
2. CONNECT TO PRICE run batch of 10 selects ,execution time 1
minute

Connect to PRICE_V8 directly on server SERVER_B
db2stop ,db2start , run same select (10 queris) ,execution time < 1
minute

Is it related to client version ?
LAN connection has same speed between PC and both servers

Thank you

Alex

Maybe completely unrelated but FYI, in DB2 UDB V8 the client server
protocol was changed from db2ra (proprietary) to SQLDA (open standard).
So the communication from V8 to a downlevel client is special.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
Serge Rielau wrote:
Maybe completely unrelated but FYI, in DB2 UDB V8 the client server
protocol was changed from db2ra (proprietary) to SQLDA (open standard). Not SQLDA of course.. it's DRDA.. darn acronyms... :-( So the communication from V8 to a downlevel client is special.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

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

Similar topics

2
2670
by: Richard Choate | last post by:
I'm writing an article and I need your informed opinions, so I ask you this: 1. Doesn't the web-enabled app generally run slower for one reason or another? 2. Isn't the fact that application graphics must be limited, just proof of #1, especially with low bandwidth situations? 3. Aren't the web-enabled apps really less feature rich because the developer has to emulate the controls of a thick/fat client app, and sometimes you just can't...
2
2513
by: news.microsoft.com | last post by:
Hi I write dll library which one of it component will be Net socket communication. Communication is working very good, but i've got problem when client is connecting. When server is started, client is connecting without problems; but when servre is down and i start client, client connect to server! Few lines from code: client.Socket = new Socket(AddressFamily.InterNetwork, SocketType.Stream,
5
1710
by: Rob R. Ainscough | last post by:
This is more of a conceptual question: 1. More and more companies are using VPN's and locking out internet connectivity (for a host of reasons, security, productivity, etc.). 2. ASP.NET requires a web server and has more layers than a .NET Windows application 3. a .NET windows app .DLL's and .EXEs are very small So which is better, offer a Windows .NET component ("managed") that can be downloaded installed from a web site or...
3
1558
by: Jo Davis | last post by:
www.shanje.com does sql server hosting, on shared servers, at a reasonable price. It seems. They also allow client connections. Just playing around I've managed to connect an Access Data Project to a SQL Server database, and to access the database from Enterprise Manager (running locally). First of all - what does anybody think of that as a general idea - local client, connecting to MS SQL Server running on a shared host, connecting...
7
3355
by: CT | last post by:
Hi, This might seem like a basic question but I have some doubts, please humour me. I have a client-server application using java where each client on each machine needs to directly communicate directly with the database. Do I need a separate db2 connect on each such machine. Please advice.
3
6898
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the Accpac 5.1 client program (I would like to find an OpenSource generic ODBC program for Wiindows that can do simple SQL). An Accpac database was installed and the Win32 ODBC connection is working. Trying to connect a Linux client via unixODBC I...
5
2773
by: Cichy | last post by:
Hello, I'm writing a Client-Server application using sockets (asynchronous). There is a Server (Master) which accepts incoming connections, and Client (Slave). Afetr establishing connections with all Slaves I wanna hit a button "Automatic", then everything must be reorganised, there is an ellection for a new Master. Everything is all right when I'm connecting manually (when I hit a button connect), but after hitting this button...
6
3678
by: sgulciny | last post by:
hi friends; I have problem about sql server insert and update in client side. I am coding windows application with c#.When I run my code in database server computer all is fine.I can see data, insert and update.But when I run same code in client side I can see data but not insert not update what can I do about this problem .I use sql server 2000 database.Client side connections ok. :( thanks for all
0
2401
by: brum2008 | last post by:
Hello! Below is the Netbeans Mobility source code for my application (The application offers SPP service, and then just hangs waiting for a client to connect (using acceptAndOpen()). The other device (A7 Engineering's eb506 Bluetooth serial adapter connected to a microcontroller) connects to the phone, but is not linked to my application). If I make the connection directly from the phone (Nokia 6085) to the eb506, there is no problem...
0
7946
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7876
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8003
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8234
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6654
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5408
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3859
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
1210
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.