Hi Guys, I want to know why it need very long long time to run a select SQL statement on Mimix jornualed files. It ran over 3 days for a select statements on a MimixJrn files (over 1 Millians records). But only use less than 1 hour to complete the same SQL selection statement for Non-MimixJrn files (copied from the Mimixed files and then run the same Select SQL)? what solution will be shorten the time? Thanks.
I got the reason why the time is too long to run in Mimix, it is becuase the select files in SQL statement have many LFs linked with. All the PF & LF should be selected under the PFs in MimixJrn.
Copy the PFs into QTEMP or any researched library, then run the SQL. Copy back the changed in SQL after ran. Thanks.
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!