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