470,638 Members | 1,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

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 2433
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Derek Fountain | last post: by
reply views Thread by Pav Lucistnik | last post: by
1 post views Thread by Bob Palank | last post: by
3 posts views Thread by Valeriu Filip | last post: by
1 post views Thread by geoff | last post: by
11 posts views Thread by Adam Sandler | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.