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. |
+ | 1. '''Backup db has not been made for the test system, have to be done for productive core''' |
− | 1.1 |
+ | 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 |
+ | 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. |
+ | 12.'''Full db backup (not done on the test system)''' |
− | 13. |
+ | 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