Reloading the data mart

You can reload all the data in the data mart. Query acceleration is temporarily suspended.

About this task

You do not need to stop query acceleration. Between the time when you set the data mart to disabled mode and load the data mart, query acceleration is suspended and all queries are run by the Informix® database server.

Procedure

To reload the data mart:
  1. If trickle feed is enabled, disable it.
  2. Put the data mart in Disabled state.
    Query acceleration is suspended.
  3. Load the data mart.
    When the load completes, query acceleration resumes.
  4. Optional: Enable trickle feed for the data mart.

Example

The following statements disable trickle feed for the data mart, put the data mart in Disabled state, load the data mart, and enable trickle feed for the data mart: 

EXECUTE FUNCTION ifx_removeTrickleFeed('MyAccelerator', 'Datamart1');

EXECUTE FUNCTION ifx_setMart('MyAccelerator', 'Datamart1' 'OFF');

EXECUTE FUNCTION ifx_loadMart('MyAccelerator', 'Datamart1', 'MART');

EXECUTE FUNCTION ifx_setupTrickleFeed('MyAccelerator', 'Datamart1', 5);