How to recover from Backup Pending SQLSTATE=57019 in DB2?

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.

Replay

Category: db2 Time: 2016-07-31 Views: 0
Tags: db2 db2 luw

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.222 (s). 12 q(s)