Server and database requirements for time series data

Server requirements

The first time that you create a time series object, the TimeSeries extension is automatically registered. However, the Scheduler must be running in the database server for automatic registration. If the Scheduler is not running when you create the TimeSeries data type or run a time series routine, a message that the data type is not found or the routine cannot be resolved is returned.

Alternatively, you can manually register the TimeSeries extension before you create any time series objects. Set the value of the AUTOLOCATE environment option to 0 for the session and then run the SYSBldPrepare() function or BladeManager.

Database requirements

The database that contains the time series data must meet the following requirements:

• The database must be logged.
• The database must not be defined as an ANSI database.
• Table and column names cannot be delimited identifiers. The DELIMIDENT environment variable must be not set or set to n.

If you attempt to create a TimeSeries data type or run a time series routine in an unlogged or ANSI database, the message DataBlade registration failed is printed in the online message log.