Upgrade Testsystem from 742 To 743p1: Difference between revisions

From Lsdf
Jump to navigationJump to search
No edit summary
No edit summary
 
Line 35: Line 35:
'''SEE THE FIRST UPGRADE KIT HowTo "Upgrade_Testsystem_from_742_To_743.txt" for more details'''
'''SEE THE FIRST UPGRADE KIT HowTo "Upgrade_Testsystem_from_742_To_743.txt" for more details'''


'''BEGIN NOTICE for productive core, it has to be done on the productive system'''
'''BEGIN NOTICE for productive core, it has to be done on the productive system'''
1.[root@hpsstcr03 hpss-7.4.3]# rpm -qa| grep -i hpss
1.[root@hpsstcr03 hpss-7.4.3]# rpm -qa| grep -i hpss
hpss-mvr-7.4.2-1.el6.x86_64
hpss-mvr-7.4.2-1.el6.x86_64
Line 42: Line 42:
hpss-clnt-7.4.2-1.el6.x86_64
hpss-clnt-7.4.2-1.el6.x86_64
hpss-doc-7.4.2-1.el6.x86_64
hpss-doc-7.4.2-1.el6.x86_64

2. cd /root/Software/HPSS/hpss-7.4.3
2. cd /root/Software/HPSS/hpss-7.4.3
3. turn off ASLR
3. turn off ASLR
Line 61: Line 60:
[root@hpsstcr03 DBD-DB2-1.84]# make
[root@hpsstcr03 DBD-DB2-1.84]# make
[root@hpsstcr03 DBD-DB2-1.84]# make install
[root@hpsstcr03 DBD-DB2-1.84]# make install
'''END NOTICE for productive core'''
'''END NOTICE for productive core'''


5.2 '''HPSS RPMs upgrade'''
5.2 '''HPSS RPMs upgrade'''
Line 99: Line 98:
/opt/hpss/lib/libhpssunixauthz.so unix_SECInitialize
/opt/hpss/lib/libhpssunixauthz.so unix_SECInitialize


cnvt> pam_hpsssrv
[ setting up PAM config ]
[ using system HPSS passwords ]
/var/hpss/etc/authz.conf has already been modified.
cnvt> quit


The file /var/hpss/etc/authz.conf was wrong
TO be sent to IBM
'''Question for productive system: Has to be done a 7.4.3.0 upgrade first?'''


[root@hpsstcr03 etc]# /opt/hpss/bin/hpss_server_acl
cnvt> pam_hpsssrv
hsa> acl -m
[ setting up PAM config ]
hsa> choose PVL
[ using system HPSS passwords ]
hsa> add user hpsscore c
/var/hpss/etc/authz.conf has already been modified.
cnvt> quit
hsa>quit
BUT

the file /var/hpss/etc/authz.conf was wrong

Question for productive system: Has to be done a 7.4.3.0 upgrade first?
****************************************************************
[root@hpsstcr03 etc]# /opt/hpss/bin/hpss_server_acl
hsa> acl -m
hsa> choose PVL
hsa> add user hpsscore c
hsa>quit
(Conversion Guide 9.5.6)
(Conversion Guide 9.5.6)
source /var/hpss/hpssdb/sqllib/db2profile
source /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db cfg
cnvt> db cfg
CFG> count all
CFG> count all
Table Name Number of Rows
Table Name Number of Rows
--------------- ---------------
--------------- ---------------
SERVERINTERFACES 16
SERVERINTERFACES 16
GLOBAL 1
GLOBAL 1
CORE 1
CORE 1
CFG> convert all
CFG> convert all
CFG> count all
CFG> count all
Table Name Number of Rows
--------------- ---------------
SERVERINTERFACES 16
GLOBAL 1
CORE 1
CFG> state
Table Name Conversion State Table/Index Space
--------------- --------------- -------------------------
SERVERINTERFACES CLEANUP USERSPACE1/USERSPACE1
GLOBAL CLEANUP USERSPACE1/USERSPACE1
CORE CLEANUP USERSPACE1/USERSPACE1
CFG> close
cnvt> quit


