
|
|
 |
Tektronix 
|

 |
|
 |
 |
Tektronix faced issues related to data growth, data availability, system performance and system availability in a 24 x 7 environment.
To address these challenges, Tektronix implemented a worldwide data archive solution from HP in June of 2002. This archive solution proved invaluable in its efforts to lessen the burden of data growth, mitigate performance problems in the company’s OLTP system and still satisfy worldwide financial and reporting requirements.
|
|
 |
Solution overview |
 |
 |
Tektronix implemented a proof of concept and testing that provided convincing evidence of the efficacy of the HP StorageWorks Reference Information Manager (RIM) for Databases solution. In particular, it established:
- RIM for Databases is a robust, reliable product that solves Tektronix’s archiving issue.
- The solution can be used to archive custom data.
- The archived data was available in the archive instance without data loss.
- There were measurable performance improvements.
- Significant space savings could be realized.
Based on the proof of concept results, Tektronix elected to proceed with a full RIM for Databases implementation. To have the fastest impact on escalating application data growth, Tektronix prioritized the implementation of the Oracle Application archives based on their current space usage.
|
|
 |
Results |
 |
 |
The initial proof of concept made a clear argument for the validity of an application data management solution with the relocation of historical data into an online archive. The subsequent results of the HP RIM for Databases implementation and archive operations further reinforced this conclusion.
Based on Tektronix’s firsthand experience, the company has determined:
- Purging data improves system performance
- Purging data reduces database server resource consumption by:
o Reducing hardware upgrade costs o Consistently executing batch jobs on time o Improving online response time o Reducing disk growth
- RIM for Databases reduced the cost and time for additional development and test environments.
- RIM for Databases reduced backup and copy time as well as disaster recovery time.
- RIM for Databases acts as an extension of Oracle Applications to eliminate the need for additional end-user training.
- HP provided excellent partnership and support.
|
|
 |
|
 |

|