Year:
2016
Duration:
4 months
System environment:
IBM Power/AIX, Informix 11.70, Informix HDR, Data Warehouse/Informix Warehouse Accelerator (IWA)
Task:
The company is nationwide active retailer and was supported in analyzing and changing of the database configuration (Caching, Fragmentation, PDQ) and the programming/optimization of statements of the batch applications. The focus was on Analysis and Removal of performance bottlenecks.
Actions:
- Analysis & Adjustments in server configuration
- Caching
- Fragmentation
- PDQ
- Analysis of queries & batch applications
- Performance tuning
- PDQ
- Optimization database design