Skip to Content
0
Former Member
Aug 01, 2016 at 05:23 AM

How to do full offline backup of DB2 database in SAP?

1930 Views

Hello,

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

Looking for suggestions online on how to connect back the database;

there's a suggestion that to connect to the database it is only possible after a full offline backup of the database has been performed.

Thanks