Monday, December 15, 2014

Netezza upgrade from 702 to 7.0.2.14


1.get the below pulgins and place it under the dir

z@server_name tmp]$ cd /nz/kit/share/upgrade/plugins/nz/Plugin/
[nz@server_name Plugin]$ clear
[nz@server_name Plugin]$ ls -ltr

[root@server_name ~]# service drbd status
drbd driver loaded OK; device status:
version: 8.2.6 (api:88/proto:86-88)
GIT-hash: 3e69822d3bb4920a8c1bfdf7d647169eba7d2eb4 build by root@nps22094, 2010-11-18 14:52:01
m:res  cs         st                 ds                 p  mounted       fstype
0:r1   Connected  Primary/Secondary  UpToDate/UpToDate  C  /export/home  ext3
1:r0   Connected  Primary/Secondary  UpToDate/UpToDate  C  /nz           ext3
[root@server_name ~]# ssh ha2 service drbd status
drbd driver loaded OK; device status:
version: 8.2.6 (api:88/proto:86-88)
GIT-hash: 3e69822d3bb4920a8c1bfdf7d647169eba7d2eb4 build by root@nps22094, 2010-11-18 14:52:01
m:res  cs         st                 ds                 p  mounted  fstype
0:r1   Connected  Secondary/Primary  UpToDate/UpToDate  C
1:r0   Connected  Secondary/Primary  UpToDate/UpToDate  C
[root@server_name ~]# head -n 25 /etc/hosts

2.stop/start the NPS

w-r--r-- 1 nz   nz   13953 Dec 13 09:09 SetDefSchema.pm
-rw-r--r-- 1 root root 17345 Dec 13 09:09 CheckReplication.pm
[nz@server_name Plugin]$
[nz@server_name Plugin]$
[nz@server_name Plugin]$ nzrev
Release 7.0.2 (P-8) [Build 32960]
[nz@server_name Plugin]$ nzstate
System state is 'Stopped'.
[nz@server_name Plugin]$
[nz@server_name Plugin]$ nzstart
Updating '/nz/data.1.0/kit' ...

(startupsvr) Info: NZ-00022: --- program 'startupsvr' (28177) starting on host 'server_name' ... ---
[nz@server_name Plugin]$ clear
[nz@server_name Plugin]$


3.do the pre-upgrade check


[root@server_name upgrade]# wget https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04vtr/0/Xa.2/Xb.jusyLTSp44S03sPozQAzX2GfBoWlywJNOUH2OSyo/Xc.CM/IM/04vtr/0/nz-nps-v7.0.2.14-P2.tar.gz/Xd./Xf.Lpr./Xg.7883631/Xi.habanero/XY.habanero/XZ.E95gizBav5h64nSQSB.0.2.14-P2.tar.gz
--2014-12-13 09:51:44--  https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04vtr/0/Xa.2/Xb.jusyLTSp44S03sPozQAzX2GfBoWlyvt75UH2OSyo/Xc.CM/IM/04vtr/0/nz-nps-v7.0.2.14-P2.tar.gz/Xd./Xf.Lpr./Xg.7883631/Xi.habanero/XY.habanero/XZ.E95gizBav5h64nSQSBmTD1.14-P2.tar.gz
Resolving delivery04.dhe.ibm.com... 170.225.15.105
Connecting to delivery04.dhe.ibm.com|170.225.15.105|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1332315118 (1.2G) [application/octet-stream]
Saving to: `nz-nps-v7.0.2.14-P2.tar.gz'

100%[===================================================================================================>] 1,332,315,118 7.4

2014-12-13 09:54:18 (8.34 MB/s) - `nz-nps-v7.0.2.14-P2.tar.gz' saved [1332315118/1332315118]

