How to manually delete DB2 backups

Question

Hello We have a problem with manually deleting DB2 backups. We set DB2 parameters on our DB (FN_GCD) Vendor options(VENDOROPT) = @DB/nsr/apps/config/nmda_db2.cfg Auto deletion of recovery objects(AUTO_DEL_REC_OBJ) = ON [root@testfilenetdb2 config]# more nmda_db2.cfgDB2_NODE_NAME=db2inst1DB2_USER=db2inst1DB2INSTANCE=db2inst1INSTHOME=/home/db2inst1NSR_SERVER=server_nameNSR_CLIENT=client_nameNSR_DATA_VOLUME_POOL =pool_nameNSR_LOG_VOLUME_POOL =pool_name Here is our backup:[db2inst1@...]$ nsrinfo -v -n db2 -s nwzg1.intranet.fina.hr -X all testfilenetdb2.unix.fina.hr | grep FN_GCD...version=1, DB2, objectname=/FN_GCD/NODE0000 /DB_BACKUP.20220304210025.1, createtime=Fri Mar 4 21:00:25 2022, copytype=3 BSACopyType_BACKUP, copyId=1646424025.1646424026, restoreOrder=1646424025.1, objectsize=0.0, resourcetype=database, objecttype=4 BSAObjectType_DATABASE, objectstatus=2 BSAObjectStatus_ACTIVE, description=NMDA_v193:DB2_v1156:FULL_BACKUP:FN_GCD:TEQ, objectinfo=db2inst1:1, NSR size=327298560 We want to delete it:[db2inst1@...]$ db2 connect to fn_gcdDatabase Connection InformationDatabase server = DB2/LINUXX8664 11.5.6.0SQL authorization ID = DB2INST1Local database alias = FN_GCD [db2inst1@...]$ db2 prune history 20220304 and deleteDB20000I The PRUNE command completed successfully. [db2inst1@...]$ db2 terminateDB20000I The TERMINATE command completed successfully.It is still here: [db2inst1@...]$ nsrinfo -v -n db2 -s nwzg1.intranet.fina.hr -X all testfilenetdb2.unix.fina.hr | grep FN_GCD...version=1, DB2, objectname=/FN_GCD/NODE0000 /DB_BACKUP.20220304210025.1, createtime=Fri Mar 4 21:00:25 2022, copytype=3 BSACopyType_BACKUP, copyId=1646424025.1646424026, restoreOrder=1646424025.1, objectsize=0.0, resourcetype=database, objecttype=4 BSAObjectType_DATABASE, objectstatus=2 BSAObjectStatus_ACTIVE, description=NMDA_v193:DB2_v1156:FULL_BACKUP:FN_GCD:TEQ, objectinfo=db2inst1:1, NSR size=327298560 We can still see backup '20220304'. Why is it still there if it was deleted in earlier step?We can see it also in NMC cosole. Regards

bingo.1 · Answer

What you use are database commands - of course NW does not understand that.

This is what you have to do:

- find out the SSID of the db backup to be deleted.

- delete it with nsrmm -y -d -S ssid

This should do the job ... for NetWorker.

DaleMido · Answer

Thank you for your reply, but the document (NetWorker Module for Databases and Applications Admin Guide) says: "The db2 prune command deletes backup entries for DB2 databases or tablespaces from both the
DB2 server and NetWorker server." How this can be achieved?

bingo.1 · Answer

Sorry, I am not a DB specialist. I just thought how to delete the save set via NW. This might be necessary to correct a malfunction.

According to the docs, one of the reason could be that "db2 prune" will not work when it is a snapshot backup. Then - according to the docs - another procedure applies.

NetWorker

Was this post helpful?