Difference between revisions of "Upgrade Testsystem from 743p2 To 743p3"

From Lsdf
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
1. '''Backup db has not been made for the test system, have to be done for productive core'''
 
1. '''Backup db has not been made for the test system, have to be done for productive core'''
  +
1.1 '''Remove /opt/hpss link'''
 
  +
2. '''Remove /opt/hpss link'''
 
rm -f /opt/hpss
 
rm -f /opt/hpss
  +
3. '''Upgrade DBD-DB2'''
2.cd /root/Software/HPSS/Addon_Packages/
 
  +
cd /root/Software/HPSS/Addon_Packages/
 
tar -zxvf DBD-DB2-1.85.tar.gz
 
tar -zxvf DBD-DB2-1.85.tar.gz
 
cd DBD-DB2-1.85
 
cd DBD-DB2-1.85
Line 9: Line 11:
 
make
 
make
 
make install
 
make install
  +
4.'''Install new hpss rpms'''
3.
 
 
rpm -ivh hpss-clnt-7.4.3.3-0.el6.x86_64.rpm hpss-core-7.4.3.3-0.el6.x86_64.rpm hpss-lib-7.4.3.3-0.el6.x86_64.rpm<br>hpss-lib-devel-7.4.3.3-0.el6.x86_64.rpm hpss-mvr-7.4.3.3-0.el6.x86_64.rpm
 
rpm -ivh hpss-clnt-7.4.3.3-0.el6.x86_64.rpm hpss-core-7.4.3.3-0.el6.x86_64.rpm hpss-lib-7.4.3.3-0.el6.x86_64.rpm<br>hpss-lib-devel-7.4.3.3-0.el6.x86_64.rpm hpss-mvr-7.4.3.3-0.el6.x86_64.rpm
 
rpm -Uvh hpss-doc-7.4.3.3-0.el6.x86_64.rpm --force (try --nodeps before)
 
rpm -Uvh hpss-doc-7.4.3.3-0.el6.x86_64.rpm --force (try --nodeps before)
4. ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss
+
5. '''Make now hpss link in /opt'''
  +
ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss
5. su - hpssdb
 
  +
6. '''Start DB2'''
  +
su - hpssdb
 
. /var/hpss/hpssdb/sqllib/db2profile
 
. /var/hpss/hpssdb/sqllib/db2profile
 
db2start
 
db2start
 
exit
 
exit
  +
7. '''Convert'''
6.. /var/hpss/hpssdb/sqllib/db2profile
 
  +
  +
. /var/hpss/hpssdb/sqllib/db2profile
 
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
hpssdb passwd: hpssdb
 
hpssdb passwd: hpssdb
Line 23: Line 29:
 
CFG> convert all
 
CFG> convert all
 
CFG> quit
 
CFG> quit
  +
7. /opt/hpss/bin/hpss_managetables
 
  +
/opt/hpss/bin/hpss_managetables
 
hmt> db subsys1
 
hmt> db subsys1
 
del subsys constraints SSPVHISTORYCON1
 
del subsys constraints SSPVHISTORYCON1
 
hmt> commit
 
hmt> commit
 
hmt> quit
 
hmt> quit
  +
8. /opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
  +
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
cnvt> db subsys1
 
cnvt> db subsys1
 
SUBSYS1> convert all
 
SUBSYS1> convert all
Line 41: Line 49:
 
Conversion Time: 0 minutes 0 seconds
 
Conversion Time: 0 minutes 0 seconds
 
Done
 
Done
 
 
SUBSYS1> state
 
SUBSYS1> state
 
SUBSYS1> quit
 
SUBSYS1> quit
  +
8. /opt/hpss/bin/hpss_managetables
 
  +
/opt/hpss/bin/hpss_managetables
 
hmt> db subsys1
 
hmt> db subsys1
 
hmt> add subsys constraints SSPVHISTORYCON1 (error in the Conversion Guide pag. 170 paragraph 10.6.4)
 
hmt> add subsys constraints SSPVHISTORYCON1 (error in the Conversion Guide pag. 170 paragraph 10.6.4)
Line 50: Line 58:
 
hmt> commit
 
hmt> commit
 
hmt> quit
 
hmt> quit
  +
9. /opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
  +
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
cnvt> db cfg
 
cnvt> db cfg
 
CFG> cleanup all
 
CFG> cleanup all
 
CFG> state
 
CFG> state
 
CFG> quit
 
CFG> quit
  +
10. /opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
  +
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
cnvt> db subsys1
 
cnvt> db subsys1
 
SUBSYS1> cleanup all
 
SUBSYS1> cleanup all
 
SUBSYS1> state
 
SUBSYS1> state
 
SUBSYS1> quit
 
