Unsolved
4 Posts
0
837
April 6th, 2022 05:00
How to manually delete DB2 backups
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.cfg
DB2_NODE_NAME=db2inst1
DB2_USER=db2inst1
DB2INSTANCE=db2inst1
INSTHOME=/home/db2inst1
NSR_SERVER=server_name
NSR_CLIENT=client_name
NSR_DATA_VOLUME_POOL =pool_name
NSR_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_gcd
Database Connection Information
Database server = DB2/LINUXX8664 11.5.6.0
SQL authorization ID = DB2INST1
Local database alias = FN_GCD
[db2inst1@...]$ db2 prune history 20220304 and delete
DB20000I The PRUNE command completed successfully.
[db2inst1@...]$ db2 terminate
DB20000I 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
0 events found


bingo.1
2.4K Posts
0
April 6th, 2022 06:00
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
4 Posts
0
April 7th, 2022 00:00
bingo.1
2.4K Posts
0
April 7th, 2022 01:00
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.