HomeSearchSite MapContact Us

   RemoteDBA Services for CODASYL DBMS and Rdb Remote Management of OpenVMS Systems Preserving Mission Critical IT Applications Through Virtualization

DATABASE
ADMINISTRATION

 
 

What are ".RUJ" Files?
TECHNICAL ARTICLES -> TROUBLESHOOTING ARTICLES
Back ] Next ] Printer Friendly Version ]

Q:

We’ve found many RUJ files on our system. What are they and is it okay to delete these files?

 

A:

The “.RUJ” files are “Run-Unit Journal” files, and they are critical to the automatic recovery mechanisms of Rdb and DBMS. Each processes that updates the database saves a pre-update copy of each modified record to this file. This allows a partially completed transaction to be rolled-back (undone) in the event of a deadlock, application or system failure.

 

Rdb and DBMS should automatically delete these files when the process unbinds from the database. At times, Rdb and DBMS does not delete these files – resulting in a “build-up” of obsolete RUJ files over time. If you have a directory full of these files, this can cause a serious performance problem.

Extreme caution should be used when deleting RUJ files. If you delete an RUJ file that is needed by Rdb or DBMS to rollback a partially completed transaction, the rollback will fail – leaving the database in an inconsistent state. This will cause Rdb or DBMS to abort all other users on the database with a  “RDMS-F-TERMINATE” or “DBM-F-TERMINATE” message. This is not good! The “official” recovery method is to restore the database from the last backup and then roll forward all completed transactions from the After Image Journal (AIJ) files.

 

To safely delete the RUJ files, you must first determine if these RUJ files are being referenced by any database. This can be done by using the RMU/DUMP or DBO/DUMP command and searching the listing for the questionable RUJ. In general, SCI recommends renaming the RUJs before deleting them (maybe a few days later).

 

Top


Was this article helpful? 
This information and more was originally published in SCI's technical newsletter, DBAdvisor.
Past issues are available online; you may also fill out a subscription form.

If you have a technical question about this article or about any other 
CODASYL DBMS or Rdb topic, then ask our experts.

How would you rate this article?

5 (Highest)
4
3
2

0 (Did not apply)
Comments about this article or topic suggestions for new articles

Copyright © 2008 Software Concepts International
All Rights Reserved