Symptom
Scheduling a backup fails as the backup is unable to retrieve the first active log data.
The output of db2 get db cfg for <SID> show detail displays the parameter
First active log file = ( is empty)
Example:
Log file size (4KB) (LOGFILSIZ) = 128000 128000
Number of primary log files (LOGPRIMARY) = 100 100
Number of secondary log files (LOGSECOND) = 20 20
Changed path to log files (NEWLOGPATH) =
Path to log files = /db2/<SID>/log_dir/NODE0000/LOGSTREAM0000/ /db2/<SID>/log_dir/NODE0000/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path MIRRORLOGPATH) =
==>>
First active log file =
Read more...
Environment
Db2 LUW IBM
Keywords
normal, LSN, archived, logging, apps, application, log path, log space, current, secondary, space, log chain ID. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview