Upgrade Testsystem from 742 TO 743

From Lsdf
Jump to navigationJump to search

HPSS Migration (test system) 21.11.2013 Ahmmad & Dorin

  • 1.Shutdown hpss
    • 1.1 Start hpssadm command line
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
    • 1.2 List all hpss running servers
hpssadm> server list
Servers
Time Created by System Manager  Oct 21, 2014 4:02:41 PM   
Time Updated by System Manager  Nov 21, 2014 10:43:45 AM  
Time Received by Client         Nov 21, 2014 10:43:52 AM                             
 ID  Status     Type   Subtype  Subsystem     Op State  Server Name                 Host                    Execute Host  UUID                                  
  0  Connected  SSMSM                         Enabled   SSM System Manager          hpsstcr03.lsdf.kit.edu  hpsstcr03     264216ec-0752-11e4-9b61-40f2e9724ad2  
  1  Connected  SUD                           Enabled   Startup Daemon (hpsstcr03)  hpsstcr03.lsdf.kit.edu  hpsstcr03     58cea534-0767-11e4-8c5a-40f2e9724ad2  
  2  Connected  LOGD                          Enabled   Log Daemon                  hpsstcr03.lsdf.kit.edu  hpsstcr03     c5156872-0767-11e4-8c5a-40f2e9724ad2  
  3  Connected  LOGC                          Enabled   Log Client (hpsstcr03)      hpsstcr03.lsdf.kit.edu  hpsstcr03     0126f952-0768-11e4-8c5a-40f2e9724ad2  
  4  Connected  LS                            Enabled   Location Server             hpsstcr03.lsdf.kit.edu  hpsstcr03     0bd80a6c-0768-11e4-8c5a-40f2e9724ad2  
  5  Connected  MPS             Subsystem #1  Enabled   Migration/Purge Server      hpsstcr03.lsdf.kit.edu  hpsstcr03     3d7963d6-0768-11e4-8c5a-40f2e9724ad2  
  6  Connected  PVL                           Enabled   PVL                         hpsstcr03.lsdf.kit.edu  hpsstcr03     6f1c6abe-0768-11e4-8c5a-40f2e9724ad2  
  7  Connected  CORE            Subsystem #1  Enabled   Core Server                 hpsstcr03.lsdf.kit.edu  hpsstcr03     9f442a1a-0768-11e4-8c5a-40f2e9724ad2  
  8  Connected  MOVER                         Enabled   Mover (hpsstmvr-disk)       hpsstcr03.lsdf.kit.edu  hpsstcr03     a7597526-0811-11e4-93a8-40f2e9724ad2  
  9  Connected  PVR    SCSI                   Enabled   SCSI PVR                    hpsstcr03.lsdf.kit.edu  hpsstcr03     637882b0-0830-11e4-85d7-40f2e9724ad2  
    • 1.3 Shutdown all servers
hpssadm> server shutdown -all
Shutdown operation is not supported for server 0 (Server = SSM System Manager)
Shutdown operation is not supported for server 1 (Server = Startup Daemon (hpsstcr03))
Shutdown the specified servers? y
    • 1.4 Stop startup daemon
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -d stop
    • 1.5 Stop ssm system manager
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -m stop
    • 1.5 Stop db2 processes
[root@hpsstcr03 /]# /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
    • 1.6 Start only db2 in order to take an offline backup
[root@hpsstcr03 ~]# su - hpssdb
-bash-4.1$ . /var/hpss/hpssdb/sqllib/db2profile
-bash-4.1$ db2start
11/21/2014 11:09:17     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
    • 1.7. DB2 offline backup
-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
Backup successful. The timestamp for this backup image is : 20141121111046
-bash-4.1$ db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress
Backup successful. The timestamp for this backup image is : 20141121111100


NOTICE for the productive core server, there is one more database

  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
  • 2. Prerequisites
    • 2.1 Turn off ASLR
vi /etc/sysctl.conf 
kernel.randomize_va_space = 0
    • 2.2 REBOOT

NOTICE on the productive core ASLR is already OK !!!


    • 2.3 llibtirpc
