Solution : https://service.sap.com/sap/support/notes/1493587 (SAP Service marketplace login required)
Summary :
This SAP Note discusses the configuration of DB2 database log files on Linux, UNIX, and Windows platforms, specifically addressing the use of secondary log files (LOGSECOND>0) and infinite logging (LOGSECOND=-1). For secondary log files configuration, it emphasizes the performance impact during transactional COMMIT operations and space requirements. The recommended approach is increasing the LOGPRIMARY configuration to avoid these issues. Infinite logging, set by configuring LOGSECOND to -1, eliminates limitations on transaction size and count but requires careful management of archive log retrieval and retention policies to prevent database recovery failures.
Key words :
terms db2 db6 luw reason, secondary log files consumes time, logsecond database configuration parameter specifies, infinite logging secondary log files, sap standard parameter notes, existing online backup images, create secondary log files, needed secondary log files, infinite active log space, log file retention policy
Related Notes :
| 1329179 | DB6: DB2 9.7 Standard Parameter Settings |
| 1293475 | DB6: Transaction Log Full |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |
| 899322 | DB6: DB2 9.1 Standard Parameter Settings |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |