How to recovery a dropped table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • emrezende
    New Member
    • Dec 2008
    • 4

    How to recovery a dropped table?

    I am running DB2 v9 in z/OS.
    I am trying to recovery a dropped table but I could not do it.
    I have the full and incremental image copies from before of the drop table command.
    The recover utility is working right and shows RC=0, but the table has not been recovered.
    When I try to recover another table that had all the rows deleted is working.
    Anyone can help me?

    Thank you,
    Eduardo
  • anijos
    New Member
    • Nov 2008
    • 52

    #2
    Go Through

    IBM Information Management Software for z/OS Solutions Information Center

    AniJos

    Comment

    • emrezende
      New Member
      • Dec 2008
      • 4

      #3
      Anijos,

      Thank you for your reply, helped at lot!

      Eduardo

      Comment

      • emrezende
        New Member
        • Dec 2008
        • 4

        #4
        Anijos,

        Yesterday I tried the procedure described the in IBM site but I am getting this error:



        I tried the DSN1COPY with the OBIDXLAT, FULLCOPY and both are given the same error.
        Any suggestions now?

        Comment

        • ganeshmn25
          New Member
          • Aug 2008
          • 28

          #5
          Recover Dropped Tables in DB2

          Comment

          • emrezende
            New Member
            • Dec 2008
            • 4

            #6
            Ganeshmn,

            Thanks for reply, but this tutorial apply for Windows, Linux and UNIX, but I am using z/OS.

            Any other suggestions?

            Eduardo

            Comment

            Working...