Start of change

-START ML command (Db2)

The -START ML command starts the Db2 functions used by IBM Db2 AI for z/OS®.

Abbreviation: -STA ML

Environment for -START ML

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 for -START ML

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 for -START ML

Read syntax diagramSkip visual syntax diagram START ML ( * )(,SQLOPTSA_DCC)(SA)(,REFRESH_STATIC_SCOPEREFRESH_DYNAMIC_SCOPE)

Option descriptions for -START ML

*
Activates all Db2 functions used by IBM Db2 AI for z/OS. This is the default.
SQLOPT
Activates the SQL optimization function of IBM Db2 AI for z/OS.
SA_DCC
Activates data collection for both the system assessment and distributed connection control functions of IBM Db2 AI for z/OS.
Start of changeSAEnd of change
Start of changeActivates data collection for the system assessment function of IBM Db2 AI for z/OS. This option cannot be used along with other options to activate other functions of IBM Db2 AI for z/OS.End of change
Start of changeREFRESH_SQLOPT_STATIC_SCOPEEnd of change
Start of changeRefreshes the static package list that is used by Db2 to reflect changes made in static package selection for IBM Db2 AI for z/OS. This option can be specified only if the SQLOPT function of IBM Db2 AI for z/OS is already active.End of change
Start of changeREFRESH_SQLOPT_DYNAMIC_SCOPEEnd of change
Start of changeRefreshes the dynamic application list that is used by Db2 to reflect changes in dynamic application selection for IBM Db2 AI for z/OS. This option can be specified only if the SQLOPT function of IBM Db2 AI for z/OS is already active.End of change

Usage note for -START ML

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

Examples for -START ML

Example 1
Activate all Db2 functions used by IBM Db2 AI for z/OS in all members of the data sharing group.
-START ML
Example 2
Activate all Db2 functions used by IBM Db2 AI for z/OS in all members of the data sharing group.
-START ML (*)
Example 3
Activate the SQL optimization function of IBM Db2 AI for z/OS in all members of the data sharing group.
-START ML (SQLOPT)
End of change