solidDB Help : Configuring and administering : Troubleshooting : Tools for troubleshooting
  
Tools for troubleshooting
The following tools are available to help collect, format, or analyze diagnostic data.
ADMIN COMMAND commands
The following commands can be used for troubleshooting:
 
ADMIN COMMAND
Description
See
'userlist'
Displays a list of users currently logged in to the database. The output provides information about various database operations and settings for each user.
'report'
Produces a report that contains information about the server, users, and database operations. The report also includes the configuration file (solid.ini) settings and a list of the performance counters.
'perfmon'
Displays the solidDB performance counters (called perfmons or pmons) that provide information about various database operations and performance.
'status'
Displays statistics information about memory usage, process size, transaction count, cache count, user count, database operations.
'monitor'
Controls monitoring of user activity and SQL calls. The information is logged into the soltrace.out file. Monitoring can also be turned on with the -m command-line option at solidDB startup.
'trace'
Controls the solidDB trace facility.
'sqllist'
Displays a list of the longest running SQL statements among the currently running statements.
'backuplist'
Displays the status of the last local backup.
'proctrace'
Controls tracing in stored procedures and triggers.
EXPLAIN PLAN FOR
The EXPLAIN PLAN FOR SQL statement shows the execution plan that the SQL optimizer has selected for a given SQL statement, see EXPLAIN PLAN FOR.
ODBC Driver Manager trace facility (Windows)
The Windows ODBC Driver Manager has a trace facility that allows the sequence of function calls made by an ODBC application to be recorded into a log file, see Network trace facility.
Go up to
Troubleshooting