Reorganizing AS/400 Files While Active

200 pts.
Tags:
AS/400
AS/400 Records
iseries v5r4
RPG
RPG ILE
RPG IV
RPGLE
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

Software/Hardware used:
AS400 V5R4

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 10  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • GHENDER
    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.
    200 pointsBadges:
    report
  • OldSysAdmin
    +1 for that comment!
    945 pointsBadges:
    report
  • Batman47
    I agree.
    1,050 pointsBadges:
    report
  • DB2iDBA
    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.
    40 pointsBadges:
    report
  • HMSSL2K
    We use the Vision Solutions REORG tool, it works great. Give it a try.
    3,175 pointsBadges:
    report
  • PGMBOB
    Perhaps you can do a reorg before each backup. Hopefully management will appreciate the need for backup and maintenance before they really need it. Good Luck!
    1,160 pointsBadges:
    report
  • GHENDER
    [...] Reorganizing AS/400 files while active [...]
    0 pointsBadges:
    report
  • BigKat
    if you have TAATOOLS, see the help text for CPRDLTRCD and TRNDLTRCD
    8,350 pointsBadges:
    report
  • GHENDER
    [...] Reorganizing AS/400 Files While Active [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following