db2dart command after activating online logs back

[Former Member]

If you activate online logging of DB2 back, after you had deactivated it, you would get an error :

SQL1116N  A connection to or activation of database "<SID>" cannot be made

because of BACKUP PENDING.  SQLSTATE=57019

You get this error, because you should have had an offline backup because of the DB2-mechanism. For DB2, it's essential to have base offline backup after you activate DB2 online logging back. To overcome this, we can use db2dart workaround. But it's recomended that you make an offline backup instead.

The commands of the process. You can see the workaround in step 5:

1-You deactivate DB2 online logging:

db2 update db cfg for <SID> using LOGARCHMETH1 OFF

2-You restart the database:

db2stop - db2start

db2 connect to <SID>

3-You activate DB2 online logging back. The value of LOGARCHMETH1 depends on your backup,etc archictecture.

db2 update db cfg for <SID> using LOGARCHMETH1 DISK:/db2/<SID>/log_archive/

4-You restart the database and get the error:

db2stop - db2start

SQL1116N  A connection to or activation of database "<SID>" cannot be made

because of BACKUP PENDING.  SQLSTATE=57019

5-Workaround for this error:

db2dart <SID> /CHST /WHAT DBBP OFF

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

6-You are able to open database:

db2start