-DISPLAY ML command (Db2)

The Db2 command DISPLAY ML displays the current status of IBM Db2 AI for z/OS®.

Abbreviation: -DIS 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: Member

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

Output

Message DSNX611I indicates the beginning of the output of the command.

Syntax

Examples

Example: Displaying the current status of IBM Db2 AI for z/OS

The following command displays the current status of IBM Db2 AI for z/OS.

-DISPLAY ML

When IBM Db2 AI for z/OS has never been activated since the Db2 subsystem was started or restarted, the output is similar to the following.

-DB2ADIS ML                                                         
 DSNX611I  -DB2A DSNXODPM DISPLAY ML REPORT FOLLOWS: 820             
            STATUS                         = STOPPED                 
            SQL OPTIMIZATION               = STOPPED                 
            SYSTEM ASSESSMENT &                                      
            DISTRIBUTED CONNECTION CONTROL = STOPPED                 
            DISPLAY ML REPORT COMPLETE.                              
 DSN9022I  -DB2A DSNXODPM 'DISPLAY ML' NORMAL COMPLETION

When IBM Db2 AI for z/OS is inactive, the output is similar to the following.

-DB2ADIS ML                                                          
 DSNX611I  -DB2A DSNXODPM DISPLAY ML REPORT FOLLOWS: 840              
            STATUS                         = STARTED                  
              - ML Daemon                     : MLZD   > RUNNING      
              - Db2ZAI Table Cleanup          : MLTBCL > NOT RUNNING
            SQL OPTIMIZATION               = STARTED                  
              - Execution History Pushout     : MLQEHP > NOT RUNNING
              - AccessPath History Pushout    : MLQAHP > NOT RUNNING
              - HV/OFNR Simple Model Training : MLSIM  > NOT RUNNING
              - Package Automation            : MLPACK > NOT RUNNING
              - Performance Data Processing   : MLPERF > NOT RUNNING
              - Dynamic Sql Monitoring        : MLDSMN > NOT RUNNING
            SYSTEM ASSESSMENT &                                       
            DISTRIBUTED CONNECTION CONTROL = STARTED                  
              - ML Generating Metrics         : MLMETX > NOT RUNNING
            DISPLAY ML REPORT COMPLETE.                               
 DSN9022I  -DB2A DSNXODPM 'DISPLAY ML' NORMAL COMPLETION

Note: Even when IBM Db2 AI for z/OS is inactive, the state of the ML daemon will indicate that it is RUNNING. The ML daemon is one of the IBM Db2 AI for z/OS daemons that monitors the state of IBM Db2 AI for z/OS and this daemon is expected to be in RUNNING state regardless of the status of IBM Db2 AI for z/OS.

When IBM Db2 AI for z/OS is active, the output is similar to the following output.

                                                         
-DB2ADIS ML                                                          
 DSNX611I  -DB2A DSNXODPM DISPLAY ML REPORT FOLLOWS: 840              
            STATUS                         = STARTED                  
              - ML Daemon                     : MLZD   > RUNNING      
              - Db2ZAI Table Cleanup          : MLTBCL > RUNNING      
            SQL OPTIMIZATION               = STARTED                  
              - Execution History Pushout     : MLQEHP > RUNNING      
              - AccessPath History Pushout    : MLQAHP > RUNNING      
              - HV/OFNR Simple Model Training : MLSIM  > RUNNING      
              - Package Automation            : MLPACK > RUNNING           
              - Performance Data Processing   : MLPERF > RUNNING      
              - Dynamic Sql Monitoring        : MLDSMN > RUNNING      
            SYSTEM ASSESSMENT &                                       
            DISTRIBUTED CONNECTION CONTROL = STARTED                  
              - ML Generating Metrics         : MLMETX > RUNNING      
            DISPLAY ML REPORT COMPLETE.                               
 DSN9022I  -DB2A DSNXODPM 'DISPLAY ML' NORMAL COMPLETION