The optimizer is part of the database instance and ensures the fastest possible processing of database accesses. To do this, it accesses the statistics about the contents of database tables. See also: Optimizer
You update the statistics about the contents of the tables of the database instance using the XPU program.
You use the parameters for the XPU program as parameters.
You have the DBM operator authorization AccessSQL.
The database instance is in ONLINE operational state.
exec_xpu <xpu_params>
You receive the reply of the XPU program.
OK<NL>
<xpu_output>
In the event of errors, see Reply Format.