How do I reorganize physical files on my iSeries server?
Does the VigilEnt Security Agent for iSeries offer a tool that reorganizes physical files on the system?
VigilEnt Security Agent for iSeries
VigilEnt Security Agent for iSeries 7.5
VigilEnt Security Agent for iSeries PSAudit
The Files Needing Reorganization report in PSAudit allows you to report on libraries with physical files thatÂ are disorganized. Reorganizing a file purges all deleted records. This report identifies files that exceed the specified percentage of disorganization or number of deleted records per file threshold.
If you set the Submit Reorg fieldÂ of the PSAudit Submittal Window to
Y, then a batch job is created for each file listed in the report. These batch jobs purge all deleted records from the specified files.Â
To reorganize files on your iSeries server:
- From the Product Access Main Menu,Â type
1(PSAudit) and press Enter.
1(System Auditing and Reporting) and press Enter.
3(File/Member Reports Menu) and press Enter.
1(Files Needing Reorganization) and press Enter.
- In the Percent or Deleted Rec field, specify the percentage of the file that is disorganized or the number of the deleted records per file threshold.
- To purge the deleted records in the specified files, type
Yin the Submit Reorg field.
- If you have not pre-loaded the databaseÂ or if you want to reload the database, type
Yin the Reload database before field.
- Press Enter.
Consult with thrid party vendors before reorganizing files in a software package. Some packages base processing on the relative record numbers (RRN) of files instead of on file keys.