Please consider another product that will provide similar function by LakeView Technologies, the developer of MIMIX the leading High Availability software.. To address your question, Lakeview responds... "This is exactly what MIMIX Promoter accomplishes. Promoter creates a copy of the production file, through programming techniques, that basically reads the production file (non-exclusively) and copies records to a shadow copy of the file. At the point the copy starts, MIMIX bookmarks additional transactions against the file by utilizing OS/400 journaling. If journaling is active for the file, MIMIX will utilize the active journal, if journaling is not active - Promoter will start journaling against the file "under the covers" with no user requirement to activate journaling. Promoter will then apply journal entries since the copy of the file started until it is completely caught up and current in order to catch the orphan activity. At some point when the activity is current and the shadow is copy is being updated in near real-time, the user can select to swap the shadow file into production and attach any logical files. The user can execute this swap process manually or have Promoter execute the swap. The swap process can take a few minutes and during this window - users cannot be accessing the file. However, at least 90% of the reorg downtime should be eliminated and Promoter handles all of the required functions." Mitchell K. Kleinman Executive Vice President CCS - an IBM Premier Business Partner 949-476-0874 (Main) 949-261-3298 (Direct) 949-261-9164 (Office Fax) 425-940-1954 (eFax) Mitch@ccseservers.com DAsmussen@aol.com Sent by: email@example.com 02/09/2003 11:26 PM Please respond to "SSA's BPCS ERP System" To: firstname.lastname@example.org cc: Subject: Re: New Product Announcement - Reorg without locking files Dear Mr. Shea, While your mentioned web site was interesting, it was far from informative (other than purveying the knowledge of how to purchase your products). How, exactly, does one properly reorganize a physical file on the AS/400 "without locking the files"? Your "Still Not Convinced?" section pointed only to other "ArcTools" customers, and the comments from ALL of those references were vague AT BEST. "Independent Software Reviewer"? "Manager, Manufacturing Information Services, medical devices"? "Partner, International Consulting Firm"? I could go on, but the lack of a single person putting their name to a quote speaks for itself. I believe that we can all agree that your archiving tool is a fine product. I also believe that those of us that understand the AS/400 are going to need more than the vague word of "AS/400 Consultant" to convince us that you can reorganize files without locking the system, unless you plan on lowering our security levels... Regards, Dean Asmussen Enterprise Systems Consulting, Inc. Fuquay-Varina, NC USA E-mail: DAsmussen@aol.com "There is one difference between a tax collector and a taxidermist -- the taxidermist leaves the hide." -- Mortimer Caplin 10:41:12 AM Eastern Standard Time, DShea@arctools.com writes: > DCSoftware is proud to announce the release of the ReorgWizard. > > ReorgWizard allows AS/400 and iSeries shops to reorganize physical files in > place, without locking users out of the system. If finding the time to do > reorgs is a problem for your BPCS shop, please visit > http://www.arctools.com > for more information. > _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.