-DISPLAY ML command (Db2)

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

Abbreviation: -DIS ML

Environment for -DISPLAY 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: Member

Authorization for -DISPLAY ML

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:

DISPLAY privilege
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 for -DISPLAY ML

Output for -DISPLAY ML

The DSNX611I message indicates the beginning of the output of the command.

The output from the command is similar to the following example.

DSNX611I  -DB2A csect-name DISPLAY ML REPORT FOLLOWS:              
            STATUS                         = ml-status                  
              - ML Daemon                     : MLZD   > status      
              - Db2ZAI Table Cleanup          : MLTBCL > status
            SQL OPTIMIZATION               = action-state                  
              - Execution History Pushout     : MLQEHP > status
              - AccessPath History Pushout    : MLQAHP > status
              - HV/OFNR Simple Model Training : MLSIM  > status
              - Package Automation            : MLPACK > status
              - Performance Data Processing   : MLPERF > status
              - Dynamic Sql Monitoring        : MLDSMN > status
            SYSTEM ASSESSMENT &                                       
            DISTRIBUTED CONNECTION CONTROL = STARTED                  
              - ML Generating Metrics         : MLMETX > status
            DISPLAY ML REPORT COMPLETE.

The output might contain any of the following sections about the ML status:

csect-name

The name of the control section that issued the message.

STATUS=ml-status

The ML status. Expected status values are:

STARTED: ML is active.
STOPPED: ML is inactive.

ML daemon

The ML daemon status. Expected status values are:

RUNNING: The ML daemon is active.
NOT RUNNING: The ML daemon is inactive.

Db2ZAI Table Cleanup

The Db2ZAI table cleanup status. Expected status values are:

RUNNING: The Db2ZAI table cleanup is active.
NOT RUNNING: The Db2ZAI table cleanup is inactive.

SQL OPTIMIZATION

The SQL optimization status. Expected status values are:

STARTED: SQL optimization is active.
STOPPED: SQL optimization is inactive.

Execution history pushout

The execution history push out status. Expected values status are:

RUNNING: The execution history push out is active.
NOT RUNNING: The execution history push out is inactive.

AccessPath History Pushout

The access path history push out status. Expected values status are:

RUNNING: The access path history push out is active.
NOT RUNNING: The access path history push out is inactive.

HV/OFNR Simple Model Training

The HV/OFNR simple model training status. Expected status values are:

RUNNING: The HV/OFNR simple model training is active.
NOT RUNNING: The HV/OFNR simple model training is inactive.

Package Automation

The package automation status. Expected status values are:

RUNNING: The package automation is active.
NOT RUNNING: The package automation is inactive.

Dynamic Sql Monitoring

The dynamic SQL monitoring status. Expected status values are:

RUNNING: The dynamic SQL monitoring is active.
NOT RUNNING: The dynamic SQL monitoring is inactive.

SYSTEM ASSESSMENT & DISTRIBUTED CONNECTION CONTROL

The system assessment and distributed connection control status. Expected status values are:

RUNNING: The system assessment and distributed connection control functions are active.
NOT RUNNING: The system assessment and distributed connection control functions are inactive.

Performance data processing

The performance data processing status. Expected status values are:

RUNNING: The performance data processing status is active.
NOT RUNNING: The performance data processing status is inactive.

ML Generating metrics

The ML generating metrics status. Expected status values are:

RUNNING: The ML generating metrics status is active.
NOT RUNNING: The ML generating metrics status is inactive.

Examples for -DISPLAY ML

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