If IWA is taken offline, will the rows added to the data mart's trickle fed tables be updated in the IWA once the accelerator comes back online?

Technote (FAQ)


Question

You have Informix accelerator running and need to take an outage for maintenance. Trickle feed is enabled on all the data marts. If IWA is taken offline, will the rows added to the data mart's trickle fed tables be updated in the IWA once the accelerator comes back online? The database will not be down for this outage and loads will be occurring.

Answer

Tricklefeed option will not work to keep everything updated in the IWA.

The proper way to do this task is as follows:
1. Remove trickle feed,
2. Stop the accelerator,
3. Do the required maintenance,
4. Start the accelerator,
5. Refresh the data marts (by doing a refreshMart operation on each data mart),
6. Set up and restart the trickle feed.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers
Informix Warehouse Accelerator

Software version:

11.7, 12.1

Operating system(s):

Linux

Software edition:

Developer, Enterprise, Express, Growth, Hypervisor, Innovator, Ultimate, Workgroup

Reference #:

1677980

Modified date:

2014-07-01

Translate my page

Machine Translation

Content navigation