CLI Reference Guide

Troubleshooting ODBCLink/SE Reference Manual
ODBCLink/SE
62 ©M.B. Foster Associates Limited 1995-2000
Host Logging
Normally, only connections and errors are logged to the ODBCLOG file on the host. If you check the box labelled
“Trace SQL calls on the server” in the data-source setup dialogue, all the SQL sent from the host and the ALLBASE
operation will be logged as well.
If a listener error occurs, an error message is logged in the ODBCLOG file.
Here is the format of the ODBCLOG file (this file can be found in group and account of the listener job, typically
ODBCLOG.ODBCSE.SYS on MPE systems and /tmp on Unix systems).
00/1000/10/20 14:12:09 068ODBC listener started
00/10/20 14:13:13 068 Listener created new connection as SYS1 (PIN 77), IP=192.9.3.102
00/10/20 14:13:13 077 ODBCLNSE E.52.00 started from sockets
00/10/20 14:13:22 077 Allbase Prepare[49]SELECT NAME, OWNER, TYPE, NPAGES, NROWS FROM
CATALOG.TABLE;
00/10/20 14:13:26 077 Allbase SetParams[49]
00/10/20 14:13:27 077 Allbase Fetch[49] Rows=119 MaxRows=200
00/10/20 14:13:27 077 Allbase Fetch[49] Rows=0 MaxRows=200
00/10/20 14:13:27 077 Allbase Close cursor[49]
00/10/20 14:13:27 077 Allbase Commit
00/10/20 14:13:27 077 Allbase Prepare[49]SELECT NAME,OWNER,NUMP,NUMR,MULTIRESULT FROM
CATALOG.PROCEDURE;
00/10/20 14:13:27 077 Allbase SetParams[49]
00/10/20 14:13:28 077 Allbase Fetch[49] Rows=6 MaxRows=200
00/10/20 14:13:28 077 Allbase Fetch[49] Rows=0 MaxRows=200
00/10/20 14:13:28 077 Allbase Close cursor[49]
00/10/20 14:13:28 077 Allbase Commit
00/10/20 14:13:28 077 Connected to partsdbe, ClientVersion=E.52.00
00/10/20 14:13:35 077 Prepare[0]SELECT _TABLES
00/10/20 14:13:35 077 SetParams[0] nparam=0
00/10/20 14:13:53 077 FreeStmt[0]
00/10/20 14:13:54 077 Normal exit, Received 3 requests (133 bytes), Sent 0 records (5141 bytes), CPU=2
(5.6%)
The first three columns of the list are the date, time, and pin (process id number) of the requesting connection. The
last column is the Allbase operation being performed, with the statement or cursor number in square brackets. The
number is square brackets (as in Allbase prepare[49]) is the statement number.