Year/Duration:

2020 until today

System Environment:

• Informix 12.10/14.10
• Linux
• CDR/ER

Task:

Our client is one of the leading food industries in Europe and make use of the Informix Database company wide mainly in the field of logistics. The informix database is critical to a high degree. Consequently huge attention is paid specially to High Avalability, Redundancy and Replication topics.

Actions:

• Maintenance of Informix Databases
• Configuration of the Replication (ER/CDR)
• Securing of High Availability
• Stored Procedures
• Analysis/Creating of tables
• Consultancy
• Data reassessment
• Database Monitoring
• Modernization/Automation of data cleansing processes

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

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

Year:

2015

Duration:

4 months

System environment:

• HP/Linux
• VMware ESX
• Informix 11.70
• Informix High Availability Tools
• Connection Manager (CM)

Task:

The nationwide active company offers project related and regular services for institutions and partners in the healthcare environment.Focus were on system design, installation & configuration services, performance tuning, Informix Workshops.

Actions:

• Design/configuration memory requirements/organisation
• Installation/configuration data base server
• Implementation High Availabiltiy Cluster (High Availability Data Replication, HDR)
• Implementation Load Balancing Connection Manager (CM)
• Implementation Backup (onbar)
• Tests ( Failover, connectivity)
• Documentation of system environment
• Preparation & realization Informix Workshops for system administrators