Here’s a handy technique I wrote up for IT Jungle in 2010 that I just reused again today. It shows you a simple way to speed up logical file access rebuilds when they are holding up system processing.
Here’s the reader email and situation the technique was designed to solve. Be sure to try this the next time your system can’t process orders because a large number of access paths are being rebuilt.
Our i5/OS HTTP server jobs crash after we reorganize large production files because the servers can’t open the access paths that the system is rebuilding after the reorganization ends. The servers can’t run until re-indexing is finished, and some of these physical files have 60 logical files attached to them. How can I speed up access path recreation so I don’t hold up processing?
=======================
Follow Joe Hertvik on Twitter @JoeHertvik. You can also add Joe to your professional network on LinkedIn by clicking here.
Joe Hertvik is the owner of Hertvik Business Services, a company that offers IT consulting services and produces White papers, case studies, brochures, email campaigns, and other on-line marketing material for Tech companies. If you need professionally written marketing content for your next campaign, email Joe for a free quote.