NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Z-12
Default Event Messages
Default Event Messages
If the =_SQL_CMP_EVENT_NO0 DEFINE does not exist, the SQL compiler issues a
message to $0 whenever an automatic recompilation occurs.
The event messages contain the following fields:
86 SQLCOMP type datetime file PID=pid E=err FS=fs-err
Compiler event messages displayed on the console have an EMS subsystem ID rather
than an SQL ID, because SQL compiler event messages are not EMS messages. The
compiler sends the messages to $0, where they are converted to EMS messages and
given an EMS subsystem ID.
Considerations—=_SQL_CMP_EVENT_NO0
•
=_SQL_CMP_EVENT_NO0 affects only event messages issued within the TACL
or SQLCI session in which the DEFINE is in effect.
You cannot globally disable the logging of such messages to $0 except to have each
TACL process on the node add the =_SQL_CMP_EVENT_NO0 DEFINE.
Examples—=_SQL_CMP_EVENT_NO0
•
The following TACL command directs the SQL compiler not to send event
messages regarding automatic recompilations from the TACL or SQLCI session to
$0:
32> ADD DEFINE =_SQL_CMP_EVENT_NO0, CLASS MAP, FILE NOFILE
=_SQL_CMP_NO_KS_MJOIN DEFINE
=_SQL_CMP_NO_KS_MJOIN is a system DEFINE that inhibits SQL from using the
key-sequenced merge join operation.
type PROG (indicating automatic recompilation of an entire program) or
STMT (indicating automatic of a single statement)
datetime the date and time of the compilation
file
the name of the program file
pid identifies the process that started the compiler (a process name, if any,
or a CPU and PIN)
err the SQL error that caused the automatic recompilation
fs-err the file-system error that caused the automatic recompilation
ADD DEFINE =_SQL_CMP_NO_KS_MJOIN, CLASS MAP, FILE name