Year:
2014
Duration:
15 months
System environment:
Informix 11.70, Linux, Informix Warehouse, Informix Warehouse Accelerator, Reporting-/Analysis Tools (Cognos/Microstrategy)
Task:
The IT Service provider belongs to a nationwide operating Finance Group and was supported in the fields of optimization of the Informix database configuration, the acceleration of OLTP processes and the configuration/administration of Informix Warehouse Accelerator.
- Reorganisation of the IBM Informix database in order to enhance and accelerate ETL-processes. Preparation and execution of
- Informix- & Workshops dealing with options regarding system enhancements and Informix high availability options
Actions:
- Extension of data storage
- Consolidation of Data marts
- Adjustments Refresh-Skripte
- Creation & evaluation I/O statistics
- Creation & evaluation of index, table, chunk I/O statistics
- Optimization PDQ, Light Scans
- Query optimization (Informix optimizer)
- Creation DBSpaces
- Creation databases
- Execution of Informix-/SQL Workshops
- System evaluation
- Presentation Informix High-Availability options (HDR, RSS, SDS)
- Implementation consulting