View source for Upgrade Testsystem from 742 TO 743

'''HPSS Migration (test system) 21.11.2013 Ahmmad & Dorin'''

'''It was an unsuccessful upgrade, a revert has been done and a new attempt in Upgrade_Testsystem_from_742_To_743p1'''

;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.6 '''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.7 '''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.8 '''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<br>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



;:4.6 '''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]#  

;:4.7 '''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<br>to perform the operation.  Authorization ID: "HPSS".  Operation: "DROP VIEW". Object: "HPSS.BFMIGRRECBITFILEVIEW".  SQLSTATE=42501
 
 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<br>to perform the operation.  Authorization ID: "HPSS".  Operation: "DROP VIEW". Object: "HPSS.BFMIGRRECBITFILEVIEW".  SQLSTATE=42501
 hmt> quit

;:4.8 '''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

'''See Conversion guide 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

'''See Conversion Guide 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<br>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<br>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

'''Conversion Guide 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

'''Conversion Guide 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

 '''Start mover on core:'''
 /opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
 hpssadm> server list
 hpssadm> server start -id 8