Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    85

    Question Unanswered: DB2 Restore Drop column of a table with data

    Hello all

    I have a problem..

    On my Development DB some one has drop a column in a Table.

    I need to restore that column to it's table with all the data that was on it.
    Also i need to find who did this. May be a user/ip and timestamps etc..

    How to do this...

    Plz advice

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You are going to have to RESTORE a backup image that was taken prior to the column drop to get the data back.

    I do not know if you can find out who did it. They would have had to do a REORG afterwards so it had to be somebody who knew what they were doing.

    I suggest you review how your security is set up.

    Andy

Posting Permissions

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