Daimler Trucks, formerly Freightliner, is the largest heavy-duty truck manufacturer in North America and a leading producer of medium-duty trucks and specialized commercial vehicles. When Freightliner originally came to Dolphin several years ago, their database was 1.2 TB and had a fast rate of growth. Performance was slowing and system maintenance costs were escalating. However, the business required long-term access to detailed information; they were very reluctant to remove any information from the database. Solution Dolphin helped the company with their archiving strategy blueprint and implementation. In the workshop phase, we brought technical, functional and business users together to learn. From the business we learned about access and retention requirements as well as residency periods. We were also able to assist in getting the business buy-in for continuous archiving going forward. Dolphin’s analysis of the database provided the necessary details for planning an efficient archiving strategy for the long term. The result was to migrate high-volume transactional data records in finance, costs accounting, profit center accounting, profitability analysis and legal older than 24 months, and the Basis module after 90 days, from the SAP database to IBM CommonStore. This reduced the existing data volume by 50% and long-term growth was slowed by more than 80%. PBS archive add-ons were implemented to allow users to transparently access both online and archived data with screens identical to standard SAP transaction displays. In addition, PBS index information was used in customer-specific reports for efficient reporting on archived information. Results The solution resolved the immediate performance and system administration issues and satisfied the business need for fast, transparent access to information.
- 50 million financial accounting documents archived during initial go-live
- Users take as little as 1 second to access archived information
- Database volume was decreased by 50%
- Reduced long-term database growth by more than 80%
- Satisfies audit, legal, regulatory mandates