'''Conversion Guide 9.5.7. Convert the SUBSYS Databases''
Table Name Number of Rows
[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
--------------- ---------------
hmt> db subsys1
SERVERINTERFACES 16
Deleting BFMIGRRECBITFILEVIEW
GLOBAL 1
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
CORE 1
---Handle 65538---
CFG> state
DB error rc = -1 reported from SQLExecute, mm_execute.c: near line 683

Table Name Conversion State Table/Index Space
--------------- --------------- -------------------------
SERVERINTERFACES CLEANUP USERSPACE1/USERSPACE1
GLOBAL CLEANUP USERSPACE1/USERSPACE1
CORE CLEANUP USERSPACE1/USERSPACE1
CFG> close
cnvt> quit
(9.5.7. Convert the SUBSYS Databases)
[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
hmt> db subsys1
Deleting BFMIGRRECBITFILEVIEW
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
---Handle 65538---
DB error rc = -1 reported from SQLExecute, mm_execute.c: near line 683
SQLSTATE: 42501
SQLSTATE: 42501
Native Error Code: -551
Native Error Code: -551
[IBM][CLI Driver][DB2/LINUXX8664] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "HPSS". Operation: "DROP VIEW". Object: "HPSS.BFMIGRRECBITFILEVIEW". SQLSTATE=42501
[IBM][CLI Driver][DB2/LINUXX8664] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege<br>to perform the operation. Authorization ID: "HPSS". Operation: "DROP VIEW". Object: "HPSS.BFMIGRRECBITFILEVIEW". SQLSTATE=42501
hmt> quit
hmt> quit


Grant control:
'''Grant control:'''
su - hpssdb
su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
. /var/hpss/hpssdb/sqllib/db2profile
-bash-4.1$ db2 connect to hsubsys1
-bash-4.1$ db2 connect to hsubsys1
-bash-4.1$ db2 grant control on table hpss.STORAGESEGDISKVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.STORAGESEGDISKVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.STORAGESEGTAPEVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.STORAGESEGTAPEVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVDISKVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.VVDISKVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVTAPEVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.VVTAPEVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVTAPEMAPVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.VVTAPEMAPVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.BFMIGRRECBITFILEVIEW to user hpss
-bash-4.1$ db2 grant control on table hpss.BFMIGRRECBITFILEVIEW to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
-bash-4.1$ db2 grant control on table HPSS.SSPVHISTORY to user hpss
-bash-4.1$ db2 grant control on table HPSS.SSPVHISTORY to user hpss
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
AS ROOT:
source /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> del subsys views
hmt> del subsys constraints
hmt> commit
hmt> quit
9.5.7.2. use hpss_convertdb743 to convert the SUBSYS
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> convert all
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> quit
9.5.7.3. Use hpss_managetables to add SUBSYS views
[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> add subsys views
hmt> add subsys constraints
hmt> add indexes vvdisk
hmt> add indexes vvtape
hmt> commit
hmt> quit
DB2 backup
[root@hpsstcr03 HPSS]# db2 backup db hcfg to /db2_backup/offline/hcfg compress
[root@hpsstcr03 HPSS]# db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress


'''AS ROOT:'''
9.5.10. Cleanup the Global Database
source /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
/opt/hpss/bin/hpss_managetables
cnvt> db cfg
hmt> db subsys1
CFG> state
hmt> del subsys views
CFG> db subsys1
hmt> del subsys constraints
SUBSYS1> cleanup all
hmt> commit
SUBSYS1> state
SUBSYS1> quit
hmt> quit
'''Conversion guide9.5.7.2. use hpss_convertdb743 to convert the SUBSYS'''
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> convert all
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> quit


'''Conversion Guide 9.5.7.3. Use hpss_managetables to add SUBSYS views'''
DB2 Stop:
[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> add subsys views
hmt> add subsys constraints
hmt> add indexes vvdisk
hmt> add indexes vvtape
hmt> commit
hmt> quit


'''DB2 backup'''
[root@hpsstcr03 HPSS]# db2 backup db hcfg to /db2_backup/offline/hcfg compress
[root@hpsstcr03 HPSS]# db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress


'''Conversion guide 9.5.10. Cleanup the Global Database'''
su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
db2stop


/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db cfg
CFG> state
CFG> db subsys1
SUBSYS1> cleanup all
SUBSYS1> state
SUBSYS1> quit

'''DB2 Stop:'''
su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
db2stop


HPSS Start


as root:
'''Start HPSS as root '''


/opt/hpss/bin/rc.hpss start
/opt/hpss/bin/rc.hpss start
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
server start -all
server start -all

Latest revision as of 17:46, 21 June 2016

1. Stop HPSS 

/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
hpssadm> server shutdown -all
/opt/hpss/bin/rc.hpss -d stop
/opt/hpss/bin/rc.hpss -m stop

2. Stop DB2 /opt/hpss/bin/rc.hpss stop [root@hpsstcr03 /]# ps -ef | grep -i db2 

root      4306     1  0 Sep29 ?        00:08:32 /opt/ibm/db2/V10.5/bin/db2fmcd

3. DB2 offline backup 

[root@hpsstcr03 ~]# su - hpssdb
-bash-4.1$ . /var/hpss/hpssdb/sqllib/db2profile

Start only db2 in order to take an offline backup 

-bash-4.1$ db2start
-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
Backup successful. The timestamp for this backup image is : 20141218114347
-bash-4.1$ db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress
Backup successful. The timestamp for this backup image is : 20141218114500

NOTICE for the productive core server 

  db2 backup db hcfg to /db2_backup1/offline/hcfg compress
  db2 backup db hsubsys1 to /db2_backup1/offline/hsubsys1 compress
  db2 backup db hghi to /db2_backup1/offline/hghi compress

4. Stop DB2 

-bash-4.1$ db2stop

5. HPSS Upgrade 5.1 Prequisites

SEE THE FIRST UPGRADE KIT HowTo "Upgrade_Testsystem_from_742_To_743.txt" for more details 

BEGIN NOTICE for productive core, it has to be done on the productive system
1.[root@hpsstcr03 hpss-7.4.3]# rpm -qa| grep -i hpss
hpss-mvr-7.4.2-1.el6.x86_64
hpss-lib-7.4.2-1.el6.x86_64
hpss-core-7.4.2-1.el6.x86_64
hpss-clnt-7.4.2-1.el6.x86_64
hpss-doc-7.4.2-1.el6.x86_64
2. cd /root/Software/HPSS/hpss-7.4.3
3. turn off ASLR
[root@hpsstcr03 hpss-7.4.3]# grep kernel.randomize_va_space /etc/sysctl.conf
vi /etc/sysctl.conf 
kernel.randomize_va_space = 0
4. REBOOT
5. [root@hpsstcr03 yum.repos.d]# yum-config-manager --enable rhel-6-server-rpms
[root@hpsstcr03 yum.repos.d]# yum list llibtirpc
[root@hpsstcr03 yum.repos.d]# yum update libtirpc.x86_64
INSTALLED form rpm:
http://ftp.scientificlinux.org/linux/scientific/6x/x86_64/os/Packages/
[root@hpsstcr03 Addon_Packages]# rpm -Uvh libtirpc-devel-0.2.1-10.el6.x86_64.rpm libtirpc-0.2.1-10.el6.x86_64.rpm
[root@hpsstcr03 hpss]# yum install perl-DBI.x86_64
wget http://search.cpan.org/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.84.tar.gz
[root@hpsstcr03 Addon_Packages]# tar -zxvf DBD-DB2-1.84.tar.gz
[root@hpsstcr03 DBD-DB2-1.84]# perl Makefile.PL 
[root@hpsstcr03 DBD-DB2-1.84]# make
[root@hpsstcr03 DBD-DB2-1.84]# make install
END NOTICE for productive core

5.2 HPSS RPMs upgrade [root@hpsstcr03 7.4.3p1-Final]# rpm -Uvh hpss-lib-7.4.3.1-0.el6.x86_64.rpm hpss-core-7.4.3.1-0.el6.x86_64.rpm
hpss-clnt-7.4.3.1-0.el6.x86_64.rpm hpss-mvr-7.4.3.1-0.el6.x86_64.rpm hpss-doc-7.4.3.1-0.el6.x86_64.rpm 

rm /opt/hpss
ln -s /hpss_src/hpss-7.4.3.1-0.el6  /opt/hpss

5.3 DB2 conversion (conversion guide 9.5.4) 

Start DB2
[root@hpsstcr03 DBD-DB2-1.84]# su - hpssdb
-bash-4.1$  . /var/hpss/hpssdb/sqllib/db2profile
-bash-4.1$ db2start
11/21/2014 17:59:16     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
exit (from user hpssdb)

As root: 

[root@hpsstcr03 DBD-DB2-1.84]# source /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> quit

Check results: 

[root@hpsstcr03 ~]# cat /etc/group | grep hpsssrv
hpsssrvr:x:301:hpss
[root@hpsstcr03 ~]# ll /var/hpss/etc | grep autz
[root@hpsstcr03 ~]# ll /var/hpss/etc | grep auth
-rw-r--r-- 1 hpss  hpss       232 Oct 21 14:00 auth.conf
-rw-r--r-- 1 root  root       225 Nov 21 18:01 authz.conf
-rw-r--r-- 1 hpss  hpss       224 Oct 21 14:00 authz.conf.orig
[root@hpsstcr03 ~]# cat /var/hpss/etc/authz.conf
#
#
# HPSS Authorization Service Registry Definitions
#
# library                               function
/opt/hpss/lib/libhpssldapauthz.so        ldap_SECInitialize
/opt/hpss/lib/libhpssunixauthz.so        unix_SECInitialize

cnvt> pam_hpsssrv
[ setting up PAM config ]
[ using system HPSS passwords ]
/var/hpss/etc/authz.conf has already been modified.
cnvt> quit

The file /var/hpss/etc/authz.conf was wrong
Question for productive system: Has to be done a 7.4.3.0 upgrade first?

[root@hpsstcr03 etc]# /opt/hpss/bin/hpss_server_acl 
hsa> acl -m
hsa> choose PVL
hsa> add user hpsscore c
hsa>quit
(Conversion Guide 9.5.6)
source /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db cfg
CFG> count all
Table Name      Number of Rows 
--------------- ---------------
SERVERINTERFACES              16
GLOBAL                        1
CORE                          1
CFG> convert all
CFG> count all
Table Name      Number of Rows 
--------------- ---------------
SERVERINTERFACES              16
GLOBAL                        1
CORE                          1

CFG> state
Table Name      Conversion State Table/Index Space        
--------------- --------------- -------------------------
SERVERINTERFACES CLEANUP         USERSPACE1/USERSPACE1    
GLOBAL          CLEANUP         USERSPACE1/USERSPACE1    
CORE            CLEANUP         USERSPACE1/USERSPACE1  
CFG> close
cnvt> quit

'Conversion Guide 9.5.7. Convert the SUBSYS Databases 

[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
hmt> db subsys1
Deleting BFMIGRRECBITFILEVIEW
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
---Handle 65538---
DB error rc = -1 reported from SQLExecute, mm_execute.c: near line 683
        SQLSTATE: 42501
Native Error Code: -551
[IBM][CLI Driver][DB2/LINUXX8664] SQL0551N  The statement failed because the authorization ID does not have the required authorization or privilege
to perform the operation.  Authorization ID: "HPSS".  Operation: "DROP VIEW". Object: "HPSS.BFMIGRRECBITFILEVIEW".  SQLSTATE=42501
hmt> quit

Grant control: 

su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile 
-bash-4.1$ db2 connect to hsubsys1
-bash-4.1$ db2 grant control on table hpss.STORAGESEGDISKVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.STORAGESEGTAPEVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVDISKVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVTAPEVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.VVTAPEMAPVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table hpss.BFMIGRRECBITFILEVIEW to user hpss
DB20000I  The SQL command completed successfully.
-bash-4.1$ db2 grant control on table HPSS.SSPVHISTORY to user hpss
DB20000I  The SQL command completed successfully.

AS ROOT: 

source /var/hpss/hpssdb/sqllib/db2profile
/opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> del subsys views
hmt> del subsys constraints
hmt> commit
hmt> quit

Conversion guide9.5.7.2. use hpss_convertdb743 to convert the SUBSYS 

/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db subsys1
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> convert all
SUBSYS1> count all
SUBSYS1> state
SUBSYS1> quit

Conversion Guide 9.5.7.3. Use hpss_managetables to add SUBSYS views 

[root@hpsstcr03 HPSS]# /opt/hpss/bin/hpss_managetables
hmt> db subsys1
hmt> add subsys views
hmt> add subsys constraints
hmt> add indexes vvdisk
hmt> add indexes vvtape
hmt> commit
hmt> quit

DB2 backup 

[root@hpsstcr03 HPSS]# db2 backup db hcfg to /db2_backup/offline/hcfg compress
[root@hpsstcr03 HPSS]# db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress

Conversion guide 9.5.10. Cleanup the Global Database 

/opt/hpss/tools/convert743/hpss/hpss_convertdb743
cnvt> db cfg
CFG> state
CFG> db subsys1
SUBSYS1> cleanup all
SUBSYS1> state
SUBSYS1> quit

DB2 Stop: 

su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
db2stop


Start HPSS as root 

/opt/hpss/bin/rc.hpss start
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
server start -all
Retrieved from "https://wiki.scc.kit.edu/lsdf/index.php?title=Upgrade_Testsystem_from_742_To_743p1&oldid=3867"