Retrieve Deleted Records

ProData utilities offer two methods to retrieve deleted records.

When records are deleted from a IBM i database file, the data can no longer be accessed by programs. While the deleted records continue to occupy space in the file until they are removed using a function such as RGZPFM or CPYF with COMPRESS (*YES), the data itself is no longer available.

ProData utilities offer two methods to retrieve deleted records.

  • DBU's retrieval of deleted records
  • RDR utility

DBU retrieval of deleted records

  • Can only be used on physical files in arrival sequence
  • Will retrieve one record at a time
  • Retrieve deleted records is activated/deactivated by typing RDR in the control field on the file display within DBU
  • Record is reactivated in place
  • Records are found by rolling through the file or advancing through the file using the search function or by keying in a relative record number in the control field and hitting <Enter>. When a deleted record is found, the message ** DELETED RECORD ** appears. Pressing <F17> will display the deleted record, pressing <F17> again will reactivate the deleted record.

RDR utility

  • Must be used on a physical file
  • Will retrieve all deleted records in a file or deleted records within a RRN range
  • The number of deleted records in the file is displayed
  • Records retrieved will be placed in a second file designated on RDR command
  • Records may be retrieved with RRN attached, for analysis purposes
  • If DBU is owned, the deleted records retrieved will automatically be shown to the user using DBU

Two methods can then be used to retrieve the record(s).

1) The desired deleted records can be copied back into the original file. Use CPYF (with *DROP in Record format field mapping, if RRN's were requested) to copy the appropriate records back to the original file. In this case the retrieved records are placed at the end of the file.

2) Once the deleted records to be restored have been identified, use the RDR function within DBU to reactivate the record(s) in place, in the original file.

**Hint** Building logicals over the retrieved deleted records will help in locating the correct deleted records. The physical RRN is showed on the display of the logical file records.

For more information on RDR, please visit the RDR product page.

DBU access to the System i AS/400 database is available thru the traditional green screen, our graphical user interface and even thru IBM's Systems Navigator and WDSc. Just let us know what you are most comfortable with & we will get you up and running!

Programmer Utilities

Case Studies

  • RDB Connect - Access Real-Time Driver Information
  • RDB Connect - Just What the Dr. Ordered
  • DBU, RDR & ProTools - Tedious Tasks Made Simple with ProData Utilities!
  • DBU - North Central Co-op Succeeds with AgVantage and DBU
  • DBUnifier - Create F4 Selection Lists in an Instant
  • RDR - RDR (Retrieve Deleted Records) Nothing Could Be Simpler
  • SQL / Pro - SQL / Pro Saves a City

Support Options

Support Information

  • Annual contract available
  • Provides technical assistance and product releases
  • Disaster Recovery
  • Customer Portal
  • FAQ knowledge base
  • Promotional discount for other products
  • Video Demos
  • Webinars
  • Individual demos / webinars available upon request
  • Product Documentation Page

IBM Platforms
AS/400, iSeries, i5, Sytem i, IBM i and Power Server