HP MPE/iX 6.x Operating System manual Host Logging

Page 72

Troubleshooting

ODBCLink/SE Reference Manual

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.

	ODBCLink/SE
62	©M.B. Foster Associates Limited 1995-2000

Image 72

Contents ODBCLink/SETM Limitations on Warranties and Liability ODBCLink/SE offers the following features Additional features of DataExpress for Client-Server areSales@mbfoster.com If you require any of the following features Page Page Table of Contents Using ODBCLink/SE With Odbc Applications Appendix B Creating a DBEnvironment Page Overview and Specifications Connecting Link Odbc Compliancy LevelClient Environment Server EnvironmentMicrosoft Odbc Overview ODBCLink/SE System Requirements HP3000 Server RequirementsHP9000 Server Requirements Client RequirementsSQL Commands supported Field types supportedPage Verify Software Version Numbers Verify the Connection Assurance Parameters$sqlver ExitF1 Open Config Starting and Stopping the ListenerTo start the listener on the HP3000 data base server, enter To start the listener on the HP9000 database server, enterTo determine whether or not the listener job is running To stop the listener# ps -ef grep odbclnse Gather Information Create the DBEnvironmentUsing Reflection software Downloading ODBCLink/SE to the Client PCUsing Arpa Services FTP Using NS Services Dscopy on the HP3000\ODBCSEnn ftp Server binary Get odbcclnn odbcclnn.exe quit Running the Setup program Extracting the ODBCLink/SE fileSelect Next ODBCLink/SE Foster Associates Limited Page Page ODBCLink/SE Configuring Data Sources Scroll down to ODBCLink/SE-32 Driver ODBC3. Click Finish Usr/users/data/PartsDBE MPE/iX if it is an HP3000 HP-UX if it is an HP9000Setup for MPE/iX Setup for HP-UX Setup Options Select Translator Odbc Translator Successful CompletionMigrating HP Pcapi Data Sources Application Development Using Stored Procedures ?=call owner.procedue ?,?Performance Considerations Turning AutoCommit On/Off Supported Functions =ON default 0=OFF =All Rows default=No Timeout default Use Allbase TimeoutIsolation Levels Supported Data Types SqldecimalDate Sqldate Page Using ODBCLink/SE With Odbc Applications Updating DataUsing Cognos Impromptu Special Notes for Users of Impromptu Viewing the SQL generated by ImpromptuJoins Changing the display formatException tables Joined=T Creating Joins Using Calculated Columns Column3 = .column1 + .Column2Using Lotus 123 Release DN=@ODBC@ DL=@DLODBC@ DD=@All Odbc Sources@Using Microsoft Access ODBCLink/SE ODBCLink/SE Foster Associates Limited Using MS-Query ODBCLink/SE Foster Associates Limited Using Visual Basic 4.0 or higher Connect Using SQL API Connect Using Sqlapi in VBExample DSN=YOUR DSNUID=USERPWD=PASSWORD Connection ExamplesODBCLink/SE ODBCLink/SE Foster Associates Limited Connecting with DAO’s Open the Table and Enter the SQL QueryConnecting with RDO’s Connecting with ADO’s Troubleshooting Terminating an Odbc ConnectionUsing Microsoft Odbc Test 32-bit To run ODBCTE32.EXEVerifying Software Version Numbers Verifying the Client-Side ComponentsDeleting a Translation DLL ODBCLink/SE Reference Manual Troubleshooting Using the Host Testing Utility Odbcutse Tools on the Database ServerMonitoring ALLBASE/SQL Activity with Sqlmon Checking the Listener Log File on the HP3000SQL Update Execute immediate SQL commandExecute stored procedure Display tables and table structuresHost Logging Odbc Call Tracing using ODBCLink.LOG Odbc Call Tracing using Dr. DeeBee SpyTools on the Client PC To turn off logging Log is located in C\WINDOWS\DRDEEBEE.LOGModifying the System Registry and ODBC.INI Files Error Messages Generated by the ALLBASE/SQL command interpreterGenerated by the 32-bit client DLL Comes from the Winsock driverPrimary key name returned by SQLStatistics Reading or writing to ALLBASE/SQL LongVarBinary itemsMaximum number of statements Insert Into Table Values ..., Blob %$Using the Ansi Character Set ALLBASE/SQL and IMAGE/SQL Restrictions on the Odbc Gram- marUnsupported ALLBASE/SQL and IMAGE/SQL Statements Appendix a Implementation Notes ODBCLink/SE Reference Manual Appendix B Creating a DBEnvironment On the HP3000 Database ServerUp,down,left,right,top,bottom,printn,or end Isql= exit $ csh /usr/lib/allbase/hpsql/sqlsetup On the HP9000 Database ServerODBCLink/SE Appendix C List of Installed Files Bit Driver Client For Windows 95 and GreaterODBCLink/SE Install Disc Windows NT Description Bit Driver Client For Windows NT 4.0 and GreaterODBCLink/SE MPE/iX Host HP-UX 9.x HostHP-UX 10.x and 11.x Host Page MBF-Console Introduction How MBF-Console WorksRunning MBF-Console Setup File Menu OptionsSet Refresh Interval in seconds Configure DSNs... Console Data Sources Configuration Connect Menu OptionsPrint ExitConnections Windows Listener WindowConnections Window Server Window ⊗ Stop Logging View Menu Option Window Menu OptionHelp Menu Options Installing MBF-Console for MBF-UDALink This can be done using MS ExplorerODBCLink/SE ODBCLink/SE Foster Associates Limited Select Next ODBCLink/SE Foster Associates Limited When you have decided, press Next ODBCLink/SE Foster Associates Limited Select Finish to complete the Setup Installing MBF-Console for ODBCLink/SE Next ODBCLink/SE Foster Associates Limited 100 Foster Associates Limited ODBCLink/SE Foster Associates Limited 101 102 Foster Associates Limited Page Page Index Index ODBCLink/SE Reference Manual ODBCLink/SE Reference Manual Index Listener Log File HP9000 Using Process Status ps Command ODBCLink/SE Reference Manual Index