Solution : https://service.sap.com/sap/support/notes/869267 (SAP Service marketplace login required)
Summary :
This SAP Note addresses common queries related to the configuration and management of the log area in SAP MaxDB databases. It encompasses various aspects such as log segment arrangements, RAID usage for logs, and the procedures involved in mirroring log areas using database tools. Key considerations include ensuring rapid disk I/O for logs, avoiding placement of logs, data, and swap on the same disk to prevent I/O bottlenecks, and the implications of using RAID for logs. The note also explores situations like log full conditions, the process of managing log volumes during different database operation statuses, and the significance of certain database parameters like LocalRedoLogBufferSize. Users of MaxDB version 7.5 or higher, particularly in OLTP, BW, or SAP liveCache environments, will find this information pertinent.
Key words :
log = 1log volume enabled = 1log auto overwrite = 0master servernode =converter version = 57oldest compatible version = 7, <password> db_restartinfookused log page 7451first log page 2527restartable 1id restart record berd00144137a, restart version okfirst io sequence needed = 7451first io sequence, sap maxdb internals workshop wb550, database system writes undo log entries, database system writes redo log entries, choosing configuration -> log settings -> log mode, util_execute set log auto overwrite, choose instance -> configuration -> log settings, database parameter autologbackupsize/log_segment_size belongs
Related Notes :
| 1830959 | SAP MaxDB/liveCache: Housekeeping |
| 1718653 | Datenbankabsturz beim Log-Recovery |
| 1423935 | FAQ: SAP MaxDB Database Analyzer |
| 1377148 | FAQ: SAP MaxDB backup/recovery |
| 1177052 | Mirrored log: Recovery of deficient log volume |
| 1173395 | FAQ: MaxDB configuration |
| 1167342 | MaxDB parameter LOG_QUEUE_COUNT as of version 7.6 |
| 993848 | Direct I/O mount options for liveCache/MaxDB |
| 936058 | FAQ: SAP MaxDB Runtime Environment |
| 846890 | FAQ: SAP MaxDB Administration |
| 820824 | FAQ: SAP MaxDB/liveCache technology |
| 817887 | High collision rate in LOGQUEUE region |
| 534036 | SAP LT: System settings for conversions |