Case Study – Financial Institution
“Backing up our data was a nightmare using the IBM Copy product. Too much time was spent deciding if full or incremental copy was needed. With CDB, we were able to dynamically control that decision, and reduce our system load in the process.”
Environment
- Experiencing tremendous growth in DB2 system due to mergers and growing customer base
- High online transaction activity through customer website
- 24x7 availability needed for online and ATM transactions
Implementation
- Used Wildcards to process many objects per job
- Reduced number of jobs
- Tolerates changes in environment (i.e., dropped or added objects)
- Set consistent rules for all applications
- Full image copies done on all objects
- Recovery JCL written to file for offsite storage with backups
- Reorg need determined by clusterratio, object size, number of extents, index condition
- Used Automation to automatically size and allocate datasets
- Email notification to DBA of job failure with pertinent information
Benefits Realized
- Eliminated redundant utility processing
- Standardized applications from multiple merged data centers
- Guaranteed compliance with imposed regulations for recovery capability
- Reduced workload of DBA staff
- Email notification of failures eliminated need to review all successful job output
- Eliminated complicated job scheduling system for utilities
- Fewer jobs to maintain
- New applications seamlessly integrated
- Reduced System Resources
- CPU savings of as much as 80% due to eliminating unnecessary utility runs
- Restartable process eliminated wasted time re-running utilities from the beginning
- Reduced DASD usage
Met 24x7 availability requirements - using CDB's online utilities
|
