Is is possible to undelete an object?

[droach]

I deleted a list of orphaned SQL backups using the command 'delete object nnnnnnnnnn'. Is it possible to undelete them before the expiration & reclaim jobs run?

 

[marclant]

Only if you restore the database to a point in time before the delete object. You will also need to audit some of the volumes in the storage pool after the restore. Full procedure and details here: https://www.ibm.com/support/pages/recommended-dsmserv-restore-db-point-time-procedure

 

[droach]

Thanks for the reply marclant. Not knowing exactly what the 'delete object' command does, I was hoping there was a command to reactivate the deleted objects or a way to fiddle with the DB2 tables to get them visible again.

 

[marclant]

It's an instant command, it deletes the database records directly from the tables for the object specified. So as soon as you hit enter and you get the prompt back, it's gone for good.

 

[droach]

Ok, thanks for letting me know. Now I can move on.