I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must have journaling turned on. Unfortunately, we do not. I don't know a lot about journaling but I hear it's a system hog. Does anyone have any suggestions on how I can get reorging done without having to get everyone off the system? (Some of our files have millions of deleted records) I am on the AS400 V5R4

Answer Wiki

If your file has millions of deleted records, I would ask how many good records.
If it is a small number a REORG only taks a few moments depending on the number of LF attached.
One thing you need to do is change your the parm on your PF to reuse deleted record *YES. Then when new records are added, they will not take up new disk space, instead they will use the space from the old deleted recorxds. The only caution is that if you are processing sequentially, these new records will not be added at the end of the file, but rather randommly inserted into whereever there was a deleted record.
This may resolve your problem if more records are being added than deleted.
*
Journally is not a system hog unless you are journalling a file thaat has an extreme amount if updates and adds.. This will also used disk space if not managed properly.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 10 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

I hear it's a system hog.
Since it isn't, it's hard to say much about that. Programs are system hogs too -- if they're poorly written and badly used. You don't avoid programs, do you?
Does anyone have any suggestions on how I can get reorging done without having to get everyone off the system?
Sure. Journal the files and use the reorg-while-active feature. Running a critical 24/7 system without journaling seems indefensible.
(Some of our files have millions of deleted records)
Why? The files should be set to reuse deleted record space.
Tom

I appreciate all the help. I was not familiar with the 'reuse deleted record' function and I will definitely be using it. As I said before, I don't know much about journaling but I will definitely look into it. I will start by journaling a small file (baby steps you know). However, I do have 1 suggestion. I feel since this is a help site, there is no need for the condescending attitude.

Vision Solutions has a Reorg Whie Active Product that basically copies the file to a second library and applies journal changes from the primary file until it is in synch. You then swap the files out during a brief outage.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy