Skip to content

Archive for

How to increase Max connection limit – Netezza

To change to the parameter startup.maxConnections, please note that downtime is required.

1) Check the setting prior to change:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections =

2) Modify this line in the /nz/data/config/system.cfg file:
startup.maxConnections = 1000

* If the file is absent, you can create it as a new file and append the line into it.

3) Restart using ‘nzstop’ and ‘nzstart’

4) Check again to see if the setting has changed:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections = 1000

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