backup pending mode. Is there a way to change the mode without backup?

[Former Member]

Changed the archive log device and it is forcing to make an offline backup which makes 3 extra hour db outage.

I think it is not really a smart design considering 24x7 modern environments.

Is there a way to skip offline backup and use online backup instead?

[hans-juergen_zeltwanger · Accepted solution]

Hello,

db2dart <dbname> /CHST /WHAT DBBP OFF

should change the backup pending state

Regards, Hans-Juergen

[Former Member · Accepted solution]

This is really cool.

I tested and it worked great.

Quick follow up question.

After I issue the command, I changed logmeth1parameter back and forth a couple of times, and it never force me to make offline backup at all anylonger.

From the db2dart documentation, it seems the flag can be reset, but I was expecting that the on/off switch is not permanent.

Any thoughts about this?

[hans-juergen_zeltwanger · Accepted solution]

Hi,

I do not think that it is permanent.

Have your deactivated and re-activated the database after changing LOGARCHMETH1 to OFF ?

[Former Member · Accepted solution]

db2stop force

db2start

above commands a couple of times.

Did not deactivate / activate

[hans-juergen_zeltwanger · Accepted solution]

HI,

did a little test.

The db2dart setting is not permanent

.

[Former Member · Accepted solution]

Dear Sir,

I'm trying to connect to DB2 :

db2 connect to <SID>: Output is as follows -:

SQL1116N A connection to or activation of database "SMN" cannot be made

because of BACKUP PENDING. SQLSTATE=57019

Whne we've executed db2dart getting following error:

C:\Users\Administrator.----

---

>db2dart <dbname> /CHST /WHAT DBBP OFF

C:\Users\Administrator.----

---

>db2dart SMN /CHST /WHAT DBBP OFF

DB2DART Processing completed with error!

Complete DB2DART report found in:

C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\DART0000\SMN.RPT

"C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\DART0000\SMN.RPT Log:

Error: Failed sqledosd API on open system database directory.

SQL1057W The system database directory is empty.

Error: This phase encountered an error and did not complete.

______________________________________

DB2DART Processing completed with error!

WARNING:

The inspection phase did not complete!

______________________________________

Complete DB2DART report found in:

C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\DART0000\SMN.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E _______

"

Kindly please help us tor resolve the issue.

[Former Member]

yes, you can configure online backup.

[Former Member]

Do you have any link to the document using online_cons for db2 ?