Is your AS/400 or iSeries suffering from performance problems? 

Being forced into unnecessary upgrades based on a bloated database, rather than based on business requirements?  

• Automatic set-up
  

  download Arctools flyer
• Extensive validation
• Full online help
• Detailed reporting on the purge validation, status and record counts
• Run while users are online
• Retain full data integrity
• Run in increments that suit you

We currently have ARCTOOLS installed and working at our location, and it is fantastic. It is a great product and well worth the cost.

Gord Hanson, Senior Programmer / Analyst, Parkland Industries Ltd

I used JoinWizard to do a purge over 7 files where several of the files were purged based on data purged from another file. JoinWizard worked great. In the past this would have required specs, programming and testing. I ran the process on the test system, reviewed the results, and then updated live. No problems whatsoever.

It worked great and what a timesaver!"

- Jackie Watt, IT Development Supervisor, Patheon, Inc.

Think your users won't let you remove the data?

With Arctools, it is no longer necessary to get rid of the data. Simply moving the data out of the way (out of production) will speed up your system and keep the users happy.

It is very easy to make the archived data visible to just about any report, program, query, inquiry, etc., just as if it were still in the live system (call us and ask us how).

• Adds the archiving feature to any existing purge program without programming and without locking out users
• Has saved users tens of thousands of dollars in development costs
• Allows old data to be moved out of the way and very easily built back into those few reports and inquiries that need to see all data
• Requires no application or database source code
• Includes full audit trail for all purge and archive operations
• Provides easy archive data backup to tape, including extensive reporting on tape archives
• Supports physical files, logical files (including multi-format logicals)
• Supports full referential integrity checking (e.g. don't purge an order unless the invoice is paid and the customer is inactive)

One of the many success stories -
Before running ARCTOOLS, one customer's nightly Accounts Receivable Aging program ran every night, and took 92 minutes.
Invoice data had not been purged in over 5 years.

ARCTOOLS was brought in to archive 3 of the 5 years data. 62% of the physical data was archived out of the production environment.

The run time for the AR Aging program dropped from 92 minutes (using 1800 CPU seconds) to only 21 minutes (using 795 CPU seconds). To summarize:

This translates to the equivalent of a machine upgrade with 4 times the horsepower! Other processes also went faster, such as backups and on-line transactions. And since the data was archived on-line, it could be easily made visible to production reports and inquiries!

Now you CAN purge and archive your data without programming, and without locking out the users!