SUBSYS1> quit
  +
11. '''E2EDP and TOR'''
 
  +
8. '''E2EDP and TOR'''
11.1 [root@hpsstcr03 hpss_src]# cat /proc/sys/kernel/randomize_va_space
 
  +
  +
[root@hpsstcr03 hpss_src]# cat /proc/sys/kernel/randomize_va_space
 
0
 
0
   
 
[root@hpsscr sysconfig]# cat /etc/sysctl.conf | grep -i randomize
 
[root@hpsscr sysconfig]# cat /etc/sysctl.conf | grep -i randomize
 
kernel.randomize_va_space = 0
 
kernel.randomize_va_space = 0
  +
11.2 /opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
  +
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
cnvt> db cfg
 
cnvt> db cfg
 
CFG> convert all
 
CFG> convert all
Line 76: Line 89:
 
SUBSYS1> convert all
 
SUBSYS1> convert all
 
SUBSYS1> quit
 
SUBSYS1> quit
  +
 
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
cnvt> db cfg
 
cnvt> db cfg
Line 81: Line 95:
 
CFG> state
 
CFG> state
 
CFG> quit
 
CFG> quit
  +
 
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
 
cnvt> db subsys1
 
cnvt> db subsys1
Line 86: Line 101:
 
SUBSYS1> state
 
SUBSYS1> state
 
SUBSYS1> quit
 
SUBSYS1> quit
12.'''Full db backup (not done on the test system)'''
 
   
  +
9.'''Full db backup (not done on the test system)'''
13. '''Install the new rpm's on all movers and change /opt/hpss link to the new version'''
 
  +
  +
10. '''Install the new rpm's on all movers and change /opt/hpss link to the new version'''

Latest revision as of 18:19, 21 June 2016

1. Backup db has not been made for the test system, have to be done for productive core

2. Remove /opt/hpss link

rm -f /opt/hpss

3. Upgrade DBD-DB2

cd /root/Software/HPSS/Addon_Packages/
tar -zxvf DBD-DB2-1.85.tar.gz
cd DBD-DB2-1.85
. /var/hpss/hpssdb/sqllib/db2profile
perl Makefile.PL
make
make install

4.Install new hpss rpms

rpm -ivh hpss-clnt-7.4.3.3-0.el6.x86_64.rpm hpss-core-7.4.3.3-0.el6.x86_64.rpm hpss-lib-7.4.3.3-0.el6.x86_64.rpm
hpss-lib-devel-7.4.3.3-0.el6.x86_64.rpm hpss-mvr-7.4.3.3-0.el6.x86_64.rpm rpm -Uvh hpss-doc-7.4.3.3-0.el6.x86_64.rpm --force (try --nodeps before)

5. Make now hpss link in /opt

ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss

6. Start DB2

su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
db2start
exit

7. Convert

. /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
hpssdb passwd: hpssdb
cnvt> db cfg
CFG> convert all
CFG> quit
/opt/hpss/bin/hpss_managetables
hmt> db subsys1
del subsys constraints SSPVHISTORYCON1
hmt> commit
hmt> quit
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
SUBSYS1> convert all 
Converting NSTRASH...
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0624N  Table "HPSS.NSTRASH" already has a primary key or unique constraint 
using the specified columns and periods.  SQLSTATE=42889
Conversion Time: 0 minutes 0 seconds
Done
Converting MPSFORCEMIGRATE...
Conversion Time: 0 minutes 0 seconds
Done
SUBSYS1> state
SUBSYS1> quit
/opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> add subsys constraints SSPVHISTORYCON1 (error in the Conversion Guide pag. 170 paragraph 10.6.4)
hmt> add subsys constraints NSOBJECTUSERATTRS1 (typo error in the Conversion Guide)
hmt> commit
hmt> quit
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db cfg
CFG> cleanup all
CFG> state
CFG> quit
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
SUBSYS1> cleanup all
SUBSYS1> state
SUBSYS1> quit

8. E2EDP and TOR

[root@hpsstcr03 hpss_src]# cat /proc/sys/kernel/randomize_va_space 
0
[root@hpsscr sysconfig]# cat /etc/sysctl.conf | grep -i randomize
kernel.randomize_va_space = 0
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
cnvt> db cfg
CFG> convert all
CFG> state
CFG> quit
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
cnvt> db subsys1
SUBSYS1> convert all
SUBSYS1> quit
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
cnvt> db cfg
CFG> cleanup all
CFG> state
CFG> quit
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
cnvt> db subsys1
SUBSYS1> cleanup all
SUBSYS1> state
SUBSYS1> quit

9.Full db backup (not done on the test system)

10. Install the new rpm's on all movers and change /opt/hpss link to the new version