Filtered by:. Previous template Next. Thanks, DAC. Tags: None. July 19, , AM. All my answers were extracted from the "Big Dummy's Guide to the As" and I take no responsibility for any of them.
Comment Post Cancel. Sponsored by Racksquared. Call: Email: Sales racksquared. Leave a Reply Cancel reply. Search for:. Table of Contents DB2 for i 7. Subscribe To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter. Search Search for:. Sorry, your blog cannot share posts by email. Steps To Effectively Reorganizing Files As I discussed last time, here are the steps to follow for an effective disk reorganization strategy.
Set up a procedure for identifying files and members that need reorganization. Identifying times that critical files can be reorganized. If a special value is entered, parts 2 and 3 must be blank.
The member is not reorganized, it is only compressed by removing deleted records. The member is reorganized by replacing deleted records at the start of the file with valid records from the end of the file. If the physical file is keyed, the member is reorganized according to the access path of the physical file. The second part is the logical file library if a logical file is named. The third part is the logical file member if a logical file is named.
Access paths will be rebuilt synchronously at the end of the reorganization. Thanks for the update Steve. I don't think many programmers these days write code that reads a file sequentially, unless it's a purely sequential file, so the problem with Relative Record Number RRN would not be an issue. Of course if debugging to have to realise that the record you just added to a file might not appear at the end of the file I have rarely in the last 10 years had to deal with that.
The whole update, insert, delete process was horrendous to code, but I am pretty sure nobody does that any more Of course some companies could still be using really old systems I do know that running a RGZPFM can be an issue, especially with F which can become very large and which has dozens of logicals over it.
Our F is currently 85 million records - that could take quite a few hours to reorganize No other company probably would have the issue. But the posting program only reads the F records by partial key, not all of the way to the JE line number. We use a wierd intercompany option that uses the 1st record of the batch to determine the intercompany company.
Our payroll updates take a long time. Post reply. Similar threads. Replies 9 Views Jul 29, alfredorz.
0コメント