IBM Netezza SQL toolkit installation walk through

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