Solution : https://service.sap.com/sap/support/notes/1308217 (SAP Service marketplace login required)
Summary :
This SAP Note advises on setting database parameters for SAP MaxDB Version 7.8 applicable to different system types including OLTP, CRM, BW, and OneDB systems. Key parameter adjustments include EnableCommandMonitor, EnableLegacyOuterJoinSyntax, and settings for optimal performance in parallel join processing and hash-joins. Recommendations for parameter settings are provided to prevent errors and enhance system performance. Users must utilize Database Analyzer, Database Studio, or DBA Cockpit for making changes and it’s urged to update to the latest MaxDB version for permanent fixes beyond these parameter adjustments.
Key words :
contact sap maxdb/livecache development support, error -9045 'bd root check' occurs, error ak duplicate catalog information, dbmcli> param_put -running -permanent sharedsql <, sap maxdb/livecache versions lower, configured data volumes determines, update statistics estimated values, recent sap maxdb versions, sap maxdb version lower, database analyzer configuration file
Related Notes :
| 1497862 | FAQ: SAP MaxDB Shared SQL |
| 1353266 | Additional information about MaxDB version upgrade to 7.8 |
| 1305500 | System error when processing joins |
| 1139904 | FAQ: MaxDB/liveCache kernel parameters |
| 1112049 | Database crash when setting the parameter JOIN_MAXTAB_LEVEL9 |
| 1111426 | Parameter check for liveCache/MaxDB instances |
| 993848 | Direct I/O mount options for liveCache/MaxDB |
| 927882 | FAQ: SAP MaxDB Update Statistics |
| 808060 | Changing the estimated values for Update Statistics |
| 65946 | Lock escalations |