IBM
Db2 AI for
z/OS (Db2ZAI) leverages machine learning technology to
empower the Db2 for z/OS optimizer to determine the
best-performing query access paths, based on your workload characteristics.
Procedure
To activate Db2ZAI:
-
On the DB2 Administration Menu (ADB2)
panel, specify option
Z, and press Enter.
-
On the System Administration (ADB2Z)
panel, specify option
2M, and press Enter.
-
On the Display/Manage Machine Learning
(ADB2Z2M) panel, specify option
2, and press Enter.
ADB2Z2M n DC1A Display/Manage Machine Learning 14:30
Option ===>
1 - Display ML
2 - Start ML
3 - Stop ML
Note: the Db2 commands will be issued immediately
The Db2 command STA ML is issued
immediately unless you have the preference set to be prompted before executing Db2 commands. In this case, the Statement Execution Prompt
(ADB2PSTM) panel is displayed and you can specify
1 to execute the command.
The STA ML command activates Db2ZAI on
the subsystem or, in a data sharing environment, all members in the data sharing group.
- Optional:
To confirm that Db2ZAI is activated,
exit back to the Display/Manage Machine Learning
(ADB2Z2M) panel, specify option
1, and press Enter.
The Db2 command DISPLAY ML is issued,
and the output from the command is displayed to indicate that Db2ZAI is active:
ADB2DB2O ------- DC1A Browse DB2 Command Output --- Line 00000000 Col 001 080
-DIS ML
********************************* Top of Data **********************************
DSNX611I !DC1A DSNXODPM DISPLAY ML REPORT FOLLOWS:
STATUS = STARTED
- ML Daemon > RUNNING
- Heartbeat monitoring > RUNNING*
- Execution History Pushout > RUNNING
- AccessPath History Pushout > RUNNING
- HV Model Training > RUNNING
- OFNR Model Training > RUNNING
- Model Statistics Pushout > RUNNING
- Performance Data Processing > RUNNING
- Cleanup Processing > RUNNING
- Regression Retraining > RUNNING*
- Training Status Processing > RUNNING
- ML Statistics Processing > RUNNING
- ML Scheduler > RUNNING
What to do next
If you later want to stop Db2ZAI,
return to the Display/Manage Machine Learning
(ADB2Z2M) panel and specify option
3 to issue the Db2
command STOP ML.
