Upgrade Testsystem from 743p2 To 743p3: Difference between revisions

From Lsdf
Jump to navigationJump to search
No edit summary
No edit summary
Line 2: Line 2:
1.1 '''Remove /opt/hpss link'''
1.1 '''Remove /opt/hpss link'''
rm -f /opt/hpss
rm -f /opt/hpss
2. '''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 10:
make
make
make install
make install
3.'''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)
4. '''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
5. '''Start DB2'''
5.
su - hpssdb
su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
. /var/hpss/hpssdb/sqllib/db2profile
db2start
db2start
exit
exit
6. '''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 28:
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 34:
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 48:
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 57:
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 63:
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 69:
SUBSYS1> state
SUBSYS1> state
SUBSYS1> quit
SUBSYS1> quit
11. '''E2EDP and TOR'''
7. '''E2EDP and TOR'''
11.1 [root@hpsstcr03 hpss_src]# cat /proc/sys/kernel/randomize_va_space
[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
/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 87:
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 93:
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 99:
SUBSYS1> state
SUBSYS1> state
SUBSYS1> quit
SUBSYS1> quit
12.'''Full db backup (not done on the test system)'''


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

9. '''Install the new rpm's on all movers and change /opt/hpss link to the new version'''

Revision as of 17:58, 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. 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

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

4. Make now hpss link in /opt

ln -s /hpss_src/hpss-7.4.3.3-0.el6 /opt/hpss

5. Start DB2

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

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

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

8.Full db backup (not done on the test system)

9. Install the new rpm's on all movers and change /opt/hpss link to the new version