Before a QKB can be deployed in the Teradata
database, you must package it into a .rpm file. A .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 a .rpm.
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\2.7\dqacctera\sasmisc
UNIX
<SASHome>/SASDataQualityAcceleratorforTeradata/2.7/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 locations:
| Windows 7/Windows 8: |
C:\ProgramData\SAS\QKB\product\version |
| UNIX: |
/opt/sas/qkb/share |
Note: On Windows systems, QKB information
exists in two locations: in C:\Program Data and
in C:\Program Files. For the qkb_pack
command, you must specify the C:\Program Data location.
out-dir
specify the directory
where you want the package file to be created.
Here’s 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\2.7\dqacctera\sasmisc
qkb_pack.cmd c:\ProgramData\SAS\SASQualityKnowledgeBase\CI\25 c:\temp\
The package file that
is created in C:\temp\ will have a name in the 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 the package
file is platform-independent.
Here is an example of
an output filename representing the QKB for Contact Information 25:
sasqkb_ci-25.0-1367606747659.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.