Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009

    Unanswered: how to recover dropped table on DB2 z/OS


    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.

  2. #2
    Join Date
    Dec 2008
    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.

  3. #3
    Join Date
    Feb 2009
    I think you couldnt recover your table without backup.
    Best regrads,
    Danny Utro.

  4. #4
    Join Date
    May 2009
    Provided Answers: 1
    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.

  5. #5
    Join Date
    Apr 2009
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts