-
Customizing SQL/MF
User reports
-
A customer can easily write his own reports for the SQL/MF tables, by providing
a CMS file that contains the desired SQL SELECT.
User reports are automatically added to the report menu of the user interface.
-
-
Connect exit
-
A connect exit is a REXX program provided by the customer. If present, it
will be invoked during DB2 CONNECT. The exit can examine the connect parameters
and reject the connect, if needed.
-
-
User Attached Processes
-
A User Attached Process is a REXX program provided by the customer. If present,
the process is invoked by SQL/MF at various stages of real-time monitoring.
The user process has access to all data collected by the monitor. UAP's are
invoked:
-
-
by the Command Monitor with information for all running agents
-
at the System Monitor interval with system-wide performance data
-
when a DB2 checkpoint starts and ends, or when a checkpoint delay is detected
-
when exception logging occurs
-
when package statistics are stored
-
when the Governor decides to force an agent
-
-
SQL/MF API's
-
The SQL/MF application program interfaces allow an application program to
execute a DB2 operator command and to obtain information about running agents.