Case Study – Retailer
“When it came right down to it, other third party vendor utilities just didn't provide the flexibility we needed. By using CDB/Automation, we are now able to do anything we want.”
Environment
- Processing data for over 500 retail outlets
- International expansion led to 24x7 availability requirement for some applications
- Experiencing tremendous DB2 growth
- Number of utility jobs increased from 1,500 to 7,100 in 2 years
- Plans to double processing in next 2 years
- Database greater than 1 terabyte
- Shortage of DBA staff
Implementation
- Automated decision of need for Reorg runs based on disorganization factors
- Automated decision to start a Reorg based on:
- Remaining batch window
- Reorg speed history (maintained history per object)
- Expected elapsed time
- Table priority
- Reorged frequently with automated size reallocation
- Dynamic allocation of Image Copy datasets
Benefits Realized
- Better transaction times
- Less batch window invested in Reorg
- Better utilization of batch window due to prioritizing of objects
- DASD savings of between 25% and 33%
- Simplified JCL
- Standardized Image Copy dataset names
- Easy implementation of GDGs for Copy
- Met all availability requirements
|
