HCL Informix® TimeSeries Plug-in for Data Studio

You can load time-based data into existing time series instances by creating load jobs in the HCL Informix® TimeSeries Plug-in for Data Studio.

You must have the following prerequisites to create load jobs in the :

• or IBM® Optim™ Development Studio with the installed.
• An existing table with a TimeSeries column.
• Primary key values in your table and a time series instance that is stored in a container defined for each row. If your primary key has a data type of CHAR(n), and each value is not n bytes long, you must pad the values to be n bytes long or change the data type to VARCHAR(20).
• Connectivity information for the Informix® database server that contains the time series table. The connection is created through JDBC.
• A file of time-based data that you want to load into the database or a query to select data from a database.
• The data must be compatible with Informix® data types.

A load job consists of the following definitions:

• Record reader definition that describes the source of the data. The data can be in a file or in a database, including a database other than Informix®.
• Table definition that describes the schema of the Informix® table that has the TimeSeries column.
• Mapping definition that maps the source data to the time series table. If you change your table definition, you must also update the corresponding mapping definition.
• A connection profile for the Informix® database.
• A connection profile for the source database, if you are loading data from another database.
• Load properties that describe how the data is loaded.

  Load jobs have the following default properties:

  • Existing records can be updated.
  • The timestamp date format is yyyy-MM-dd HH:mm:ss.
  • Missing rows are created and populated with NULL values.
  • Data loading is distributed among five threads.
  • The data is saved to disk after every KB of data is loaded.
  • The data is attempted to be inserted 10 times before returning a failure.

  You can change these values and set other load job properties, such as logging load errors, by editing load properties in the plug-in.

You can reuse the definitions that you created in other load jobs.

After you create a load job, you can run it from the command line with the command-line loader application.

The maximum number of load jobs you can run simultaneously is limited by the capabilities of your computer.

The includes cheat sheets that provide detailed instructions for creating load jobs and loading data.