[root@hpsstcr03 yum.repos.d]# yum-config-manager --enable rhel-6-server-rpms
[root@hpsstcr03 yum.repos.d]# yum list llibtirpc
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
rhel-6-server-rpms                                              3.7 kB     00:00     
file:///mnt/DVD/repodata/repomd.xml: [Errno 14] Could not open/read file:///mnt/DVD/repodata/repomd.xml
Trying other mirror.
Error: No matching Packages to list
[root@hpsstcr03 yum.repos.d]# yum list libtirpc
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
rhel-6-server-rpms                                              3.7 kB     00:00     
file:///mnt/DVD/repodata/repomd.xml: [Errno 14] Could not open/read file:///mnt/DVD/repodata/repomd.xml
Trying other mirror.
Installed Packages
libtirpc.x86_64                                                 0.2.1-5.el6             @anaconda-RedHatEnterpriseLinux-201301301459.x86_64/6.4
Available Packages
libtirpc.i686                                                   0.2.1-10.el6            rhel-6-server-rpms                                     
libtirpc.x86_64                                                 0.2.1-10.el6            rhel-6-server-rpms  
[root@hpsstcr03 yum.repos.d]# yum update libtirpc.x86_64
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
rhel-6server-rpms                                                | 3.7 kB     00:00     
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package libtirpc.x86_64 0:0.2.1-5.el6 will be updated
--> Processing Dependency: libtirpc = 0.2.1-5.el6 for package: libtirpc-devel-0.2.1-5.el6.x86_64
---> Package libtirpc.x86_64 0:0.2.1-10.el6 will be an update
--> Running transaction check
---> Package libtirpc.i686 0:0.2.1-5.el6 will be installed
--> Processing Dependency: libgssglue.so.1(libgssapi_CITI_2) for package: libtirpc-0.2.1-5.el6.i686
--> Processing Dependency: libgssglue.so.1 for package: libtirpc-0.2.1-5.el6.i686
---> Package libtirpc.x86_64 0:0.2.1-5.el6 will be updated
---> Package libtirpc.x86_64 0:0.2.1-5.el6 will be updated
--> Running transaction check
---> Package libgssglue.i686 0:0.1-11.el6 will be installed
--> Finished Dependency Resolution
Error:  Multilib version problems found. This often means that the root
      cause is something else and multilib version checking is just
      pointing out that there is a problem. Eg.:
      
        1. You have an upgrade for libtirpc which is missing some
           dependency that another package requires. Yum is trying to
           solve this by installing an older version of libtirpc of the
           different architecture. If you exclude the bad architecture
           yum will tell you what the root cause is (which package
           requires what). You can try redoing the upgrade with
           --exclude libtirpc.otherarch ... this should give you an error
           message showing the root cause of the problem.
      
        2. You have multiple architectures of libtirpc installed, but
           yum can only see an upgrade for one of those arcitectures.
           If you don't want/need both architectures anymore then you
           can remove the one with the missing update and everything
           will work.
      
        3. You have duplicate versions of libtirpc installed already.
           You can use "yum check" to get yum show these errors.
      
      ...you can also use --setopt=protected_multilib=false to remove
      this checking, however this is almost never the correct thing to
      do as something else is very likely to go wrong (often causing
      much more problems).
      
      Protected multilib versions: libtirpc-0.2.1-10.el6.x86_64 != libtirpc-0.2.1-5.el6.i686
      You could try using --skip-broken to work around the problem
      You could try running: rpm -Va --nofiles --nodigest
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
warning: libtirpc-devel-0.2.1-10.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
Preparing...                ########################################### [100%]
  1:libtirpc               ########################################### [ 50%]
  2:libtirpc-devel         ########################################### [100%]
[root@hpsstcr03 Addon_Packages]# rpm --checksig -v libtirpc-0.2.1-10.el6.x86_64.rpm libtirpc-0.2.1-10.el6.x86_64.rpm:
   Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
   Header SHA1 digest: OK (bcf662de69d2eaaf83276d21677dab858b6d1cd7)
   MD5 digest: OK (c21c5fa9c335e682754ca03e0d2fb3f4)
   V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
