Topic
  • 2 replies
  • Latest Post - ‏2013-11-11T14:05:07Z by c_binding
c_binding
c_binding
12 Posts

Pinned topic Informix TimeSeries for new database

‏2013-11-06T12:47:14Z |

Greetings,

I've now managed to get the sample shipped with informix 12.10 to work (dbaccessdemo). it includes the time-series stuff ok.

Question: if I were to create a new database, how do I "import" all the time-series definition? I see a bunch of *.sql files in the timeseries install directory, but fail to see when and how these are executed.

should that just happen automagically when creating a new database? "create database <some_name>"?

  • HedwigFuchs
    HedwigFuchs
    1 Post

    Re: Informix TimeSeries for new database

    ‏2013-11-11T07:45:43Z  

    Hi,

    you need to register the timeseries datablade in the database. You can do this with either

    - SYSBldPrepare() (see https://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp?topic=%2Fcom.ibm.sqls.doc%2Fids_sqs_2051.htm)

    or

    - trough the scheduler task "autoreg exe". This task registers database extensions when they are first used

  • c_binding
    c_binding
    12 Posts

    Re: Informix TimeSeries for new database

    ‏2013-11-11T14:05:07Z  

    Thanks for the suggestion.

    I did notice though that the "stores_demo" DB seems automagically become a time-series DB in the dbaccessdemo COM script.  Maybe it was "just" this I was missing.

    for the time being I do use the "stores_demo" DB for prototyping my code, alternative might also be to use a LINUX box for Informix (plus OAT)