[root@server_name upgrade]# clear
[root@server_name upgrade]# ls -ltr
total 1371924
-rwxr-xr-x 1 nz   nz         2353 Apr 18  2012 check_hba.sh
-rw-r--r-- 1 nz   nz      2146836 Apr 23  2012 asu.tgz
-rwxr-xr-x 1 nz   nz          789 Sep 27  2012 check_CBT.sh
-rwxr-xr-x 1 nz   nz       244230 May  7  2013 disk_monitor.nps70
-rw-r--r-- 1 root root    2202835 May  7  2013 check_scripts.tgz
-rwxr-xr-x 1 nz   nz        39107 May 24  2013 upgrade_tools
-rwxr--r-- 1 nz   nz         9023 Sep 17  2013 SetDefSchema.pm
-rw-r--r-- 1 nz   nz         5719 Sep 17  2013 CheckReplication.pm
-rw-r--r-- 1 root root    2214752 Sep 30  2013 upgrade_tools_1.9.tgz
-rw-r--r-- 1 root root        556 Sep 30  2013 nzupgrade.ssh.lock
-rwxr-xr-x 1 root root      18367 Sep 30  2013 check_root.sh
drwxr-xr-x 3 nz   nz         4096 Sep 30  2013 log
-rw-r--r-- 1 root root        603 Sep 30  2013 badViews.sql
drwxr-xr-x 6 root root       4096 Oct  4  2013 FDT
-rw------- 1 nz   nz     64193106 Oct  4  2013 server_name.backup.10042013.tgz
drwxr-xr-x 3 root root       4096 Oct  4  2013 HPF
drwxr-xr-x 2 root root       4096 Oct  4  2013 bios
drwxr-xr-x 6 root root       4096 Oct  4  2013 service_tools
drwxr-xr-x 3 root root       4096 Oct  4  2013 hwtools
drwxr-xr-x 3 nz   nz         4096 Oct  4  2013 swtools
-rw-r--r-- 1 root root 1332315118 Nov  4 15:39 nz-nps-v7.0.2.14-P2.tar.gz
[root@server_name upgrade]# tar -zxvf nz-nps-v7.0.2.14-P2.tar.gz
npsos.7.0.2.14-P2.tar.gz
unpack
[root@server_name upgrade]# ./unpack
-------------------------------------------------------------------------------
IBM Netezza -- Netezza Platform Software 7.0.2.14-P2
(C) Copyright IBM Corp. 2002, 2014  All Rights Reserved.
-------------------------------------------------------------------------------

Validating package checksum ... ok

Where should the Netezza Platform Software be unpacked? [/nz]

 0%          25%         50%         75%          100%
 |||||||||||||||||||||||||||||||||||||||||||||||||||

You can check the system to prepare for an upgrade with:
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade check

You can start the upgrade (which also checks the system) with (as root):
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade upgrade

Unpacking complete.
[root@server_name upgrade]# /nz/kit.7.0.2.14-P2/sbin/nzupgrade check
-------------------------------------------------------------------------------
IBM Netezza -- Netezza Platform Software
(C) Copyright IBM Corp. 2002, 2014  All rights reserved.
-------------------------------------------------------------------------------

Logfile: /nz/var/log/upgrade.20141213.7.0.2.14-P2.check

Checking the system for validity...

Checking HPF health ... ok

---------------------------------------------------------------
IBM Netezza Model:  IBM PureData System for Analytics N1001-005
FDT version:        2.6.1
HPF version:        5.3
---------------------------------------------------------------

System checks succeeded.

You can upgrade your system with:
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade  upgrade


Logfile: /nz/var/log/upgrade.20141213.7.0.2.14-P2.check.gz
[root@server_name upgrade]# clear
[root@server_name upgrade]# screen

SYSTEM(ADMIN)=> \q
[nz@server_name ~]$ nzsql
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

SYSTEM(ADMIN)=> show history configuration all;
 CONFIG_NAME | CONFIG_DBNAME | CONFIG_DBTYPE | CONFIG_TARGETTYPE | CONFIG_LEVEL | CONFIG_HOSTNAME | CONFIG_USER | CONFIG_PASSWORD | CONFIG_LOADINTERVAL | CONFIG_LOADMINTHRESHOLD | CONFIG_LOADMAXTHRESHOLD | CONFIG_DISKFULLTHRESHOLD | CONFIG_STORAGELIMIT | CONFIG_LOADRETRY | CONFIG_ENABLEHIST | CONFIG_ENABLESYSTEM | CONFIG_NEXT | CONFIG_CURRENT | CONFIG_VERSION | CONFIG_COLLECTFILTER | CONFIG_KEYSTORE_ID | CONFIG_KEY_ID | KEYSTORE_NAME | KEY_ALIAS | CONFIG_NAME_DELIMITED | CONFIG_DBNAME_DELIMITED | CONFIG_USER_DELIMITED
-------------+---------------+---------------+-------------------+--------------+-----------------+-------------+-----------------+---------------------+-------------------------+-------------------------+--------------------------+---------------------+------------------+-------------------+---------------------+-------------+----------------+----------------+----------------------+--------------------+---------------+---------------+-----------+-----------------------+-------------------------+-----------------------
(0 rows)

SYSTEM(ADMIN)=>


No comments:

Post a Comment