Upgrade Testsystem from 743p2 To 743p3

From Lsdf
Revision as of 17:47, 21 June 2016 by Dorin-daniel.lobontu (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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

Retrieved from "https://wiki.scc.kit.edu/lsdf/index.php?title=Upgrade_Testsystem_from_743p2_To_743p3&oldid=3868"