0

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:

db2stop
db2start

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 '16 at 12:33
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 '16 at 2:19
  • In it's simplest form: db2 backup db DES – Lennart Aug 1 '16 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 '16 at 4:58
  • There are many options to backup, you need to check the documentation. Current directory is used if no destination is goven – Lennart Aug 1 '16 at 5:03
  • do I need to bounce/restart the database after doing the offline backup? – nicheLam Aug 1 '16 at 7:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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