Skip to content

Posts from the ‘KnowledgeBase’ Category

How to install IBM Netezza Analytics version 3.2.2 on Netezza appliance?

Before you proceed, make sure you are logged in as nz and also backup inza, nza, nzm, nzrc and nzr databases if already have lower version of IBM Netezza Analytics. If older version of Analytics is there on the system then the installer will drop all the above mentioned databases and will recreate as per new version.

NOTE: Below steps are how you will be prompted by installer when you do a brand new installation and not an upgrade.

1) Here is the installer file that we get from IBM fix central.

/nzscratch/SQL_Analytics->ls
nz-analytics-v3.2.2.zip
nz-analyticsdoc-v3.2.2.zip

2) Unzip the installer package using unzip command.

/nzscratch/SQL_Analytics->unzip nz-analytics-v3.2.2.zip
Archive: nz-analytics-v3.2.2.zip
extracting: inza-3.2.2.zip
inflating: inzaPackageInstaller.sh
inflating: verifyNpsVersion

3) After extract you will see below files.

/nzscratch/SQL_Analytics->ls
verifyNpsVersion*
inzaPackageInstaller.sh*
inza-3.2.2.zip
nz-analytics-v3.2.2.zip
nz-analyticsdoc-v3.2.2.zip

4) Now start installation by running below script and follow the prompts.

a) /nzscratch/SQL_Analytics->./inzaPackageInstaller.sh

b) Do you want to install the Netezza Analytics packages? (y/n): y

c) Do you want to install the documentation packages? (y/n): y

d) Confirm that the following packages should be installed.
1) Netezza Analytics package: YES
2) Netezza Analytics Documentation package: YES
Do you want to install the above selections?
Enter “y” to continue, “x” to exit
or any other key to be prompted to modify your selection: y

e) Installing Netezza Analytics packages…
Available compressed installation file or files:
[0] /nzscratch/SQL_Analytics/inza-3.2.2.zip
[1] A compressed file in a different directory or with a non-standard name.

Enter your selection: 0

f) Please enter the name or full path of the zipped Documentation file: /nzscratch/SQL_Analytics/nz-analyticsdoc-v3.2.2.zip

f) Do you want to run the Netezza Analytics cartridge installer now? (y/n): y

NOTE: Below step will run for around 30 minutes.
g) Do you want to do an Express (e) installation or a Custom (c) installation (e/c): e

Confirm that the following components should be installed.
1) MapReduce: YES
2) Matrix: YES
3) IBM Netezza In-database Analytics: YES
4) Spatial: YES (ESRI)
Do you want to install the selected components?
Enter “y” to continue, “x” to exit
or any other key to be prompted to change your selection: y

NOTE:
You may see messages like below. These messages can be ignored.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzudxcompile line 804.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzudxcompile line 893.

h) Would you like to re-enable all databases that are enabled for IBM Netezza Analytics? (y/n): y

i) There are no databases that are enabled for IBM Netezza Analytics.

j) Would you like to update all spatial databases that already have spatial registered with the current version? (y/n): y

5) Below command needs to run or retsrat your bash session to reflect all changes made during IBM Netezza Analytics installation

source ~/.bashrc

How to install IBM Fluid Query?

In this article we will be installing IBM FLuid query version 1.7

Please note: Before you try to install Fluid Query make sure IBM Netezza Analytics is installed on this system.

To check if IBM Netezza Analytics is installed and the current version, just run below query.

nzsql inza -c “select * from product”
NAME | SHORTNAME | VERSION | INSTALLED
———————–+———–+————-+————
IBM Netezza Analytics | INZA | 3.2.2.47943 | 2016-01-21

Now, follow below steps to install FLuid Query:

1) Login to Netezza appliance as nz user.

2) Make sure that you have Fluid query installer filed downloaded from fix central.

/nzscratch/Fluid_Query->ls
nz-fluidquery-v1.7.tar.gz

3) Extract the installer package using gunzip command.

gunzip nz-fluidquery-v1.7.tar.gz

4) You have below files after gunzip

/nzscratch/Fluid_Query->ls
nz-fluidquery-v1.7.tar

5) Now extract the tar file.

/nzscratch/Fluid_Query->tar xvf nz-fluidquery-v1.7.tar

6) You will see below files/folders after extracting the tar file.

/nzscratch/Fluid_Query->ls
fluid-query-import-export-v1.7.0.0.tar
fluidquery_install.sh*
fluid-query-sql-v1.7.0.0.tar
license/
nz-fluidquery-v1.7.tar

7) Now run installer using the comand ./fluidquery_install.sh . Install will complete in seconds.

——————————————————————————-
IBM Fluid Query Installer
(C) Copyright IBM Corp. 2015, 2016. All rights reserved.
Version 1.7.0.0 [Build 160420-201]
——————————————————————————-
Installing connector…
Checking if IBM Netezza Analytics is installed…
IBM Netezza Analytics is already installed. Ok.
Checking if IBM Netezza Analytics cartridge is installed…
IBM Netezza Analytics cartridge is already installed. Ok.
Checking for previous installation of IBM Fluid Query…
Previous installation of IBM Fluid Query does not exists in /nz/export/ae/products/fluidquery…
Extracting package to /nz/export/ae/products/fluidquery…
Copying license to /opt/nz/licenses/ifq…
Copying uninstaller to /nz/export/ae/products/fluidquery…
WARNING: Unable to register IFQAdmin. Try to execute “/nz/export/ae/products/fluidquery/fqRegister.sh –admin”
Installation successful! Package installed in /nz/export/ae/products/fluidquery
For details see the log file at /nz/var/log/fluidquery_install/fluidquery_install.2016-05-26.09:46:11.log