Using the Debugging Facility

SQL Output

A debugging facility is available from the tsmysql process. Execute this program with the following syntax to activate the debugger.

tsmysql -dn

n

Currently the only debug level is 1. This sends the generated SQL statements to the log file (/usr/lib/basic/tsmysql.debug). The output in the log file contains a separate line for each generated SQL statement prefixed by the child tsmysql process id.

While tsmysql

is active, output for all clients (located on the same server) is sent to one tsmysql.debug

file.

If the tsmysql.debug file is copied, output will continue to be placed in the renamed file until the parent tsmysql process is terminated. A subsequent Basic session would then use a new tsmysql.debug.

Process Identification

A method is available to associate the child process tsmysql process with the client process. Execute this program with the following syntax to enable this feature.

tsmysql -s

By including the –s argument on the tsmysql command, each time the client logs into the server, information is sent to the tsmysql.pid file. This file is located in /usr/lib/basic. The format of the information is as follows;

Line 1

parent tsmysql process

Line 2 – n [child tsmysql process] [client host name] [client basic process]

From the TS DataServer for MySQL Reference, version 8.9.1. Open this page in the PDF