Hello,

If I drop my table by mistake - how to recover on DB2 z/OS? Can I recover my table if I don't have backup?

Thank you.

I haven't worked with the MF since v7, so I can't say for certain about newer versions, but I don't think the dropped table recovery has been enacted on the mainframe. Therefore; no, you can't.

The schema and data have to come from somewhere, and if you haven't got a backup you don't have anything once the table is dropped.

I think you couldnt recover your table without backup.

D.Utro is correct. If you don't have an Image copy of the table space, there is nothing to recover.

The only hope you might have is if you did NOT define you Table spaces with a STOGROUP. If you defined your own files, they are still on disk even though the table space is no longer defined to DB2.

In you didn't use a STOGROUP and the VSAM files still exist, I would look up the DSN1COPY command. It makes an 'image copy' outside of DB2 and the only difference between a real Image copy is it is not recorded in the SYSCOPY table.

Thank you. I looked up the DSN1COPY command but still don't understand how to recover my table if I still have the VSAM file but no backup. Do you have any examples?