HP MPE/iX 6.x Operating System manual Tools on the Database Server

Troubleshooting ODBCLink/SE Reference Manual

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)

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