Zugriff auf DB2 - DB2 Database

Joerg Windeler

Hallo,

ich benutzen den Runtime-Client von IBM um auf eine DB2-Datenbank per ODBC
zuzugreifen. Die Verbindung mit der Datenbank dauert jedesmal ca. 30
Sekunden. WeiÃŸ jemand, woran dies liegen kann, bzw. ob es bessere
MÃ¶glichkeiten der Anbindung gibt?

--
GruÃŸ von
JÃ¶rg Windeler

Nov 12 '05 #1

Subscribe Reply

1941

Serge Rielau

Joerg Windeler wrote:

Hallo,

ich benutzen den Runtime-Client von IBM um auf eine DB2-Datenbank per ODBC
zuzugreifen. Die Verbindung mit der Datenbank dauert jedesmal ca. 30
Sekunden. WeiÃŸ jemand, woran dies liegen kann, bzw. ob es bessere
MÃ¶glichkeiten der Anbindung gibt?

Wo finded die Autentifizierung statt? Oft lassen sich Connect-
performance Probleme auf diese zurueckfuehren.
Eine weitere moeglichkeit ist, dass DB2 nach dem abwickeln der lezten
Verbindung alle Prozesse freigibt. Die erste neue Verbindung muss diese
dann neu erzeugen.
Ich glaube der NUM_INITAGENTS DBM CFG Parameter stellt dies ein:
http://publib.boulder.ibm.com/infoce...4e%54%53%22%20

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #2

Similar topics

Python deutsch

by: Werner.Warweg | last post by:

Das Musikprogramm Capella nutzt Python. Ich habe mir die Sprache mal angesehen und möchte mich damit näher beschäftigen. Ich muß beruflich XP verwenden. Kann mir einer der deutsprachigen...

Python

odbc 3.51, Visual Studio 2003, odbc DataAdapter

by: Gregor Valentin | last post by:

Hi! one Question. Is here anybody who had success in accessing a mySQL database via the ODBCDataAdapter in the Visual Studio design view? I get always Errors after creating the select...

MySQL Database

Restore database via automated order

by: FoxRunner | last post by:

Hi folks, I got a script which restores a database. It works fine if it is running in my Query Analyzer. It fails when I put this script in an automated schedule using the SQL agent. This...

Microsoft SQL Server

kill a process with insufficient user permissions

by: Markus Poehler | last post by:

Hi my program should run on terminal server. I open Acrobat process and I have to kill them at some points in my application. This fails cause of insufficient rights on terminal server. the...

.NET Framework

Datatypfloat shows in datagrid 5 on instead of 5.00?

by: Michael Schindler | last post by:

I use C# windows Appl. My problem i have is whit my column amount. In the database i have float as datatyp an my datagris shows the amount place without decimal. I know dgTextBoxColumn.Format...

C# / C Sharp

datagrid NullText = ""; can not save in a database.

by: Michael Schindler | last post by:

I can see my values date and values "S" in the datagrid but if i want save i get the error the cells are null..but i can see. If i chanche the date from 03.03.2003 to manuell 03.03.2003 and...

C# / C Sharp

Zugriff auf Checkbox in Vorlagen-Header

by: JoDu | last post by:

Hallo NG, ich habe lt. meinem Verständnis einen einfachen Sachverhalt, komme aber einfach nicht auf die Lösung. Hoffe, jemand kann mir helfen. Ich habe ein DataGrid (WebForms) mit einer...

C# / C Sharp

OE Address Book interface not too friendly with exporting - Seeking A97 solution to read it

by: MLH | last post by:

Anyone ever experiement importing WAB data directly into A97? Would lke a chance to look at any work done in this arena.

Microsoft Access / VBA

problem with IE and (ajax) file upload via iframe: javascript error access denied/zugriff verweigert

by: markus.rietzler | last post by:

i want to do (multiple) file upload(s) and display a progress bar. with firefox and safari it is no problem at all. only IE makes some problems. my script is based on ajax-uploader, which can be...

Javascript

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP