Upgrade Testsystem from 743p2 To 743p3: Difference between revisions
From Lsdf
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (17 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''' |
||
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 |
||
| Line 10: | 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) |
||
5. '''Make now hpss link in /opt''' |
|||
4. |
|||
ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss |
ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss |
||
6. '''Start DB2''' |
|||
5. |
|||
su - hpssdb |
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 |
||
| Line 27: | 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 |
||
| Line 33: | Line 35: | ||
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 |
||
| Line 47: | 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 |
||
| Line 57: | 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 |
||
| Line 63: | Line 64: | ||
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 |
||
| Line 69: | Line 70: | ||
SUBSYS1> state |
SUBSYS1> state |
||
SUBSYS1> quit |
SUBSYS1> quit |
||
8. '''E2EDP and TOR''' |
|||
| ⚫ | |||
| ⚫ | |||
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 |
||
/opt/hpss/tools/convert743p3_tor_e2edi/hpss/hpss_convertdb_tor_e2edi |
|||
cnvt> db cfg |
cnvt> db cfg |
||
CFG> convert all |
CFG> convert all |
||
| Line 85: | 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 90: | 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 95: | Line 101: | ||
SUBSYS1> state |
SUBSYS1> state |
||
SUBSYS1> quit |
SUBSYS1> quit |
||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
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
