IBM Support

How do we update the QualityStage AVI stage with the quarterly reference data?

Question & Answer


Question

How do we update the QualityStage AVI stage with the quarterly reference data?

Cause

Each quarter, the AVI reference data files and the AVI module are updated. To ensure you have the most up to date information, both components must be updated. See this technote for the latest part numbers. 

The reference file update are full refreshes of the database.

There are 3 types of reference files:

  • Parsing Reference Data
  • Address Reference Data (includes Parsing Reference Data)
  • Address and Geo Reference Data (includes Address Reference Data and Parsing Data)

Answer

1. Download the following items from passport advantage
-Reference Data
-Address Verification Interface Reference Data Install Manager
-Interface Quarterly Update

2. Download the following from Fix central
-latest update installer for Information Server

3. Prepare for the install

Ensure there is at least 50GB of free space on the server

Create a target directory for the loqate data
/opt/loqate/data

Extract the contents of the reference database to
/tmp/AVIDB

4. Run the install manager.

This step installs the reference database. the Install Manager script may be called IBM_InstallManager.sh or InstallManager.sh. Use the name that matches your package.

From the directory that the install manager was extracted to, run the following:

./IBM_InstallManager.sh

Here is the first prompt

Native library STLPort failed to load, ignore this if not using solaris OS.
java.lang.UnsatisfiedLinkError: no stlport in java.library.path
Welcome to the Installation Manager - version 8.0.0
Running using local API version 2.19.0.8463
Data Installation folder provided is: .
Do you want to change the path? (Y/n)
Y

Respond "Y" to change the directory.  If you do not enter "Y", the installer places the files into the current directory (“.”)

Please enter a valid data installation folder path:

/opt/loqate/data


Valid folder found. Proceeding with a data installation.
Data packs folder provided is: .
Do you want to change the path? (Y/n)

Y

Please enter a valid download folder path:
/tmp/AVIDB/<partname>

The installer reads the directory and reports back with the data available for update

Processing.
------------------------------------------------------
S.No Product Date of Release
------------------------------------------------------
1 General 2016-05-11
2 Netherlands Verify 2016-05-11
------------------------------------------------------
Enter : 1 to install the first Product, 2 to install the second Product and so on
Enter : all if all products are to be installed
Enter : done to complete the selection of products
Enter your selection:

Type “all”


Please enter again the destination directory:

Enter the destination directory a second time "/opt/loqate/data"

The reference data installation is complete


5. Update the AVI stage

The final step is to install the quarterly update for the AVI module. This file has the ispkg extension
Follow these steps for updating a package

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m50000000L13TAAS","label":"QualityStage-\u003EAddress Verification Interface - AVI"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0;11.7.0;11.7.1"}]

Document Information

Modified date:
18 August 2023

UID

swg21991915