SAP Note 27099 - Update statistics in transaction DB02

Symptom:

In TA DB02 (database performance: tables and indexes), it is possible
to schedule an Update Statistics. No separate background job is defined;
only a new 'partial job' is defined for the performance collector.

Cause and prerequisites

An Update Statistics can be scheduled via the TA DB02 -> Goto -> Check -> Table Statistics -> Sizes/Statistics. This Update Statistics is started by the performance collector (background job SAP_COLLECTOR_FOR_PERFMONITOR with Report RSCOLL00), which should run in the system hourly (see Note 16083).
The time of the last Update Statistics is displayed in Last success. execution.
You can display the log of the collector with the TA ST03 -> Environment -> Data Collector -> Display protocol.
This log contains report RSEFA350, which started the Update Statistics (at the time also specified in the DB02).

Solution
This is not an error, but within the framework of CCMS it is possible
to define a separate background job for the Update Statistics under
Informix. Using TA DB13 (DB administration in the SAP environment),
you can schedule an Update Statistics for a certain table or for all
tables. This job can be found in the job overview (TA SM37).
(NAme for example DBA:UPDATE_STA0______014:00/1000)

Additional key words

DB02, infupdstat, update statistics, rscoll00, rsefa390, rsefa350
SAP_COLLECTOR_FOR_PERFMONITOR