patternMinor
DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)
Viewed 0 times
filemaximumwhatlogsqlrechesvaluedb2itswhen
Problem
we have DB2 in archive mode.
archive log files are created and deleted from the disk.
What will happen when archive log file reaches its maximum value for the name (S9999999.LOG) will it start to count from the beginning (S0000001.LOG)?
archive log files are created and deleted from the disk.
What will happen when archive log file reaches its maximum value for the name (S9999999.LOG) will it start to count from the beginning (S0000001.LOG)?
Solution
According to the link that @mustaccio put in the comments:
The database manager resets to S0000000.LOG if:
recovery
rollforward recovery
The database manager resets to S0000000.LOG if:
- A database configuration file is changed to enable rollforward
recovery
- A database configuration file is changed to disable
rollforward recovery
- S9999999.LOG has been used.
Context
StackExchange Database Administrators Q#97094, answer score: 3
Revisions (0)
No revisions yet.