ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-34
Tracing
Tracing
This subsection describes the use of the NonStop ODBC Server trace features.
The NonStop ODBC Server provides trace features that can be used to record the
following information:
•
All input requests received from the client by the NonStop ODBC Server
•
All output returned from the NonStop ODBC Server to the client
•
All SQL/MP statements generated by the NonStop ODBC Server
•
All error and informational messages generated by the NonStop ODBC Server
•
The statistics related to statement caching
•
The IPC messages between a NonStop ODBC Server and a Pathway server
You can write the log output to a NonStop SQL table, to a terminal, or both.
The Trace Log
The following is an example of a trace log for an ODBC session:
ID DEBUG_FLAG DEBUG_STRING
------ ---------- -------------------------------------------------------
16 LOGON SQLTEST_EAP11
16 TIME 1995-01-27 20:41:56
16 IN_STREAM 0C7E 0101 0037 0000 0100 4445 434C 4152 ...7....DECLAR
16 IN_STREAM 0C8C 4520 4331 4339 4520 4355 5253 4F52 E C1C9E CURSOR
16 IN_STREAM 0C9A 2046 4F52 2073 656C 6563 7420 2A20 FOR select *
16 IN_STREAM 0CA8 6672 6F6D 2073 7973 7479 7065 7300 from systypes
16 NSSQL -CORE-MODE-----------------------------------------------
16 NSSQL
16 NSSQL
16 NSSQL STATEMENT CACHING: ACTIVE
16 NSSQL
16 NSSQL THIS STATEMENT: CACHED
16 NSSQL
16 NSSQL SELECT ALL * FROM \TESS.$PUMA.EAP11.ZVUDT FOR STABLE
ACCESS
16 NSSQL
16 NSSQL ---------------------------------------------------------
16 OUT_STREAM 3114 0400 0056 0000 0600 A04B 0003 5549 ...V.....K..UI
16 OUT_STREAM 3122 4408 5553 4552 5459 5045 0856 4152 D.USERTYPE.VAR
16 OUT_STREAM 3130 4941 424C 450A 414C 4C4F 574E 554C IABLE.ALLOWNUL
16 OUT_STREAM 313E 4C53 0454 5950 4506 4C45 4E47 5448 LS.TYPE.LENGTH
16 OUT_STREAM 314C 0854 4445 4641 554C 5406 444F 4D41 .TDEFAULT.DOMA
16 OUT_STREAM 315A 494E 044E 414D 4508 5052 494E 5446 IN.NAME.PRINTF
16 OUT_STREAM 3168 4D54 MT
16 OUT_STREAM 3114 0400 0041 0000 0700 2A36 0000 0000 ...A....*6....
16 OUT_STREAM 3122 0034 0000 0000 3400 0000 0034 0000 .4....4....4..
16 OUT_STREAM 3130 0000 3400 0000 0034 0000 0000 3400 ..4....4....4.
16 OUT_STREAM 313E 0000 0034 0000 0000 3400 0000 00E7 ...4....4.....
16 OUT_STREAM 314C 1E00 0000 0000 EF01 0006 .........
16 OUT_STREAM 3114 0401 0011 0000 0800 FD00 0000 00FF ..............
16 OUT_STREAM 3122 FFFF FF00 ...
16 CACHE Number of Statements: 2
16 CACHE Number of Lookups: 3