Loading feeds...


Δ.Ε.Η


  • JoomlaWorks Simple Image Rotator
  • JoomlaWorks Simple Image Rotator
  • JoomlaWorks Simple Image Rotator
  • JoomlaWorks Simple Image Rotator
  • JoomlaWorks Simple Image Rotator

DEH have recently migrated their billing application to a DB2/SAPR3 AIX based solution.

They faced ,within months, with an influx of data, hard to maintain properly, which caused the Database size to be around 5-6TB and serious performance issues to their Batch procedure . As the Batch procedure performance started to deteriorate, it  spilled its designated Time Window, coincided with the Daily activities  and caused further issues.

Data Reorganization using Value/Row Compression to the most significant large Tables, did the trick. It shrinked the Database to 40% of its original size,  eliminated any Batch/Heavy Query Performance issues and allowed thinks to be back to normal.

DataBlue provided and still does, constant , hands-on consulting on Database Tuning and Administration issues.