Informix Services

The team is specialized in consulting services and solutions for the Informix DB. These solutions are mainly focused on maintenance and improvement of mission-critical business environments.  We are happy to provide the technical support which companies that rely on Informix need.

Our portfolio of services offers a full range of Informix consulting and support solutions, including virtual DBA services, the development of applications for Informix environments, expert advice and training services.

Our technicians are highly qualified and have earned multiple certifications in the area of IBM Data Management, as well as valuable experience supporting important Informix installations worldwide. We also have Informix specialists with a high degree of experience and international recognition. As part of our added value, at we are able to deliver our support and services in Spanish, Catalan, English and French in many different time zones.

Value offer

When you acquire or renew the maintenance of IBM Informix products with Deister, we include an offer of value-added services to our customers that increase the benefits of the services contracted with the manufacturer.

  • Consulting on correct hardware sizing.
  • Ability to choose and optimize the best licensing model to suit the specific needs of the client.
  • Assistance preparing the environment for Informix compliance.
  • Assistance identifying problems and managing relationships with Informix’s technical support.
  • Access experts’ know-how.
  • Access to the market’s best prices.

Installation and configuration

The installation service contains all elements required to install and configure a database system according to defined requirements.

Through this service our team of consultants and experts works closely with the client, developing a framework of conditions and planning the necessary steps for correct server configuration.

  • Evaluation of the client applications that access the database.
  • Analysis of the connectivity and interfaces required (ODBC, JDBC, etc.)
  • Analysis of the infrastructure: 2-tier, n-tier.
  • Calculation of necessary resources: disk, memory, CPU.
  • Planning the installation of external components: SDK, iSQL, etc.
  • Planning and documentation of initial system configuration.
  • Support for security configuration depending on requirements for availability, service time or resources.

License Part #: IFX-000-01

Migration

Companies often need to migrate databases between servers with incompatible architectures, or between versions without a supported update path. In such scenarios, the assistance of specialized personnel with experience in these tasks is required to minimize risks and optimize system downtime.

possesses this valuable knowledge, with a highly skilled team that supplies customers with a database migration package including analysis of the best possible migration method, the transfer of database information between servers, and verification that all structures and data have been transferred correctly.

The customer also gains a clear checkup or tuning of engine parameters introduced in new versions, backup policy recommendations, and documentation of the overall process.

License Part #: IFX-001-01

Preventative support and virtual DBA

We have accumulated plenty of experience after more than 20 years working in Informix environments, complemented by our experience developing database tools and carrying out large database implementation projects.

Our customers can directly take advantage of this experience we’ve collected over the years. Our offer is more than just standard update support or reassignment of cases to IBM personnel. Our comprehensive support offer lets you benefit from our know-how and full management of each case, accessing not only the knowledge databases of IBM, but also the management skills of our staff.

  • Our Informix specialists have extensive experience and recognition. You can access your consultants to both address the resolution of problems and determine the best methods of equipment installation or configuration.

License Part #: IFX-002-01

IWA installation and configuration

If you need to reduce response times for your complex queries in data warehouse environments, we can help you to install, configure and start using the Informix Accelerator (IWA) on your Informix database. The use of IWA is transparent to end users; no changes are required at the applications level or in the database schema.

If you need a solution to increase the speed of your data warehouse queries while simplifying the administration of your systems, our Informix IWA service offer will help you design and implement data marts, in addition to learning how to implement the advanced features of Informix’s latest-generation accelerators.

License Part #: IFX-003-01

Training workshops

Informix Introduction

This is a basic two-day course addressed to a wide spectrum of people, aiming to provide training on the fundamental aspects of the database engine.

By the end of the workshop, attendees will be able to:

  • Plan, install and launch an Informix instance
  • Understand authentication, authorization and security concepts
  • Create databases and objects
  • Use SQL to perform operations on the database
  • Understand concurrence mechanisms
  • Become familiar with replication and high availability mechanisms

Informix Administration

With this advanced-level seminar aimed at analysts, programmers and DBAs, some advanced features of Informix are worked on and administration mechanisms are studied.

By the end of the seminar, attendees will be able to:

  • Configure the server to allow local and remote connections.
  • Use Informix utilities to supervise server activity.
  • Describe shared memory components and configure component size.
  • Identify disk architecture components of the database server.
  • Create dbspaces, blobspaces and sbspaces and add chunks to these spaces.
  • Explain the purpose of physical logs and logical logs, as well as supervising logging activity.
  • View individual transactions that are written in logical log files.
  • Describe the importance of checkpoints on the server.
  • Explain and understand the purpose of the temporary spaces used by the server.
  • Monitor resources utilized in user sessions.
  • Use different issue resolution techniques to identify and solve common problems.

Informix Backup: PSM, onbar, ontape and dbexport

Intended for analysts and DBAs, this seminar more deeply explores installation, configuration and better use methods of the different mechanisms used to back up and restore Informix systems.

By the end of the seminar, attendees will be able to:

  • Understand the importance of backup copies and explain the advantages and disadvantages of each available method.
  • Create backup copy policies and plans.
  • Use copies to ASCII files and linear binary copies, and understand the advantages of Onbar.
  • Configure and launch Informix PSM.
  • Perform object analysis and backup copy structure.
  • Use Onbar to create and restore copies.
  • Transfer PSM copies between servers.

Installing and configuring Informix Warehouse Accelerator

This seminar is intended for analysts and DBAs. It will allow them to acquire the necessary knowledge to install and configure the Informix Warehouse Accelerator (IWA).

By the end of the seminar, attendees will be able to:

  • Understand the operating architecture of the IWA.
  • Install the accelerator.
  • Achieve the best configuration of coprocessors and memory for each client’s needs.
  • Deploy accelerator clusters.
  • Define data marts from the Data Studio or through learning.
  • Understand and know how to configure advanced features such as: trickle feed, partition refresh, NoSQL acceleration, use of synonyms, views and external tables, etc.

Informix NoSQL: Management of unstructured data

This seminar is intended for analysts, programmers and DBAs. It explores the use, installation, and configuration of NoSQL or JSON data within the Informix database.

By the end of the seminar, attendees will be able to:

  • Understand the reasons to use NoSQL databases.
  • Install and configure the necessary infrastructure for the use of NoSQL data.
  • Create NoSQL tables and data support structures.
  • Configure a listener for MongoDB access interfaces.
  • Use SQL statements to access and manipulate NoSQL data.
  • Configure server farms for NoSQL data sharding.

Administration and programming with Informix TimeSeries

This seminar will help you obtain knowledge to expand database functionalities by adding time series (with date and time) in any set of data that is accessed sequentially. This lets us choose to process and analyze data generated by smart meters, RFiD tags, etc. chronologically.

By the end of the seminar, attendees will be able to:

  • Create and configure time series tables.
  • Define calendars and storage sequences.
  • Evaluate benefits relative to load time acceleration and realtime availability.
  • Use the extraction and filtering functions which are native to time series.
  • Set VTI interfaces for data processing using SQL.
  • Create data marts and accelerate queries to time series tables.

License Part #: IFX-900-01