473,395 Members | 1,761 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

db2 client traces

Hello there,

how can I switch on client tracing with a c-programm connection from a
aix machine to a db2 running on another aix machine. The software works
fine but from time to time we loose the db2 connection to the db with
the follwing error message "sql30081n communications failure".

It seems to be a tcp/ip or lowlevel networking stuff. I know that
oracle has a environment variable that lets the lowlevel db-driver
trace to a specific file.

is that possible with the native db2 driver too.

The database is specified as :

moms@juno:/moms >db2 list node directory

Eintrag für Knoten 1:

Knotenname = MARS00
Kommentar =
Verzeichniseintragungsart = LOCAL
Protokoll = TCPIP
Host-Name = smars
Servicename = 50000

moms@juno:/moms >db2 list db directory

Systemdatenbankverzeichnis

Anzahl Einträge im Verzeichnis = 1

Eintrag für Datenbank 1:

Aliasname der Datenbank = MOMSPROD
Datenbankname = MOMSPROD
Knotenname = MARS00
Release-Stand der Datenbank = a.00
Kommentar =
Verzeichniseintragungsart = Fern
Datenbankpartitionsnummer für Katalog = -1
Hostname des Alternativservers =
Portnummer des Alternativservers =

Kind regards

Michael

Oct 10 '06 #1
2 2529
Ian
mi****************@web.de wrote:
Hello there,

how can I switch on client tracing with a c-programm connection from a
aix machine to a db2 running on another aix machine. The software works
fine but from time to time we loose the db2 connection to the db with
the follwing error message "sql30081n communications failure".

It seems to be a tcp/ip or lowlevel networking stuff. I know that
oracle has a environment variable that lets the lowlevel db-driver
trace to a specific file.

is that possible with the native db2 driver too.
Search for "Enabling CLI traces" in the documentation.
Oct 10 '06 #2
Add the following lines to db2cli.ini file ..

[COMMON]
trace=1
tracefilename=c:\tempcli.trc
traceflush=1

The file is in C:\Program Files\IBM\sqllib (Windows) or sqllib/cfg
(Unix)

Sathyaram
Ian wrote:
mi****************@web.de wrote:
Hello there,

how can I switch on client tracing with a c-programm connection from a
aix machine to a db2 running on another aix machine. The software works
fine but from time to time we loose the db2 connection to the db with
the follwing error message "sql30081n communications failure".

It seems to be a tcp/ip or lowlevel networking stuff. I know that
oracle has a environment variable that lets the lowlevel db-driver
trace to a specific file.

is that possible with the native db2 driver too.

Search for "Enabling CLI traces" in the documentation.
Oct 10 '06 #3

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

Similar topics

8
by: Derek Fountain | last post by:
Does Python have something similar to Tcl style tracing? That is, the ability to call a subroutine when a variable is written to or read from?
0
by: Pav Lucistnik | last post by:
Hi folks, we're seeing strange behaviour of mysql connections over network here lately. Server and client are on different machines. Server (corpdb) is Mysql 3.23.52 on FreeBSD 4.6.2-RELEASE,...
4
by: Prince Kumar | last post by:
I joined a company recently and they have a java program which hangs (does nothing) after a while. This is no way consistent. It could succeed quite a few times and can fail a few other times....
4
by: Vinay | last post by:
Hi I want to listen to traces exhibited by other applications. Can some one help me and let me know how to do it? Can TextWriterTraceListener class be used from outside application to listen to...
0
by: Frank | last post by:
First, I borrowed the below stack trace from another posting as an example of the sort of issue I have with my own software. When I see stack traces like this from my own software, I do not...
1
by: Bob Palank | last post by:
My objective was to remove all traces of Form1 from my source which was a vcpp.Net Windows application. And I was successful - but in doing so, I lost the ability to graphically modify my form!...
3
by: Valeriu Filip | last post by:
Hello, I have a java web service, and created a wsdl file from the java class; based on the resulting wsdl file i generated the proxy C# class using wsdl.exe utility and the result i included in...
1
by: geoff | last post by:
Hi All, I am accessing db2 for zOS from a windows xp client and trying to find out how many times a select or update sql statement is executed. I am able to do this easily in db2 for windoze...
11
by: Adam Sandler | last post by:
Hello, Having an issue with JavaScript in my ASP.Net page. I use some COTS, which for all intents and purposes, simply makes a jpeg file and physically places it in a directory on the web...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
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...
0
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...

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.