Starting or stopping Db2ZAI on the target Db2
You must start Db2ZAI for each of the non-datasharing subsystems, and each datasharing group, where Db2ZAI is to be used.
About this task
When you start Db2ZAI using the user interface (as described below), machine learning will be started on the target Db2, along with the traces that collect IFCID 318 for SQL optimization and IFCIDs 365, 402, 411 or 412, and 417 for DCC.
Note: IFCID 417 requires Db2 13.
Whether IFCID 411 or 412 is started is determined by the client application or client user ID setting for DCC. The default is set to collect IFCID 412 for client user ID based filtering. For more information, see Switching between recording client user IDs and client application names.
If you start Db2ZAI manually or with a vendor tool, in addition to issuing the -START ML command, you must also issue the following two -START TRACE commands (in this example, IFCID 411 is used):
-START TRACE(STAT) DEST(SMF) CLASS(32) IFCID(365,402,411,417)-START TRACE(MON) DEST(SMF) CLASS(32) IFCID(318)Note: Starting IFCID 318 does not negatively affect system performance, nor does it cause an increase in writes to SMF data sets.
Note:
When Db2 13 FL506 is activated, the trace will go to DEST(ZAI) and SMF will not be generated for the DCC traces unless you start the trace to SMF. For example:
-START TRACE(STAT) DEST(ZAI) CLASS(32) IFCID(365,402,411,417)
This way, only the data that Db2ZAI needs is gathered.
Procedure
- Open a browser window and navigate to
https://<hostname>:<port>/, where<hostname>is your Db2ZAI address and<port>is the port you have assigned to Db2ZAI. - Sign in to IBM Db2 AI for z/OS®.
- From the set of available connections, locate the one to be started and click the View connection actions menu (︙) to display the available actions, and click Settings.
- On the Main tab, click the Start all button to start Db2ZAI. The SQL optimization and SA and DCC buttons show a status of Started to indicate that Db2ZAI has been started on the connection.
- To stop Db2ZAI, click the Stop all button. The SQL optimization and SA and DCC buttons show a status of Stopped to indicate that Db2ZAI has been stopped on the connection.