Solution : https://service.sap.com/sap/support/notes/12184 (Connexion à SAP Service Marketplace requise)
Résumé :
In SAP systems, database performance issues often arise from outdated statistics used by the optimizer to select access paths. Key statistics include the number of data records, index sizes, and data distribution. Regularly updating these statistics is crucial, ideally weekly. For newer releases (from 3.0A), use tools like 'sapdba' accessible via DB13 to schedule updates automatically. Prior releases, such as 2.1H or 2.2B, require manual execution with 'infupdstat'. Verify successful updates through transaction ST04. Ensure configurations are optimal to avoid additional performance problems, and check SAP Note 184760 for solutions if issues arise.
Mots Clés :
menu function 'goto -> check -> table statistics -> sizes / statistics', 'goto -> activity -> current statistics -> table activity', short log entry including statistic, $informixdir/sapreorg/updstat_<sid>, additional key words db13, 'edit -> update statistics -> display, optimizer requires current information, action 'update optimizer statistics, weekly 'update statistics' run, update statistics optimizer
Notes associées :
| 536900 | Activating ODS: Error in creating SID - RSM1 187 |
| 332490 | Restrict selection report RMCUINOBTOIBASEMARA III |
| 328509 | Restrict selection report RMCUINOBTOIBASEMARA II |
| 316212 | Restricting selection report RMCUINOBTOIBASEMARA I |
| 301305 | Restrict selection criteria RMCUINOBTOIBASEMARA |
| 192423 | Delivery Processing Performance: Consulting |
| 184760 | Update Statistics: SAPDBA Rel.>=4.6A old strategy |
| 173993 | Cluster: System settings during Euro LC changeover |
| 143956 | Update Statistics: SAPDBA Release 4.5x new strategy |
| 66322 | CCMS: Database administration (transaction DB13) |
| 29873 | Informix: Performance analysis of SELECT Statements |