View source for hidden:Upgrade Test System from 7.4.3p2 to 7.4.3p3

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<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)
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'''