db2 client traces

[michael.bierenfeld]

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

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

[Sathyaram Sannasi]

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.