DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)
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.