[root@hpsstcr03 Addon_Packages]#  rpm --checksig -v libtirpc-devel-0.2.1-10.el6.x86_64.rpm libtirpc-devel-0.2.1-10.el6.x86_64.rpm:
   Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
   Header SHA1 digest: OK (30b9077933cfb858eae7778f135a485d7881387e)
   MD5 digest: OK (3bf6b70ddf56593f1b67d797d17985be)
   V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
The authenticity has not been proofed
  • 3 Update HPSS
    • 3.1 installed hpss rmps
[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
    • 3.2 Install new rpms
cd /root/Software/HPSS/hpss-7.4.3
[root@hpsstcr03 hpss-7.4.3]# rpm -Uvh hpss-mvr-7.4.3-0.el6.x86_64.rpm hpss-lib-7.4.3-0.el6.x86_64.rpm
hpss-core-7.4.3-0.el6.x86_64.rpm hpss-clnt-7.4.3-0.el6.x86_64.rpm hpss-doc-7.4.3-0.el6.x86_64.rpm Preparing... ########################################### [100%] 1:hpss-lib ########################################### [ 20%] Files for package hpss-lib installed under /hpss_src/hpss-7.4.3-0.el6 2:hpss-mvr ########################################### [ 40%] Files for package hpss-mvr installed under /hpss_src/hpss-7.4.3-0.el6 You must have a link set up at /opt/ibm/db2/default for your installed DB2 version. Your link should point to /opt/ibm/db2/V9.7 or /opt/ibm/db2/V10.5. error: %pre(hpss-core-7.4.3-0.el6.x86_64) scriptlet failed, exit status 1 error: install: %pre scriptlet failed (2), skipping hpss-core-7.4.3-0.el6 3:hpss-clnt ########################################### [ 60%] Files for package hpss-clnt installed under /hpss_src/hpss-7.4.3-0.el6 4:hpss-doc ########################################### [ 80%] Files for package hpss-doc installed under /hpss_src/hpss-7.4.3-0.el6
    • 3.3 Make link for db default
[root@hpsstcr03 db2]# ln -s /opt/ibm/db2/V10.5 /opt/ibm/db2/default
[root@hpsstcr03 db2]# ln -sf /opt/ibm/db2/default /hpss_src/hpss-7.4.3-0.el6/db2
    • 3.4 upgrade core
[root@hpsstcr03 hpss-7.4.3]# rpm -Uvh hpss-core-7.4.3-0.el6.x86_64.rpm
Preparing...                ########################################### [100%]
  1:hpss-core              ########################################### [100%]
Files for package hpss-core installed under /hpss_src/hpss-7.4.3-0.el6
    • 3.5 check the rpms
[root@hpsstcr03 hpss-7.4.3]# rpm -qa | grep -i hpss
hpss-mvr-7.4.3-0.el6.x86_64
hpss-lib-7.4.3-0.el6.x86_64
hpss-core-7.4.3-0.el6.x86_64
hpss-doc-7.4.3-0.el6.x86_64
hpss-clnt-7.4.3-0.el6.x86_64


  • 4 Database Conversion
    • 4.1 Make hpss link
ln -s /hpss_src/hpss-7.4.3-0.el6 /opt/hpss
    • 4.2 Update DBI driver
[root@hpsstcr03 hpss]# source /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 hpss]# yum install perl-DBI.x86_64
[root@hpsstcr03 hpss]#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
    • 4.3 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)
    • 4.4 Start conversion 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> pam_hpsssrv
[ setting up PAM config ]
[ using system HPSS passwords ]
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


    • 4.5 server acl

[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/bin/hpss_server_acl hsa> acl -m 1) Core Server 2) Mover (hpsstmvr-disk) 3) Startup Daemon (hpsstcr03) 4) Log Client (hpsstcr03) 5) Location Server 6) Log Daemon 7) SCSI PVR 8) PVL 9) Migration/Purge Server 10) SSM System Manager Select a server Choose an item by number (RET to cancel): > 8 hsa> show perms - type - ID (name) - realm ID (realm)

===============================

rw-c-dt - user - 303 (hpssssm) - 10000 (LSDF.KIT.EDU) rw---dt - user - 313 (hpsscore) - 10000 (LSDF.KIT.EDU) rw---dt - user - 314 (hpsspvr) - 10000 (LSDF.KIT.EDU)


