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.
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?
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.
bingo.1
1 Rookie
•
2430 Posts
586
0
Posted 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.