By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

db2 client traces

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.