ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

how to retrive the record has been deleted?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to retrive the record has been deleted?

    hi,dear

    i hear about it has been achieved by reading savf or journal file ,how to do it?

    thanks.

  • #2
    Re: how to retrive the record has been deleted?

    The easiet way is to use DBU. I think WRKDBF can also undelete.

    You could restore the deleted record using ROLLBACK if using commitment control. If your journal stores "before" images, you should alos be able to recover the record.

    Comment


    • #3
      Re: how to retrive the record has been deleted?

      If the file is journaled yes that is one way to retrieve a deleted record.

      the tool DBU can retrieve deleted records but it cost $

      there is a free tool call WKRDBF this also retrieves deleted records and
      can be downloaded here.




      there are also a few tools out on the web that may also work.....


      let me know if I can help further.

      jamie
      All my answers were extracted from the "Big Dummy's Guide to the As400"
      and I take no responsibility for any of them.

      www.code400.com

      Comment


      • #4
        Re: how to retrive the record has been deleted?

        Hi!
        We have a freeware named "UNDEL", from News/400 shareware/freeware that we already have used.

        I don't know why but now, i don't find this freeware anymore and actualy we only have the object and not the source of the program. Perhaps someone can give you a hint


        Here is a link were it explaint the comand and what it does:

        Comment


        • #5
          Re: how to retrive the record has been deleted?

          heres your source
          Attached Files
          All my answers were extracted from the "Big Dummy's Guide to the As400"
          and I take no responsibility for any of them.

          www.code400.com

          Comment


          • #6
            Re: how to retrive the record has been deleted?

            If you have TAATOOL you can use RTVDLTRCD command to retrive the record.
            The limitation is that if a CLRPFM or a REORG is done on the file this command cannot be used.
            Regards,
            KR

            Comment


            • #7
              Thank you very much for this. I was googling the same probelm and found this

              Comment

              Working...
              X