db2 client traces

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • michael.bierenfeld@web.de
    #1

    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 =
    Verzeichniseint ragungsart = LOCAL
    Protokoll = TCPIP
    Host-Name = smars
    Servicename = 50000

    moms@juno:/moms >db2 list db directory

    Systemdatenbank verzeichnis

    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 =
    Verzeichniseint ragungsart = Fern
    Datenbankpartit ionsnummer für Katalog = -1
    Hostname des Alternativserve rs =
    Portnummer des Alternativserve rs =

    Kind regards

    Michael

    Tags: None
    • Ian
      #2
      Re: db2 client traces

      michael.bierenf eld@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.


        Comment

        • Sathyaram Sannasi
          #3
          Re: db2 client traces

          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\sqlli b (Windows) or sqllib/cfg
          (Unix)

          Sathyaram


          Ian wrote:
          michael.bierenf eld@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.

            Comment

            Previous template Next
            Working...