System and catalog stored procedures
972
disable_connections When set to ON, no other connections are allowed
to any databases on the database server.
liveness_timeout A liveness packet is sent periodically across a
client/server TCP/IP or SPX communications protocol to confirm that a
connection is intact. If the network server runs for a liveness_timeout period
(default 120 seconds) without detecting a liveness packet, the
communication is severed.
$ For more information, see "–tl command-line option" on page 35.
quitting_time Instruct the database server to shut down at the specified
time.
$ For more information, see "–tq time command-line option" on page 36.
request-level_log_file The name of the file used to record logging
information. A name of NULL stops logging to file.
Any backslash characters in the filename must be doubled, as this is a SQL
string.
$ For more information, see "–z command-line option" on page 40, and
"–o command-line option" on page 32.
request_level_logging Can be ALL, SQL, or NONE. ON is a synonym
for ALL and OFF is a synonym for NONE. NONE is the default. This call
turns on logging of individual SQL statements sent to the database server, for
use in troubleshooting, in conjunction with the database server
-z and -o
command-line options. You can use request_level_debugging as a synonym
for request_level_logging.
If you select SQL, the following types of request only are recorded:
♦ START DATABASE
♦ STOP ENGINE
♦ STOP DATABASE
♦ Statement preparation
♦ Statement execution
♦ EXECUTE IMMEDIATE statements
♦ Option settings
♦ COMMIT statements
♦ ROLLBACK statements
♦ PREPARE TO COMMIT operations.
To Next Page
Loading...