Hello Ken,
Check out the API Supplement PDF (apisupp.pdf)
Try this... haven't used it for a long time...I believe ODBC connections go via
uvserver. Last time I used was for uvcs though, I can't recall it actually
works for ODBC connections. You can also get your remote system to invoke a
stored procedure to your UV
Regards
David
Extracted out of the PDF:
Logging Client Connections
Beginning at UniVerse 10.0, a server-side debugging log is available for
tracking client connections.
The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on
Windows platforms, by default.
Complete the following steps to set up the debugging log:
1.Edit the serverdebug file in the UVHOME directory.
2.In the first column, enter uvcs, indicating that you want to log the
connection progress for both uvapi_server and uvapi_slave.
3.In the next column, enter an integer indicating the level of logging
information you want to maintain. The valid integers are:
0 - No debugging.
1 - Captures information about the startup connection only.
9 - Captures information about every call.
4.In the third column, enter the full path for the log file location. If this
value does not exist, the logs are written to /tmp/uvapiserver_###.log as the
default on UNIX systems, or C:\tmp\uvapiserver.log as the default on
Windows systems. is the uvapi_server process ID.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Tuesday, 20 July 2010 1:35 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Tracing ODBC requests
Hello List Members.
Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe
DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the
commands processed by the uvapi_slave process. I have tried capturing them via
the LOGIN paragraph to no avail. Any help would be appreciated. The manuals,
as is often the case, were unhelpful.
Regards,
Ken Ford
Software Engineer - Universe
Phone:
07 3013 8605
Fax:
07 3002 8400
Email:
ken.f...@firstmac.com.au
Web:
www.firstmac.com.au
** IMPORTANT MESSAGE *
This e-mail message is intended only for the addressee(s) and contains
information which may be
confidential.
If you are not the intended recipient please advise the sender by return email,
do not use or
disclose the contents, and delete the message and any attachments from your
system. Unless
specifically indicated, this email does not constitute formal advice or
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please
reply to this
e-mail by typing Unsubscribe in the subject line.
**
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users