IBM Netezza SQL toolkit installation walk through (documentation Version 7.2)
Download installation package at https://www-945.ibm.com/support/fixcentral/
1) Create target database where SQL Tooklit to install into:
nzsql -u ADMIN -pw 'XXXX' -c "create database SQLX";
2) Create installation directory where the executable files will be installed:
mkdir /export/home/nz/sqlext
3) Untar installation bundle:
tar xvf sql-ext-7.2.1.1.tar.gz
[nz@server tmp]$ tar xvf sql-ext-7.2.1.1.tar.gz
Netezza_sql_toolkit.pdf
sqlext.package.tar.z
SQL_Toolkit_Readme.txt
[nz@sdw1 tmp]$ ll
total 11776
-rw-r--r-- 1 nz nz 1801793 Feb 4 23:28 Netezza_sql_toolkit.pdf
-rw-rw-r-- 1 nz nz 5960751 Jun 28 14:19 sql-ext-7.2.1.1.tar.gz
-rw-r--r-- 1 nz nz 4247503 Feb 4 23:28 sqlext.package.tar.z
-rw-r--r-- 1 nz nz 13690 Feb 4 23:28 SQL_Toolkit_Readme.txt
4) Untar installation package:
tar xvf sqlext.package.tar.z
[nz@server tmp]$ tar xvf sqlext.package.tar.z
libnetcrypto-7.2.1.1.tar.gz
libnetxml-7.2.1.1.tar.gz
[nz@sdw1 tmp]$ ll
total 15968
-rw-r--r-- 1 nz nz 3244116 Feb 4 16:56 libnetcrypto-7.2.1.1.tar.gz
-rw-r--r-- 1 nz nz 1034755 Feb 4 16:57 libnetxml-7.2.1.1.tar.gz
-rw-r--r-- 1 nz nz 1801793 Feb 4 23:28 Netezza_sql_toolkit.pdf
-rw-rw-r-- 1 nz nz 5960751 Jun 28 14:19 sql-ext-7.2.1.1.tar.gz
-rw-r--r-- 1 nz nz 4247503 Feb 4 23:28 sqlext.package.tar.z
-rw-r--r-- 1 nz nz 13690 Feb 4 23:28 SQL_Toolkit_Readme.txt
5) Untar installer for libnetcrypto:
tar xvf libnetcrypto-7.2.1.1.tar.gz
[nz@server tmp]$ tar xvf libnetcrypto-7.2.1.1.tar.gz
libnetcrypto/
libnetcrypto/7.2.1.1/
libnetcrypto/7.2.1.1/libnetcrypto.o_spu10
libnetcrypto/7.2.1.1/libnetcrypto.o_x86
libnetcrypto/7.2.1.1/install.pm
libnetcrypto/7.2.1.1/install
libnetcrypto/7.2.1.1/README
libnetcrypto/7.2.1.1/licenses/
libnetcrypto/7.2.1.1/licenses/sqlToolkit_licenses.zip
libnetcrypto/7.2.1.1/RELEASE_NOTES
libnetcrypto/7.2.1.1/sqlext-version.txt
libnetcrypto/7.2.1.1/libbotan_host.so
libnetcrypto/7.2.1.1/libbotan_spu.so
libnetcrypto/7.2.1.1/netfpe.o_spu10
libnetcrypto/7.2.1.1/netfpe.o_x86
6) Untar installer for libnetxml:
tar xvf libnetxml-7.2.1.1.tar.gz
[nz@server tmp]$ tar xvf libnetxml-7.2.1.1.tar.gz
libnetxml/
libnetxml/7.2.1.1/
libnetxml/7.2.1.1/libnetxml.o_spu10
libnetxml/7.2.1.1/libnetxml.o_x86
libnetxml/7.2.1.1/install.pm
libnetxml/7.2.1.1/install
libnetxml/7.2.1.1/README
libnetxml/7.2.1.1/licenses/
libnetxml/7.2.1.1/licenses/sqlToolkit_licenses.zip
libnetxml/7.2.1.1/RELEASE_NOTES
libnetxml/7.2.1.1/sqlext-version.txt
7) Install packages into target SQLX database:
cd /export/home/nz/sqlext/libnetcrypto/7.2.1.1
./install -db SQLX -u ADMIN -pw 'XXXX'
cd /export/home/nz/sqlext/libnetxml/7.2.1.1
./install -db SQLX -u ADMIN -pw 'XXXX'
8) Test and verification:
[nz@server 7.2.1.1]$ nzsql -db SQLX -u ADMIN -pw 'XXXX'
Welcome to nzsql, the IBM Netezza SQL interactive terminal.
Type: \h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
SQLX.ADMIN(ADMIN)=> SELECT CRYPTO_VERSION();
CRYPTO_VERSION
--------------------------------------------------------------------
IBM Netezza SQL Extensions Crypto Library Version 7.2.1.1 Build ()
(1 row)
SQLX.ADMIN(ADMIN)=> SELECT REGEXP_VERSION();
REGEXP_VERSION
--------------------------------------------------------------------------------------
IBM Netezza SQL Extensions XML / Regular Expression Library Version 7.2.1.1 Build ()
(1 row)
Done
