Download and Install Netezza SQL Extensions Toolkit

  • Post author:
  • Post last modified:February 28, 2018
  • Post category:Netezza
  • Reading time:4 mins read

The Netezza SQL Extensions toolkit is an optional package that contains additional SQL functions for IBM Netezza data warehouse appliances. The Netezza SQL Extensions toolkit contains various functions and regular expressions that are useful in day to day computations. You can download this package from the IBM site and install to particular database.

Read:

netezza sql extensions

dasdas

Download the Netezza SQL Extensions Toolkit

Login to IBM fix central site given below and download sql-ext-version.tar.gz file.

Download Extension toolkit here

Once the software is downloaded copy that to host by using SCP , or FTP or sftp:

vithal@vithal-Inspiron-3558:~/Downloads$ scp sql-ext-7.2.1.3.tar.gz nz@192.168.0.105:/export/home/nz nz@192.168.0.105’s password: sql-ext-7.2.1.3.tar.gz 100% 5821KB 5.7MB/s 00:01 vithal@vithal-Inspiron-3558:~/Downloads$

Netezza SQL Extensions Toolkit Installation Procedure

Follow the below mentioned steps to install the Netezza SQL Extensions Toolkit once it is copied to Netezza host.

  • Log in to the Netezza system as the nz user
  • Extract the package by issuing tar xvf packagename command. Follow below steps:

[nz@netezza ~]$ tar xvf sql-ext-7.2.1.3.tar.gz
Netezza_sql_toolkit.pdf
sqlext.package.tar.z
SQL_Toolkit_Readme.txt
[nz@netezza ~]$

  • Again extract the package sqlext.package.tar.z by issuing tar xvf packagename command. Follow below steps:

[nz@netezza ~]$ tar xvf sqlext.package.tar.z
libnetcrypto-7.2.1.3.tar.gz
libnetxml-7.2.1.3.tar.gz
[nz@netezza ~]$

The above command extracts two files: libnetcrypto-version.tar.gz and libnetxml-version.tar.gz

[nz@netezza ~]$ tar xvf sqlext.package.tar.z
libnetcrypto-7.2.1.3.tar.gz
libnetxml-7.2.1.3.tar.gz
[nz@netezza ~]$

  • Decompress and extract the software files in the libnetcrypto-version.tar.gz file by issuing the following command: tar xvf libnetcrypto-version.tar.gz

[nz@netezza ~]$ tar xvf libnetcrypto-7.2.1.3.tar.gz
libnetcrypto/
libnetcrypto/7.2.1.3/
libnetcrypto/7.2.1.3/libnetcrypto.o_spu10
libnetcrypto/7.2.1.3/libnetcrypto.o_x86
libnetcrypto/7.2.1.3/install.pm
libnetcrypto/7.2.1.3/install
libnetcrypto/7.2.1.3/README
libnetcrypto/7.2.1.3/licenses/
libnetcrypto/7.2.1.3/licenses/sqlToolkit_licenses.zip
libnetcrypto/7.2.1.3/RELEASE_NOTES
libnetcrypto/7.2.1.3/sqlext-version.txt
libnetcrypto/7.2.1.3/libbotan_host.so
libnetcrypto/7.2.1.3/libbotan_spu.so
libnetcrypto/7.2.1.3/netfpe.o_spu10
libnetcrypto/7.2.1.3/netfpe.o_x86
[nz@netezza ~]$

The command decompresses the contents and extracts them to the libnetcrypto/version directory under the current directory.

  • Decompress and extract the software files in the libnetxml-version.tar.gz file by issuing the following command: tar xvf libnetxml-version.tar.gz

[nz@netezza ~]$ tar xvf libnetxml-7.2.1.3.tar.gz
libnetxml/
libnetxml/7.2.1.3/
libnetxml/7.2.1.3/libnetxml.o_spu10
libnetxml/7.2.1.3/libnetxml.o_x86
libnetxml/7.2.1.3/install.pm
libnetxml/7.2.1.3/install
libnetxml/7.2.1.3/README
libnetxml/7.2.1.3/licenses/
libnetxml/7.2.1.3/licenses/sqlToolkit_licenses.zip
libnetxml/7.2.1.3/RELEASE_NOTES
libnetxml/7.2.1.3/sqlext-version.txt
[nz@netezza ~]$

The command decompresses the contents and extracts them to the libnetxml/version directory under the current directory.

Now we have the required software files. Next step is to install it to particular database.

Install Netezza SQL Extensions Toolkit to Particular Netezza Database

Change directory to dir/libnetcrypto/version, where dir is directory where the files are extracted:

[nz@netezza ~]$ cd libnetcrypto
[nz@netezza libnetcrypto]$ cd 7.2.1.3

Issue following command to install:

[nz@netezza 7.2.1.3]$ ./install -d TEST -u username -W password
Installing libnetcrypto to default schema of database TEST in unfenced mode: ………………………………………….. Done
[nz@netezza 7.2.1.3]$

Change directory to dir/libnetxml/version, where dir is directory where the files are extracted:

[nz@netezza ~]$ cd libnetxml
[nz@netezza libnetxml]$ cd 7.2.1.3

Execute following command to install:

[nz@netezza 7.2.1.3]$ ./install -d SYSTEM
Installing libnetxml to default schema of database SYSTEM in unfenced mode: …………………………………….. Done
[nz@netezza 7.2.1.3]$

 

Tags: , , , ,