-STOP ML command (Db2)

The -STOP ML command stops the Db2 functions used by IBM Db2 AI for z/OS®, if IBM Db2 AI for z/OS has already been started.

Abbreviation: -STO ML

Environment

This command can be issued from a z/OS console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).

Data sharing scope: Group

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following authorities:
  • SQLADM authority
  • System DBADM authority
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. Start of changeA logged-on z/OS user ID must be defined in RACF or a similar security server.End of change

Syntax

Read syntax diagramSkip visual syntax diagram STOP ML ( * )(,SQLOPTSA_DCC)

Option descriptions

*
Deactivates all Db2 functions used by IBM Db2 AI for z/OS functions. This is the default.
SQLOPT
Deactivates the SQL optimization function of IBM Db2 AI for z/OS.
SA_DCC
Deactivates data collection for both the system assessment and distributed connection control functions of IBM Db2 AI for z/OS.

Usage note

The STOP ML command deactivates IBM Db2 AI for z/OS. In a data sharing environment, this command disables IBM Db2 AI for z/OS on all members in the data sharing group.

Examples

Example 1
Deactivate all Db2 functions used by IBM Db2 AI for z/OS in all members of the data sharing group.
-STOP ML (*)
Example 2
Deactivate the system assessment and distributed connection control functions in all members of the data sharing group.
-STOP ML (SA_DCC)
Example 3
Deactivate the SQL optimization, system assessment, and distributed connection control functions in all members of the data sharing group. 
-STOP ML (SQLOPT, SA_DCC)