Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our Privacy Policy and User Agreement for details.

3.
Problem Informix/Baan System supporting North America Supply Chain is aging and database is large, causing performance concerns – Database had grown to 3TB • With development, pre-production, and testing – several instances – Performance further impacted by product use of hash indexing which scans the whole database Business negatively impacted from increased application availability problems and performance degradation – Affecting production line efficiency

5.
Objective Goals of the implementation – Keep the application stable until migration to Oracle E-Business can occur – Improve application availability and performance by reducing the size of the production database – Maintain availability of the historical data for the business

7.
Approach Solix was selected for their database archiving solution and willingness to partner – Solix agreed to invest and build Baan application archiving templates as part of the project • Engaged experts in Baan and Informix as part of the project – Solix people were on-site at Diebold – Project was 80% consulting, 20% software Diebold still needed to commit staff with knowledge of the business to project – Scoping/ re-scoping the effort – Manage production migration – Determine who would have access to archive database

8.
Results System functioning properly – can now migrate to Oracle per schedule – Archiving in production for 4 of 6 modules to-date Took several months (Internal resource issue) – 4-5 in-house staff for each module, on a part-time basis - 1-2 on-site Solix consultants, plus their support staff Cost – over $100k plus database and hardware resources – Using additional disk capacity for the archive data

10.
Recommendations If implementing archiving for an application where archiving templates are not already available, plan for more internal resources for the project and to pay for consultants to assist Chose vendor with database archiving tools, experience, and flexibility Ensure key internal staff (with business knowledge) are available