t - any_other

hsa> add user hpsscore c hsa> show perms - type - ID (name) - realm ID (realm)

===============================

rw-c-dt - user - 303 (hpssssm) - 10000 (LSDF.KIT.EDU) rw-c-dt - user - 313 (hpsscore) - 10000 (LSDF.KIT.EDU) rw---dt - user - 314 (hpsspvr) - 10000 (LSDF.KIT.EDU)


t - any_other

hsa> quit


Convert the global database cfg using hpss_convertdb743

[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743 HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections. Password for hpssdb: cnvt> db cfg Creating table 'CONVERT_743' to track conversion progress... Making entry for table SERVERINTERFACES Making entry for table GLOBAL Making entry for table CORE

Table Name Conversion State Table/Index Space


--------------- -------------------------

SERVERINTERFACES START USERSPACE1/USERSPACE1 GLOBAL START USERSPACE1/USERSPACE1 CORE START USERSPACE1/USERSPACE1 CFG> count all

Table Name Number of Rows


---------------

SERVERINTERFACES 16 GLOBAL 1 CORE 1 CFG> convert all Converting SERVERINTERFACES... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY Conversion Time: 0 minutes 1 seconds Done Converting GLOBAL... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY

  Database Connection Information
Database server        = DB2/LINUXX8664 10.5.3
SQL authorization ID   = HPSSDB
Local database alias   = CFG

DB20000I The REORG command completed successfully. Conversion Time: 0 minutes 1 seconds Done Converting CORE... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY

  Database Connection Information
Database server        = DB2/LINUXX8664 10.5.3
SQL authorization ID   = HPSSDB
Local database alias   = CFG

DB20000I The REORG command completed successfully. Conversion Time: 0 minutes 1 seconds Done CFG> count all

Table Name Number of Rows


---------------

SERVERINTERFACES 16 GLOBAL 1 CORE 1 CFG> close cnvt> quit [root@hpsstcr03 DBD-DB2-1.84]#

9.5.6 Convert the subsys database

[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/bin/hpss_managetables hmt> db subsys1

Available tablespaces:

                                        Owner Data

ID Tablespace Name Owner Type Type

2 USERSPACE1 SYSIBM S L 3 ACCOUNTING HPSSDB U L 4 ACCOUNTINGIX HPSSDB U L 5 BFCOSCHANGE HPSSDB U L 6 BFCOSCHANGEIX HPSSDB U L 7 BFDISKALLOCREC HPSSDB U L 8 BFDISKALLOCRECIX HPSSDB U L 9 BFDISKSEG HPSSDB U L 10 BFDISKSEGIX HPSSDB U L 11 BFMIGRREC HPSSDB U L 12 BFMIGRRECIX HPSSDB U L 13 BFPURGEREC HPSSDB U L 14 BFPURGERECIX HPSSDB U L 15 BFSSEGCHKPT HPSSDB U L 16 BFSSEGCHKPTIX HPSSDB U L 17 BFTAPESEG HPSSDB U L 18 BFTAPESEGIX HPSSDB U L 19 BITFILE HPSSDB U L 20 BITFILEIX HPSSDB U L 21 DISKSEGUNLINK HPSSDB U L 22 DISKSEGUNLINKIX HPSSDB U L 23 DMGFILESET HPSSDB U L 24 DMGFILESETIX HPSSDB U L 25 MPSCHKPT HPSSDB U L 26 MPSCHKPTIX HPSSDB U L 27 NSACL HPSSDB U L 28 NSACLIX HPSSDB U L 29 NSFILESETATTR HPSSDB U L 30 NSFILESETATTRIX HPSSDB U L 31 NSOBJECT HPSSDB U L 32 NSOBJECTIX HPSSDB U L 33 NSTEXT HPSSDB U L 34 NSTEXTIX HPSSDB U L 35 SSPVDISK HPSSDB U L 36 SSPVDISKIX HPSSDB U L 37 SSPVHISTORY HPSSDB U L 38 SSPVHISTORYIX HPSSDB U L 39 SSPVTAPE HPSSDB U L 40 SSPVTAPEIX HPSSDB U L 41 STORAGEMAPDISK HPSSDB U L 42 STORAGEMAPDISKIX HPSSDB U L 43 STORAGEMAPTAPE HPSSDB U L 44 STORAGEMAPTAPEIX HPSSDB U L 45 STORAGESEGDISK HPSSDB U L 46 STORAGESEGDISKIX HPSSDB U L 47 STORAGESEGDISKEX HPSSDB U L 48 STORAGESEGDISKEXIX HPSSDB U L 49 STORAGESEGTAPE HPSSDB U L 50 STORAGESEGTAPEIX HPSSDB U L 51 STORAGESEGTAPEAB HPSSDB U L 52 STORAGESEGTAPEABIX HPSSDB U L 53 STORAGESEGAUX HPSSDB U L 54 STORAGESEGAUXIX HPSSDB U L 55 TAPESEGUNLINK HPSSDB U L 56 TAPESEGUNLINKIX HPSSDB U L 57 USERATTRS HPSSDB U L 58 USERATTRSIX HPSSDB U L 59 VVDISK HPSSDB U L 60 VVDISKIX HPSSDB U L 61 VVTAPE HPSSDB U L 62 VVTAPEIX HPSSDB U L 63 VVTAPEABSADDR HPSSDB U L 64 VVTAPEABSADDRIX HPSSDB U L

Database: subsys1 [Subsystem database] Schema: HPSS Default tablespace: NOT SELECTED Default index tablespace: NOT SELECTED hmt> del subsys views 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> hmt> hmt> del subsys1 views Syntax error. Type "help" for help. hmt> del subsys views 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


9.5.6.2

convert subsys1:

[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743 HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections. Password for hpssdb: cnvt> db subsys1 ^Creating table 'CONVERT_743' to track conversion progress... Making entry for table BITFILE Making entry for table SSPVHISTORY Making entry for table NSTRASH Making entry for table MPSFORCEMIGRATE

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE START BITFILE/BITFILEIX SSPVHISTORY START SSPVHISTORY/SSPVHISTORYIX NSTRASH START <UNDEF>/<UNDEF> MPSFORCEMIGRATE START <UNDEF>/<UNDEF> SUBSYS1> count all Available commands:

  cleanup             Cleanup after conversion
  close               Disconnect from a database
  convert             Run the conversion
  count               Count the number of rows in a table
  db                  Connect to database
  env                 Dump configuration parameters
  help                Display available commands
  pam_hpsssrv         Perform unix authentication , call PAM setup and modify authz.conf
  revert              Revert the conversion
  rsql                Show the SQL that will be run to revert a table
  showts              Show tablespace info for tables that will be converted
  sql                 Show the SQL that will be run to convert a table
  state               Show the current state of conversion
  ts                  Set the tablespace to use

SUBSYS1> count all

Table Name Number of Rows


---------------

BITFILE 24 SSPVHISTORY 0 NSTRASH <undef> MPSFORCEMIGRATE <undef> SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE START BITFILE/BITFILEIX SSPVHISTORY START SSPVHISTORY/SSPVHISTORYIX NSTRASH START <UNDEF>/<UNDEF> MPSFORCEMIGRATE START <UNDEF>/<UNDEF> SUBSYS1> convert all Converting BITFILE... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY Conversion Time: 0 minutes 5 seconds Done Converting SSPVHISTORY... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY

Unable to process SQL for table SSPVHISTORY, state DEPLOY: DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0750N The statement failed because the table or column cannot be renamed. SQLSTATE=42986

FAILED. Examine error, then check status with the 'state' command.

Converting NSTRASH... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY Conversion Time: 0 minutes 1 seconds Done Converting MPSFORCEMIGRATE... Executing operations for state: START Executing operations for state: CREATE Executing operations for state: FILL Executing operations for state: DEPLOY Conversion Time: 0 minutes 1 seconds Done SUBSYS1> count all

Table Name Number of Rows


---------------

BITFILE 24 SSPVHISTORY 0 NSTRASH 0 MPSFORCEMIGRATE 0 SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> quit


Revert:


[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743 HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections. Password for hpssdb: cnvt> db subsys1 Using existing table 'CONVERT_743' to track conversion progress.

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> revert all ALL is not valid. Valid tables are:

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> revert BITFILE Reverting BITFILE... Running revert operations Done SUBSYS1> revert NSTRASH Reverting NSTRASH... Running revert operations Done SUBSYS1> revert MPSFORCEMIGRATE Reverting MPSFORCEMIGRATE... Running revert operations Done SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE DEPLOY BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH DEPLOY NSTRASH/NSTRASHIX MPSFORCEMIGRATE DEPLOY MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1>


Problem :


9.6.5.1 check why hpss authorization id faild


Second Day 24.11.2014 (see chapter 1.3 preparation...we did not do it for the test system)

su - hpssdb % . /var/hpss/hpssdb/sqllib/db2profile % db2 connect to hcfg % db2 grant dbadm on database to user hpss % db2 terminate % db2 connect to hsubsys1 % db2 grant dbadm on database to user hpss

As root: . /var/hpss/hpssdb/sqllib/db2profile /opt/hpss/bin/hpss_managetables hmt> db subsys1 hmt> del subsys views hmt> del subsys views hmt> commit Transaction committed hmt> quit

9.5.6.2


[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743 HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections. Password for hpssdb: cnvt> db subsys1 Using existing table 'CONVERT_743' to track conversion progress.

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE DEPLOY BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH DEPLOY <UNDEF>/<UNDEF> MPSFORCEMIGRATE DEPLOY <UNDEF>/<UNDEF> SUBSYS1> count all

Table Name Number of Rows


---------------

BITFILE 24 SSPVHISTORY 0 NSTRASH <undef> MPSFORCEMIGRATE <undef> SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE DEPLOY BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH DEPLOY <UNDEF>/<UNDEF> MPSFORCEMIGRATE DEPLOY <UNDEF>/<UNDEF> SUBSYS1> convert all ALL is not valid. Valid tables are:

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE DEPLOY BITFILE/BITFILEIX SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX NSTRASH DEPLOY <UNDEF>/<UNDEF> MPSFORCEMIGRATE DEPLOY <UNDEF>/<UNDEF> SUBSYS1> convert BITFILE Converting BITFILE... Executing operations for state: DEPLOY Conversion Time: 0 minutes 1 seconds Done SUBSYS1> convert SSPVHISTORY Converting SSPVHISTORY... Executing operations for state: DEPLOY Conversion Time: 0 minutes 0 seconds Done SUBSYS1> convert NSTRASH Converting NSTRASH... Executing operations for state: DEPLOY Conversion Time: 0 minutes 1 seconds Done SUBSYS1> convert MPSFORCEMIGRATE Converting MPSFORCEMIGRATE... Executing operations for state: DEPLOY Conversion Time: 0 minutes 0 seconds Done SUBSYS1> count all

Table Name Number of Rows


---------------

BITFILE 24 SSPVHISTORY 0 NSTRASH 0 MPSFORCEMIGRATE 0 SUBSYS1> state

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY CLEANUP SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> quit

9.5.6.3


[root@hpsstcr03 ~]# /opt/hpss/bin/hpss_managetables hmt> db subsys1

Available tablespaces:

                                        Owner Data

ID Tablespace Name Owner Type Type

2 USERSPACE1 SYSIBM S L 3 ACCOUNTING HPSSDB U L 4 ACCOUNTINGIX HPSSDB U L 5 BFCOSCHANGE HPSSDB U L 6 BFCOSCHANGEIX HPSSDB U L 7 BFDISKALLOCREC HPSSDB U L 8 BFDISKALLOCRECIX HPSSDB U L 9 BFDISKSEG HPSSDB U L 10 BFDISKSEGIX HPSSDB U L 11 BFMIGRREC HPSSDB U L 12 BFMIGRRECIX HPSSDB U L 13 BFPURGEREC HPSSDB U L 14 BFPURGERECIX HPSSDB U L 15 BFSSEGCHKPT HPSSDB U L 16 BFSSEGCHKPTIX HPSSDB U L 17 BFTAPESEG HPSSDB U L 18 BFTAPESEGIX HPSSDB U L 19 BITFILE HPSSDB U L 20 BITFILEIX HPSSDB U L 21 DISKSEGUNLINK HPSSDB U L 22 DISKSEGUNLINKIX HPSSDB U L 23 DMGFILESET HPSSDB U L 24 DMGFILESETIX HPSSDB U L 25 MPSCHKPT HPSSDB U L 26 MPSCHKPTIX HPSSDB U L 27 NSACL HPSSDB U L 28 NSACLIX HPSSDB U L 29 NSFILESETATTR HPSSDB U L 30 NSFILESETATTRIX HPSSDB U L 31 NSOBJECT HPSSDB U L 32 NSOBJECTIX HPSSDB U L 33 NSTEXT HPSSDB U L 34 NSTEXTIX HPSSDB U L 35 SSPVDISK HPSSDB U L 36 SSPVDISKIX HPSSDB U L 37 SSPVHISTORY HPSSDB U L 38 SSPVHISTORYIX HPSSDB U L 39 SSPVTAPE HPSSDB U L 40 SSPVTAPEIX HPSSDB U L 41 STORAGEMAPDISK HPSSDB U L 42 STORAGEMAPDISKIX HPSSDB U L 43 STORAGEMAPTAPE HPSSDB U L 44 STORAGEMAPTAPEIX HPSSDB U L 45 STORAGESEGDISK HPSSDB U L 46 STORAGESEGDISKIX HPSSDB U L 47 STORAGESEGDISKEX HPSSDB U L 48 STORAGESEGDISKEXIX HPSSDB U L 49 STORAGESEGTAPE HPSSDB U L 50 STORAGESEGTAPEIX HPSSDB U L 51 STORAGESEGTAPEAB HPSSDB U L 52 STORAGESEGTAPEABIX HPSSDB U L 53 STORAGESEGAUX HPSSDB U L 54 STORAGESEGAUXIX HPSSDB U L 55 TAPESEGUNLINK HPSSDB U L 56 TAPESEGUNLINKIX HPSSDB U L 57 USERATTRS HPSSDB U L 58 USERATTRSIX HPSSDB U L 59 VVDISK HPSSDB U L 60 VVDISKIX HPSSDB U L 61 VVTAPE HPSSDB U L 62 VVTAPEIX HPSSDB U L 63 VVTAPEABSADDR HPSSDB U L 64 VVTAPEABSADDRIX HPSSDB U L 66 NSTRASH HPSSDB U L 67 NSTRASHIX HPSSDB U L 68 MPSFORCEMIGRATE HPSSDB U L 69 MPSFORCEMIGRATEIX HPSSDB U L

Database: subsys1 [Subsystem database] Schema: HPSS Default tablespace: NOT SELECTED Default index tablespace: NOT SELECTED

hmt> add subsys views Adding BFMIGRRECBITFILEVIEW Adding NSTRASHVIEW Adding STORAGESEGDISKVIEW Adding STORAGESEGTAPEVIEW Adding VVDISKVIEW Adding VVTAPEVIEW Adding VVTAPEMAPVIEW hmt> add subsys constraints Adding BFTAPESEGCON1 Adding DISKSEGEXTENTSCON1 Adding DISKVVMAPCON1 Adding DISKVVPVCON1 Adding DISKVVSEGSCON1 Adding TAPESEGABSADDRCON1 Adding TAPESEGAUXCON1 Adding TAPEVVMAPCON1 Adding SSPVHISTORYCON1 Adding TAPEVVPVCON1 Adding TAPEVVSEGSCON1 Adding NSOBJECTUSERATTRS1 hmt> add indexes vvdisk

Creating indexes for table VVDISK

ALTER TABLE VVDISK ADD CONSTRAINT VVDISK_PKEY PRIMARY KEY ( VVID) The primary key was not created because VVDISK already has a primary key. This is assumed not to be an error. If this is an error, you must remove the primary key constraint and then run this command again. Use 'del indexes VVDISK' to remove the indexes and primary key constraint.

CREATE OR REPLACE TRIGGER VVDISK_D_CHK_MPSFORCEMIGRATE BEFORE DELETE ON VVDISK REFERENCING OLD AS O FOR EACH ROW WHEN (EXISTS(SELECT ORIG_VVID FROM MPSFORCEMIGRATE WHERE ORIG_VVID = O.VVID)) BEGIN ATOMIC SIGNAL SQLSTATE 'Z0003' ('Foreign Key Violation, child rows exist in table MPSFORCEMIGRATE ') ; END hmt> add indexes vvtape

Creating indexes for table VVTAPE

ALTER TABLE VVTAPE ADD CONSTRAINT VVTAPE_PKEY PRIMARY KEY ( VVID) The primary key was not created because VVTAPE already has a primary key. This is assumed not to be an error. If this is an error, you must remove the primary key constraint and then run this command again. Use 'del indexes VVTAPE' to remove the indexes and primary key constraint.

CREATE OR REPLACE TRIGGER VVTAPE_D_CHK_MPSFORCEMIGRATE BEFORE DELETE ON VVTAPE REFERENCING OLD AS O FOR EACH ROW WHEN (EXISTS(SELECT ORIG_VVID FROM MPSFORCEMIGRATE WHERE ORIG_VVID = O.VVID)) BEGIN ATOMIC SIGNAL SQLSTATE 'Z0003' ('Foreign Key Violation, child rows exist in table MPSFORCEMIGRATE ') ; END hmt> commit Transaction committed hmt> quit

9.5.6.4 DB database full backup after conversion

new db2 backup to /db2_backup/offline/ba_after_conversion/hcfg

/db2_backup/offline/ba_after_conversion/subsys

9.5.6.6

[root@hpsstcr03 ~]# . /var/hpss/hpssdb/sqllib/db2profile [root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743 HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections. Password for hpssdb: cnvt> db cfg Using existing table 'CONVERT_743' to track conversion progress.

Table Name Conversion State Table/Index Space


--------------- -------------------------

SERVERINTERFACES CLEANUP USERSPACE1/USERSPACE1 GLOBAL CLEANUP USERSPACE1/USERSPACE1 CORE CLEANUP USERSPACE1/USERSPACE1 CFG> cleanup all Cleaning up for SERVERINTERFACES... Executing operations for state: CLEANUP Done Cleaning up for GLOBAL... Executing operations for state: CLEANUP Done Cleaning up for CORE... Executing operations for state: CLEANUP Done Cleaning up table used to track conversion... Done Finished converting this database. Closing database connection. cnvt> db subsys1 Using existing table 'CONVERT_743' to track conversion progress.

Table Name Conversion State Table/Index Space


--------------- -------------------------

BITFILE CLEANUP BITFILE/BITFILEIX SSPVHISTORY CLEANUP SSPVHISTORY/SSPVHISTORYIX NSTRASH CLEANUP NSTRASH/NSTRASHIX MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX SUBSYS1> cleanup all Cleaning up for BITFILE... Executing operations for state: CLEANUP Done Cleaning up for SSPVHISTORY... Executing operations for state: CLEANUP Done Cleaning up for NSTRASH... Executing operations for state: CLEANUP Done Cleaning up for MPSFORCEMIGRATE... Executing operations for state: CLEANUP Done Cleaning up table used to track conversion... Done Finished converting this database. Closing database connection. cnvt> quit


DB2 Stop:


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


HPSS Start

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


Mover upgrade:

On Core:

/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab hpssadm> server list hpssadm> server shutdown -id 8 (see the mover id process)

On Mover:

rpm -Uvh libtirpc-0.2.1-10.el6.x86_64.rpm libtirpc-devel-0.2.1-10.el6.x86_64.rpm rpm -Uvh hpss-lib-7.4.3-0.el6.x86_64.rpm hpss-clnt-7.4.3-0.el6.x86_64.rpm hpss-mvr-7.4.3-0.el6.x86_64.rpm warning: group hpss does not exist - using root


[root@hpsstmvr ~]# rpm -qa | grep -i hpss hpss-clnt-7.4.3-0.el6.x86_64 hpss-lib-7.4.3-0.el6.x86_64 hpss-mvr-7.4.3-0.el6.x86_64

ll /opt hpss->/hpss_src/hpss-7.4.2-1.el6 rm /opt/hpss cd /opt ln -s /hpss_src/hpss-7.4.3-0.el6

On Core start mover:

/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab hpssadm> server list hpssadm> server start -id 8