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)?


1 Answer 1


According to the link that @mustaccio put in the comments:

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.