CLI Reference Guide

Troubleshooting ODBCLink/SE Reference Manual
ODBCLink/SE
60 ©M.B. Foster Associates Limited 1995-2000
Tools on the Database Server
Monitoring Activity with HP GlancePlus/XL (HP3000)
Program.
HP GlancePlus/XL allows you to monitor a job, session, or process on MPE/iX. The GlancePlus screens display
statistics on how different system resources are used. For information, refer to the HP GlancePlus/XL User's Manual.
Monitoring Activity with HP GlancePlus/UX (HP9000)
Program
.
HP GlancePlus/UX allows you to monitor a login or process on HP-UX. The GlancePlus screens display statistics on
how different system resources are used. For information, refer to the HP GlancePlus/UX User's Manual.
Displaying Active Processes with HP-UX Process
Status (ps) Command
.
You can use the HP-UX ps command to display the status of your active processes. For information, refer to the HP-
UX man page.
Monitoring ALLBASE/SQL Activity with SQLMON.
SQLMON is a component of ALLBASE/SQL and monitors the activity of an ALLBASE/SQL DBEnvironment.
SQLMON summarizes the activity for the entire DBEnvironment, or focuses on individual sessions, programs, or
database components. For information, refer to the ALLBASE/SQL Performance and Monitoring Guidelines.
Checking the Listener Log File on the HP3000
Look for ODBCLOG where the listener is running.
Checking the Listener Log File on the HP9000
Look for odbclog in the /tmp/ directory.
Using the Host Testing Utility ODBCUTSE
If you are having problems connecting or accessing a table on the host, you can access it directly on the host in the
same way the ODBC server accesses it, by running the ODBCUTSE utility.
To run the program on MPE/iX, enter:
ODBCUTSE.ODBCSE.SYS “dbe name”
To run the program on HP/UX, enter:
/usr/bin/odbcse/odbcutse “dbe name” (for HP-UX V9.x systems)
or
/opt/allbase/bin/odbcutse “dbe name” (for HP-UX V10.x and V11.x systems)