DB2 version 6.1 UDB
OS Win NT

Just yesterday I designed to take online backup and fall into this error.
How to come out from this error ? Any advice please ?


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

Probably it is expecting an offline backup ...

Have you just set the logretain to YES ???

Cheers
Sathyaram

Hi ,

You might have set the logretain to yes or userexit to yes. Once you change these parameters you must take the offline backup. After that only you can take the online backups.

Let us know if it works for u.

Thanks.

How to set these parameters ?

Hi Dingi,

You can do it from the configure database logging option of the databases menu under the control center.

OR You can customize the sample commands below.

CONNECT TO SAMPLE
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
UNQUIESCE DATABASE;
CONNECT RESET;
UPDATE DB CFG FOR SAMPLE USING logretain ON userexit ON logprimary 3 logsecond 2 logfilsiz 250;
BACKUP DATABASE SAMPLE TO "E:\ARCHLOGS\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

Please also read on backups to get a better picture.

HTH