-STOP ML (Db2)

The Db2 command STOP ML 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 change A logged-on z/OS user ID must be defined in RACF or a similar security server. End of change

Syntax

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)