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

From Lsdf
(Created page with "1. backup db !!! did not made for the test system 1.1 remove /op/hpss link rm -f /opt/hpss 2.cd /root/Software/HPSS/Addon_Packages/ tar -zxvf DBD-DB2-1.85.tar.gz cd DBD-DB2-1...")
 
Line 1: Line 1:
1. backup db !!! did not made for the test system
+
1. '''Backup db has not been made for the test system, have to be done for productive core'''
1.1 remove /op/hpss link
+
1.1 '''Remove /opt/hpss link'''
rm -f /opt/hpss
+
rm -f /opt/hpss
 
2.cd /root/Software/HPSS/Addon_Packages/
 
2.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
. /var/hpss/hpssdb/sqllib/db2profile
+
. /var/hpss/hpssdb/sqllib/db2profile
perl Makefile.PL
+
perl Makefile.PL
make
+
make
 
make install
 
make install
 
3.
 
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 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
 
4. ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss
 
5. su - hpssdb
 
5. su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
+
. /var/hpss/hpssdb/sqllib/db2profile
db2start
+
db2start
exit
+
exit
 
6.. /var/hpss/hpssdb/sqllib/db2profile
 
6.. /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
cnvt> db cfg
+
cnvt> db cfg
CFG> convert all
+
CFG> convert all
CFG> quit
+
CFG> quit
 
7. /opt/hpss/bin/hpss_managetables
 
7. /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
 
8. /opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
+
cnvt> db subsys1
SUBSYS1> convert all
+
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
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
 
 
8. /opt/hpss/bin/hpss_managetables
 
8. /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)
hmt> add subsys constraints NSOBJECTUSERATTRS1 (typo error in the Conversion Guide)
+
hmt> add subsys constraints NSOBJECTUSERATTRS1 (typo error in the Conversion Guide)
hmt> commit
+
hmt> commit
hmt> quit
+
hmt> quit
 
9. /opt/hpss/tools/convert743/hpss/hpss_convertdb743
 
9. /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
 
10. /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
+
11. '''E2EDP and TOR'''
11.1 [root@hpsstcr03 hpss_src]# cat /proc/sys/kernel/randomize_va_space
+
11.1 [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
+
11.2 /opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi
cnvt> db cfg
+
cnvt> db cfg
CFG> convert all
+
CFG> convert all
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
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
CFG> cleanup all
+
CFG> cleanup all
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
SUBSYS1> cleanup all
+
SUBSYS1> cleanup all
SUBSYS1> state
+
SUBSYS1> state
SUBSYS1> quit
+
SUBSYS1> quit
12. full db backup (not done on the test system)
+
12.'''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
+
13. '''Install the new rpm's on all movers and change /opt/hpss link to the new version'''

Revision as of 17:51, 21 June 2016

1. Backup db has not been made for the test system, have to be done for productive core 1.1 Remove /opt/hpss link

rm -f /opt/hpss

2.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

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

4. ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss 5. su - hpssdb

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

6.. /var/hpss/hpssdb/sqllib/db2profile

/opt/hpss/tools/convert743/hpss/hpss_convertdb743
hpssdb passwd: hpssdb
cnvt> db cfg
CFG> convert all
CFG> quit

7. /opt/hpss/bin/hpss_managetables

hmt> db subsys1
del subsys constraints SSPVHISTORYCON1
hmt> commit
hmt> quit

8. /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

8. /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

9. /opt/hpss/tools/convert743/hpss/hpss_convertdb743

cnvt> db cfg
CFG> cleanup all
CFG> state
CFG> quit

10. /opt/hpss/tools/convert743/hpss/hpss_convertdb743

cnvt> db subsys1
SUBSYS1> cleanup all
SUBSYS1> state
SUBSYS1> quit

11. E2EDP and TOR

11.1 [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
11.2 /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

12.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