Skip to content

Posts from the ‘KnowledgeBase’ Category

How to check when was the last time any local user password was changed in Unix?

How to check when was the last time any local user password was changed in Unix?

When ever any local user account password is changed the file /etc/shadow is updated.
So, if you want to check when was the last time any local user password was changed then just run:

[root@TestServer ~]# ls -lrt /etc/shadow
-r——– 1 root root 1035 Oct 11 11:11 /etc/shadow

From above output, its clear that last time any local user password was changed was on 11th Oct of this year.

For example, if you want to see when was the last time root user password was changed, just run below command:

[root@TestServer ~]# chage -l root
Last password change : Oct 11, 2016
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : -1
Maximum number of days between password change : -1
Number of days of warning before password expires : -1

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