I updated the DB2 parameters in LOGARCHMETH1 to OFF. It worked fine after bouncing the database.

When I tried to turn on again the LOGARCHMETH1 and specify a DISK for the log archive of the database, used the command:

update db cfg for "DES" using LOGARCHMETH1 DISK:G:\db2\DES\log_archive\

It prompts that the parameters submitted for immediate modification were not changed dynamically. Database must be shutdown and reactivated before the config parameter changes become effective. So I restart/bounce the database with:


Tried to check the database config again if the changes was made, but now I cannot anymore connect to the database and I was being prompt with error:

SQL1116N A connection to or activation of database "DES" cannot be made because of BACKUP PENDING. SQLSTATE=57019

SQL1116N A connection to or activation of database "DES" cannot be made because of BACKUP PENDING.

Any suggestions on how to activate back the database? Since now I cannot turn on the application for this one.

  • Have you tried looking up the error code in the manual?
    – mustaccio
    Jul 31, 2016 at 12:33

1 Answer 1


Backup pending means you need to take an offline backup. Since you went from circular to archive logging DB2 needs a point in time from where it can apply the logs.

  • how to take an offline backup in DB2? can you share some commands?
    – nicheLam
    Aug 1, 2016 at 2:19
  • In it's simplest form: db2 backup db DES Aug 1, 2016 at 4:03
  • do I need to specify a location? (e.g. "disk:\location") if no location specified where will it save by default?
    – nicheLam
    Aug 1, 2016 at 4:58
  • There are many options to backup, you need to check the documentation. Current directory is used if no destination is goven Aug 1, 2016 at 5:03
  • do I need to bounce/restart the database after doing the offline backup?
    – nicheLam
    Aug 1, 2016 at 7:48

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.