Before a QKB can be deployed in the Teradata
database, you must package it into an .rpm file. An .rpm file is a
file that is suitable for installation on Linux systems that use RPM
package management software. SAS Data Quality Accelerator for Teradata
provides the qkb_pack script to package the QKB into an .rpm file.
Windows and UNIX versions
of qkb_pack are available. You must run the version that is appropriate
for the host environment in which your QKB is installed.
qkb_pack is created
in the following directories by the SAS Deployment Wizard:
Windows
<SASHome>\SASDataQualityAcceleratorforTeradata\9.4\dqacctera\sasmisc
UNIX
<SASHome>/SASDataQualityAcceleratorforTeradata/9.4/install/pgm
You must execute qkb_pack
from the <SASHome> location.
Here is the syntax for
executing qkb_pack:
Windows:
qkb_pack.cmd qkb-dir out-dir
UNIX:
./qkb_pack.sh qkb-dir out-dir
qkb-dir
specify the path to
the QKB. Use the name of the QKB’s root directory. Typically,
the root directory is found at the following directories:
| Windows: |
C:\ProgramData\SAS\SASQualityKnowledgeBase\product-identifier\product-version (for
example, C:\ProgramData\SAS\SASQualityKnowledgeBase\CI\27 or C:\ProgramData\SAS\SASQualityKnowledgeBase\PD\5).
|
| UNIX: |
/opt/sas/qkb/share |
Note: On Windows systems, QKB information
exists in two locations: in C:\ProgramData and
in C:\Program Files. For the qkb_pack
command, you must specify the C:\ProgramData location.
out-dir
specify the directory
where you want the package file to be created.
Here is an example of
a command that you might execute to package a SAS QKB for Contact
Information that resides on a Windows computer.
cd c:\Program Files\SASHome\SASDataQualityAcceleratorforTeradata\9.4\dqacctera\sasmisc
qkb_pack.cmd c:\ProgramData\SAS\QKB\CI\27 c:\temp\
The default location
for the qkb-dir argument is: C:\ProgramData\SAS\SASQualityKnowledgeBase\CI\27.
The package file that
is created in C:\temp\ will have a name in the following form:
sasqkb_product-version-timestamp.noarch.rpm
product
is a two-character
product code for the QKB, such as CI (for Contact Information) or
PD (for Product Data).
version
is the version number
of the QKB.
timestamp
is a UNIX datetime
value that indicates when qkb_pack was invoked. A UNIX datetime value
is stored as the number of seconds since January 1, 1970.
noarch
indicates that the
package file is platform-independent.
Here is an example of
an output filename representing the QKB for Contact Information 27:
sasqkb_ci-27.0-1474057340608.noarch.rpm
After running qkb_pack,
put the sasqkb package file on your Teradata database server in a
location where it is available for both reading and writing. The package
file must be readable by the Teradata Parallel Upgrade Tool. You need
to move this package file to the server machine in accordance with
procedures used at your site.