EIQ PRODUCT Suite Maintenance

This document discusses the issues related to EIQ Product Suite configuration backup and restore procedures. It is recommended that admins backup configuration related files regularly to enable quick recovery to the most recent working state in case of failures.

EIQ Product Suite Files Needing Regular Scheduled Backup

It is a good practice to backup important and necessary EIQ Product Suite Configuration related files at regular intervals.

Before copying configuration files, make sure that all EIQ Product servers are stopped: Whamtech EIQ Server and Whamtech EIQ RTIS. Stop the servers through 'Windows Services'.

The following are EIQ Product Suite files that need to be backed up regularly:

Index Files: The index files built through the EIQ Server RTI Tool in "Profiling" and "RTI" mode are stored in "C:\Program Files\WhamTech\Data" by default, under folders named after the respective index names. If you chose a folder other than default folder when building indexes, copy the index files from that folder.

EIQ Server Configuration Files: All the EIQ Product Server configuration information, such as virtual data sources, registered data sources, and SuperSchema mappings, are stored in the "Settings\EIQConfig" folder under the EIQ Server Installation folder. By default, this is under "C:\Program Files\WhamTech\". The "EIQConfig" folder needs to be backed up.

EIQ RTIS Configuration Files : All the configuration information related to EIQ RTIS is stored in files under "Settings\EIQUpdateConfig". These files can be backed up from the default "C:\Program Files\WhamTech\Settings\EIQUpdateConfig" folder. Make a copy of the entire folder "EIQUpdateConfig".

EIQ Server Query Tool Files: The query files from EIQ Server Query Tool can be stored anywhere, but it is recommended to store them in "C:\Program Files\WhamTech\Data" inside the respective index folders. Make a copy of these files.

JMS Bindings: The information related to JMS bindings is stored in "C:\Program Files\WhamTech\JMSConnectionFactory" by default.

EIQ Product Suite Deployment Environment Files

Apart from these files, admins should make note of relevant system environment variables. This information is essential for restoring or re-creating the system environment for an EIQ Product deployment. The information includes:

Data Sources: Any information related to data sources including client configuration details

ODBC DSNs: Names of the ODBC DSNs for the related data sources

Logical Drives and Paths: The full path information for each of the files backed-up above

MSMQ/JMS Queues: Names and properties of MSMQ and JMS Queues

Restoring EIQ Product Suite Configuration from Backup files

The following are some scenarios in restoring EIQ Product Suite configurations from backup files:

Scenario 1: Restoring to a last known configuration

If configuration files get corrupted for any reason or there is a need to revert back to a known working configuration, all that an EIQ Server Admin needs to do is to replace the present copy of files with the old copy from backup.

Before you proceed, first make sure to stop the EIQ Product related servers. Replace the files mentioned in the previous section with the files in the backup.

Scenario 2: Moving/Re-deploying EIQ Product Suite configuration

When moving or redeploying an existing EIQ Product Suite deployment configuration to a new system, there is one extra major step involved: an EIQ Admin needs to re-create the original system environment on the new system. This includes installing data source client software, re-creating DSNs with original names, re-mapping logical drives, creating file/folder paths, creating queues, etc.

Steps for recreating the system environment:

1. Set up the required data sources by attaching the databases with the appropriate names and settings.

2. Create ODBC DSN for the databases with the appropriate names and related databases.

3. Create logical drive maps and paths.

4. Load the back up files and store them at the right places.

5. Create the related message queues and make sure that the names are consistent.

Once the original environment is faithfully re-created on a new system, copy the backup files to their corresponding locations.

Scenario 3: Upgrading the software

When upgrading the EIQ Product Suite software, follow any special installation and un-installation instructions for the upgrade. If there are no special instructions given, then follow the standard un-installation and installation procedure. Standard installation procedures leave any EIQ Product Suite deployment configurations untouched.