Installation of the SQL Extensions or COMMON_DB Toolkit on IBM Netezza

Installation of the SQL Extensions or COMMON_DB Toolkit on IBM Netezza

Login as nz user

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ pwd

/export/home/nz/SQLExtn/

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ ls -lrt

total 4568

-rwxrwxr-x 1 nz nz 4.7M Feb 23 11:04 sql-ext-7.2.0.5.tar.gz*

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ tar -zxvf sql-ext-7.2.0.5.tar.gz*

Netezza_sql_toolkit.pdf

sqlext.package.tar.z

SQL_Toolkit_Readme.txt

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ ls

Netezza_sql_toolkit.pdf  sql-ext-7.2.0.5.tar.gz  sqlext.package.tar.z  SQL_Toolkit_Readme.txt

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ tar -zxf sql-ext-7.2.0.5.tar.gz

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ tar -zxf sqlext.package.tar.z

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ ls

libnetcrypto-1.6.P-1.tar.gz  Netezza_sql_toolkit.pdf  sqlext.package.tar.z

libnetxml-7.2.0.5.tar.gz sql-ext-7.2.0.5.tar.gz     SQL_Toolkit_Readme.txt

And again to get to the libnet libraries.

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ tar -zxf libnetcrypto-7.2.0.5.tar.gz

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ tar -zxf libnetxml-7.2.0.5.tar.gz

[nz@edw-ntz-0a1-lq SQLExtn]$ ls

libnetcrypto/                libnetxml/                Netezza_sql_toolkit.pdf  sqlext.package.tar    SQL_Toolkit_Readme.txt

libnetcrypto-7.2.0.5.tar.gz  libnetxml-7.2.0.5.tar.gz  sql-ext-7.2.0.5.tar.gz*  sqlext.package.tar.z

[nz@nz@edw-ntz-0a1-lq SQLExtn]$ cd libnetcrypto/7.2.0.5/

[nz@nz@edw-ntz-0a1-lq 7.2.0.5/]$ ls

install*    libbotan_host.so*  libnetcrypto.o_spu10  licenses/       netfpe.o_x86*  RELEASE_NOTES

install.pm  libbotan_spu.so*   libnetcrypto.o_x86*   netfpe.o_spu10  README         sqlext-version.txt

You can ask the installer for help.

[nz@nz@edw-ntz-0a1-lq 7.2.0.5]$ ./install -h

Usage: install [options]

Options:

    -db|-D   :  Specify the database to install the toolkit

    -user|-U   :  Specify the Userid used to connect to the database

                          (default: admin)

    -pw|-W   :  Specify the Password used to connect to the database

    -fenced            :  Install the library in fenced mode on release 6.x

                          (default: unfenced)

    -uninstall|-R      :  Uninstall the library

    -verbose|-V        :  Verbose messages during installation / uninstallation

    -schema|-S         :  Specify the Schema Name to install the toolkit

           

Here’s our database.

[nz@clvs1001 sqlext]$ nz_get_database_name SQLEXTN

SQLEXTN

Now to install libnetcrypto.

[nz@nz@edw-ntz-0a1-lq 7.2.0.5]$./install -d SQLEXTN

Installing libnetcrypto to default schema of database SQLEXTN in unfenced mode: .................................................. Done

And Now libnetxml

[nz@clvs1001 7.2.0.5]$ cd ../../libnetxml/7.2.0.5/

[nz@clvs1001 7.2.0.5]$ ./install -d SQLEXTN

Installing libnetxml to default schema of database SQLEXTN in unfenced mode: ............................................ Done

Always  Remember to update any existing synonyms and create new ones for database’s which are going to use the functions.

select distinct 'create synonym '||function||' for SQLEXTN.'||owner||'.'||function||';' from _v_function where builtin = 'f';

select distinct 'create synonym '||aggregate||' for SQLEXTN.'||owner||'.'||aggregate||';' from _v_aggregate where builtin = 'f';

And to confirm the version.

[nz@edw-ntz-0a1-lq 7.2.0.5]$ nzsql -d SQLEXTN

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

SQLEXTN.ADMIN(ADMIN)=> SELECT regexp_version();

                                    REGEXP_VERSION

--------------------------------------------------------------------------------------

 IBM Netezza SQL Extensions XML / Regular Expression Library Version 7.2.0.5 Build ()

(1 row)

SQLEXTN.ADMIN(ADMIN)=>