Long runtime for CU50

[Former Member]

Hi there, is there anywhere we can update the statistic for table CABN? We encountered long runtime when execute transaction code CU50, which we found out the process keep accessing the CABN table which contains more than 10k characteristics record. Thanks

[christian_bartels]

If you are running on IBM i (i5/OS, OS/400), there is no need to update statistics for a database table, because that is done automatically by the database.

If you have a slow transaction, you can analyze it through transaction ST05 and then use the Explain function on the longest running statement. Within the Explain, there is a function "Index advised", that might help in your case.

Kind regards,

Christian Bartels.

[Former Member]

you can use report RSANAORA

Give table name -> Compute Statistics

Or, we can utilize DB02 too, following path or you might have to research a little

DB02 -> Goto -> Check -> Table Statistics -> Sizes/Statistics