Upgrade Testsystem from 742 TO 743: Difference between revisions

From Lsdf
Jump to navigationJump to search
No edit summary
No edit summary
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''HPSS Migration (test system) 21.11.2013 Ahmmad & Dorin'''
'''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'''


;1.'''Shutdown hpss'''
;:1.1 '''Start hpssadm command line'''
/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
;:1.2 '''List all hpss running servers'''

**1.2 '''List all hpss running servers'''


hpssadm> server list
hpssadm> server list
Line 26: Line 25:
9 Connected PVR SCSI Enabled SCSI PVR hpsstcr03.lsdf.kit.edu hpsstcr03 637882b0-0830-11e4-85d7-40f2e9724ad2
9 Connected PVR SCSI Enabled SCSI PVR hpsstcr03.lsdf.kit.edu hpsstcr03 637882b0-0830-11e4-85d7-40f2e9724ad2


**1.3 '''Shutdown all servers'''
;:1.3 '''Shutdown all servers'''


hpssadm> server shutdown -all
hpssadm> server shutdown -all
Line 33: Line 32:
Shutdown the specified servers? y
Shutdown the specified servers? y


**1.4 '''Stop startup daemon'''
;:1.4 '''Stop startup daemon'''


[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -d stop
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -d stop


**1.5 '''Stop ssm system manager'''
;:1.5 '''Stop ssm system manager'''


[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -m stop
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -m stop


**1.5 '''Stop db2 processes'''
;:1.6 '''Stop db2 processes'''
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss stop
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss stop
Line 47: Line 46:
root 4306 1 0 Sep29 ? 00:08:32 /opt/ibm/db2/V10.5/bin/db2fmcd
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'''
;:1.7 '''Start only db2 in order to take an offline backup'''


[root@hpsstcr03 ~]# su - hpssdb
[root@hpsstcr03 ~]# su - hpssdb
Line 55: Line 54:
SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.


**1.7. '''DB2 offline backup'''
;:1.8 '''DB2 offline backup'''


-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
-bash-4.1$ db2 backup db hcfg to /db2_backup/offline/hcfg compress
Line 69: Line 68:
db2 backup db hsubsys1 to /db2_backup1/offline/hsubsys1 compress
db2 backup db hsubsys1 to /db2_backup1/offline/hsubsys1 compress
db2 backup db hghi to /db2_backup1/offline/hghi compress
db2 backup db hghi to /db2_backup1/offline/hghi compress
:

*2. '''Prerequisites'''
;2. '''Prerequisites'''
;:2.1 '''Turn off ASLR'''

**2.1 '''Turn off ASLR'''

vi /etc/sysctl.conf
vi /etc/sysctl.conf
kernel.randomize_va_space = 0
kernel.randomize_va_space = 0
;:2.2 '''REBOOT'''

**2.2 '''REBOOT'''

'''NOTICE on the productive core ASLR is already OK !!! '''
'''NOTICE on the productive core ASLR is already OK !!! '''
;:2.3 '''llibtirpc'''


**2.3 '''llibtirpc'''
[root@hpsstcr03 yum.repos.d]# yum-config-manager --enable rhel-6-server-rpms
[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 list llibtirpc
Line 173: Line 166:
V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
'''The authenticity has not been proofed'''
'''The authenticity has not been proofed'''
:

*3 '''Update HPSS'''
;3 '''Update HPSS'''
;:3.1 '''installed hpss rmps'''

**3.1 '''installed hpss rmps'''

[root@hpsstcr03 hpss-7.4.3]# rpm -qa| grep -i hpss
[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 184: Line 175:
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
;:3.2 '''Install new rpms'''

**3.2 '''Install new rpms'''
cd /root/Software/HPSS/hpss-7.4.3
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
[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
Line 202: Line 191:
4:hpss-doc ########################################### [ 80%]
4:hpss-doc ########################################### [ 80%]
Files for package hpss-doc installed under /hpss_src/hpss-7.4.3-0.el6
Files for package hpss-doc installed under /hpss_src/hpss-7.4.3-0.el6
;:3.3 '''Make link for db default'''

**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 -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
[root@hpsstcr03 db2]# ln -sf /opt/ibm/db2/default /hpss_src/hpss-7.4.3-0.el6/db2
;:3.4 '''upgrade core'''

**3.4 '''upgrade core'''

[root@hpsstcr03 hpss-7.4.3]# rpm -Uvh hpss-core-7.4.3-0.el6.x86_64.rpm
[root@hpsstcr03 hpss-7.4.3]# rpm -Uvh hpss-core-7.4.3-0.el6.x86_64.rpm
Preparing... ########################################### [100%]
Preparing... ########################################### [100%]
1:hpss-core ########################################### [100%]
1:hpss-core ########################################### [100%]
Files for package hpss-core installed under /hpss_src/hpss-7.4.3-0.el6
Files for package hpss-core installed under /hpss_src/hpss-7.4.3-0.el6
;:3.5 '''check the rpms'''

**3.5 '''check the rpms'''

[root@hpsstcr03 hpss-7.4.3]# rpm -qa | grep -i hpss
[root@hpsstcr03 hpss-7.4.3]# rpm -qa | grep -i hpss
hpss-mvr-7.4.3-0.el6.x86_64
hpss-mvr-7.4.3-0.el6.x86_64
Line 222: Line 206:
hpss-doc-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
hpss-clnt-7.4.3-0.el6.x86_64
:

;4 '''Database Conversion'''

*4 '''Database Conversion'''
;:4.1 '''Make hpss link'''

**4.1 '''Make hpss link'''
ln -s /hpss_src/hpss-7.4.3-0.el6 /opt/hpss
ln -s /hpss_src/hpss-7.4.3-0.el6 /opt/hpss
;:4.2 '''Update DBI driver'''

**4.2 '''Update DBI driver'''
[root@hpsstcr03 hpss]# source /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 hpss]# source /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 hpss]# yum install perl-DBI.x86_64
[root@hpsstcr03 hpss]# yum install perl-DBI.x86_64
Line 237: Line 218:
[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
;:4.3 '''Start db2'''

**4.3 '''Start db2'''
[root@hpsstcr03 DBD-DB2-1.84]# su - hpssdb
[root@hpsstcr03 DBD-DB2-1.84]# su - hpssdb
-bash-4.1$ . /var/hpss/hpssdb/sqllib/db2profile
-bash-4.1$ . /var/hpss/hpssdb/sqllib/db2profile
Line 246: Line 225:
SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
exit (from user hpssdb)
exit (from user hpssdb)
;:4.4 '''Start conversion as root:'''

**4.4 '''Start conversion as root:'''
[root@hpsstcr03 DBD-DB2-1.84]# source /var/hpss/hpssdb/sqllib/db2profile
[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
[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
Line 272: Line 250:
/opt/hpss/lib/libhpssldapauthz.so ldap_SECInitialize
/opt/hpss/lib/libhpssldapauthz.so ldap_SECInitialize
/opt/hpss/lib/libhpssunixauthz.so unix_SECInitialize
/opt/hpss/lib/libhpssunixauthz.so unix_SECInitialize
;:4.5 '''server acl'''


**4.5 '''server acl'''

[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/bin/hpss_server_acl
[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/bin/hpss_server_acl
hsa> acl -m
hsa> acl -m
Line 310: Line 285:




Convert the global database cfg using hpss_convertdb743
;: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


[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
Database Connection Information
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
Database server = DB2/LINUXX8664 10.5.3
SQL authorization ID = HPSSDB
SQL authorization ID = HPSSDB
Local database alias = CFG
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
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
Database server = DB2/LINUXX8664 10.5.3
SQL authorization ID = HPSSDB
SQL authorization ID = HPSSDB
Local database alias = CFG
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'''
DB20000I The REORG command completed successfully.
Conversion Time: 0 minutes 1 seconds
Done
CFG> count all


[root@hpsstcr03 DBD-DB2-1.84]# /opt/hpss/bin/hpss_managetables
Table Name Number of Rows
hmt> db subsys1
--------------- ---------------
Available tablespaces:
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
Owner Data
ID Tablespace Name Owner Type Type
ID Tablespace Name Owner Type Type
2 USERSPACE1 SYSIBM S L

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

Default tablespace: NOT SELECTED
Database: subsys1 [Subsystem database]
Default index tablespace: NOT SELECTED
Schema: HPSS
hmt> del subsys views
Default tablespace: NOT SELECTED
Deleting BFMIGRRECBITFILEVIEW
Default index tablespace: NOT SELECTED
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
hmt> del subsys views
---Handle 65538---
Deleting BFMIGRRECBITFILEVIEW
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
DB error rc = -1 reported from SQLExecute, mm_execute.c: near line 683
---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>
hmt> del subsys1 views
Syntax error. Type "help" for help.
hmt>
hmt> del subsys1 views
hmt> del subsys views
Deleting BFMIGRRECBITFILEVIEW
Syntax error. Type "help" for help.
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
hmt> del subsys views
---Handle 65538---
Deleting BFMIGRRECBITFILEVIEW
Failed to delete view BFMIGRRECBITFILEVIEW: RC: -2001, Failed to execute statement (mm_execute.c, line 686)
DB error rc = -1 reported from SQLExecute, mm_execute.c: near line 683
---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


****************************************************************************

9.5.6.2

convert subsys1:


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


[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
Table Name Conversion State Table/Index Space
HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections.
--------------- --------------- -------------------------
Password for hpssdb:
BITFILE START BITFILE/BITFILEIX
cnvt> db subsys1
SSPVHISTORY START SSPVHISTORY/SSPVHISTORYIX
Creating table 'CONVERT_743' to track conversion progress...
NSTRASH START <UNDEF>/<UNDEF>
Making entry for table BITFILE
MPSFORCEMIGRATE START <UNDEF>/<UNDEF>
Making entry for table SSPVHISTORY
SUBSYS1> count all
Making entry for table NSTRASH
Available commands:
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
cleanup Cleanup after conversion
close Disconnect from a database
close Disconnect from a database
Line 524: Line 479:
state Show the current state of conversion
state Show the current state of conversion
ts Set the tablespace to use
ts Set the tablespace to use
SUBSYS1> count all
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
Table Name Number of Rows
Converting BITFILE...
--------------- ---------------
Executing operations for state: START
BITFILE 24
Executing operations for state: CREATE
SSPVHISTORY 0
Executing operations for state: FILL
NSTRASH <undef>
Executing operations for state: DEPLOY
MPSFORCEMIGRATE <undef>
Conversion Time: 0 minutes 5 seconds
SUBSYS1> state
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 Conversion State Table/Index Space
Table Name Number of Rows
--------------- --------------- -------------------------
--------------- ---------------
BITFILE START BITFILE/BITFILEIX
SSPVHISTORY START SSPVHISTORY/SSPVHISTORYIX
BITFILE 24
NSTRASH START <UNDEF>/<UNDEF>
SSPVHISTORY 0
MPSFORCEMIGRATE START <UNDEF>/<UNDEF>
NSTRASH 0
MPSFORCEMIGRATE 0
SUBSYS1> convert all
Converting BITFILE...
SUBSYS1> state
Executing operations for state: START
Table Name Conversion State Table/Index Space
Executing operations for state: CREATE
--------------- --------------- -------------------------
Executing operations for state: FILL
BITFILE CLEANUP BITFILE/BITFILEIX
Executing operations for state: DEPLOY
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
Conversion Time: 0 minutes 5 seconds
NSTRASH CLEANUP NSTRASH/NSTRASHIX
Done
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
Converting SSPVHISTORY...
SUBSYS1> quit
Executing operations for state: START
:
Executing operations for state: CREATE
'''Revert:'''
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


[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
FAILED. Examine error, then check status with the 'state' command.
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
Converting NSTRASH...
Table Name Conversion State Table/Index Space
Executing operations for state: START
--------------- --------------- -------------------------
Executing operations for state: CREATE
BITFILE CLEANUP BITFILE/BITFILEIX
Executing operations for state: FILL
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
Executing operations for state: DEPLOY
NSTRASH CLEANUP NSTRASH/NSTRASHIX
Conversion Time: 0 minutes 1 seconds
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
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


SUBSYS1> revert all
Table Name Number of Rows
ALL is not valid. Valid tables are:
--------------- ---------------
BITFILE 24
Table Name Conversion State Table/Index Space
--------------- --------------- -------------------------
SSPVHISTORY 0
NSTRASH 0
BITFILE CLEANUP BITFILE/BITFILEIX
MPSFORCEMIGRATE 0
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
NSTRASH CLEANUP NSTRASH/NSTRASHIX
SUBSYS1> state
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX


SUBSYS1> revert BITFILE
Table Name Conversion State Table/Index Space
Reverting BITFILE...
--------------- --------------- -------------------------
Running revert operations
BITFILE CLEANUP BITFILE/BITFILEIX
Done
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
NSTRASH CLEANUP NSTRASH/NSTRASHIX
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
SUBSYS1> quit


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'''
Revert:


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:
[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
. /var/hpss/hpssdb/sqllib/db2profile
HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections.
/opt/hpss/bin/hpss_managetables
Password for hpssdb:
cnvt> db subsys1
hmt> db subsys1
hmt> del subsys views
Using existing table 'CONVERT_743' to track conversion progress.
hmt> del subsys views
hmt> commit
Transaction committed
hmt> quit


Table Name Conversion State Table/Index Space
'''See Conversion guide 9.5.6.2'''
--------------- --------------- -------------------------
BITFILE CLEANUP BITFILE/BITFILEIX
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
NSTRASH CLEANUP NSTRASH/NSTRASHIX
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
SUBSYS1> state


[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
Table Name Conversion State Table/Index Space
HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections.
--------------- --------------- -------------------------
Password for hpssdb:
BITFILE CLEANUP BITFILE/BITFILEIX
cnvt> db subsys1
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
Using existing table 'CONVERT_743' to track conversion progress.
NSTRASH CLEANUP NSTRASH/NSTRASHIX
Table Name Conversion State Table/Index Space
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
--------------- --------------- -------------------------
SUBSYS1> revert all
BITFILE DEPLOY BITFILE/BITFILEIX
ALL is not valid. Valid tables are:
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
Table Name Conversion State Table/Index Space
Converting BITFILE...
--------------- --------------- -------------------------
Executing operations for state: DEPLOY
BITFILE CLEANUP BITFILE/BITFILEIX
Conversion Time: 0 minutes 1 seconds
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
Done
NSTRASH CLEANUP NSTRASH/NSTRASHIX
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
SUBSYS1> revert BITFILE
SUBSYS1> convert SSPVHISTORY
Converting SSPVHISTORY...
Reverting BITFILE...
Running revert operations
Executing operations for state: DEPLOY
Conversion Time: 0 minutes 0 seconds
Done
Done
SUBSYS1> revert NSTRASH
Reverting NSTRASH...
SUBSYS1> convert NSTRASH
Running revert operations
Converting NSTRASH...
Done
Executing operations for state: DEPLOY
SUBSYS1> revert MPSFORCEMIGRATE
Conversion Time: 0 minutes 1 seconds
Reverting MPSFORCEMIGRATE...
Done
Running revert operations
Done
SUBSYS1> state


SUBSYS1> convert MPSFORCEMIGRATE
Table Name Conversion State Table/Index Space
Converting MPSFORCEMIGRATE...
--------------- --------------- -------------------------
Executing operations for state: DEPLOY
BITFILE DEPLOY BITFILE/BITFILEIX
Conversion Time: 0 minutes 0 seconds
SSPVHISTORY DEPLOY SSPVHISTORY/SSPVHISTORYIX
Done
NSTRASH DEPLOY NSTRASH/NSTRASHIX
MPSFORCEMIGRATE DEPLOY MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
SUBSYS1>


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'''
******************************************
Problem :


[root@hpsstcr03 ~]# /opt/hpss/bin/hpss_managetables

hmt> db subsys1
9.6.5.1 check why hpss authorization id faild
Available tablespaces:



****************************************************************************************************

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
Owner Data
ID Tablespace Name Owner Type Type
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
2 USERSPACE1 SYSIBM S L
Adding BFMIGRRECBITFILEVIEW
3 ACCOUNTING HPSSDB U L
Adding NSTRASHVIEW
4 ACCOUNTINGIX HPSSDB U L
Adding STORAGESEGDISKVIEW
5 BFCOSCHANGE HPSSDB U L
Adding STORAGESEGTAPEVIEW
6 BFCOSCHANGEIX HPSSDB U L
Adding VVDISKVIEW
7 BFDISKALLOCREC HPSSDB U L
Adding VVTAPEVIEW
8 BFDISKALLOCRECIX HPSSDB U L
Adding VVTAPEMAPVIEW
9 BFDISKSEG HPSSDB U L
hmt> add subsys constraints
10 BFDISKSEGIX HPSSDB U L
Adding BFTAPESEGCON1
11 BFMIGRREC HPSSDB U L
Adding DISKSEGEXTENTSCON1
12 BFMIGRRECIX HPSSDB U L
Adding DISKVVMAPCON1
13 BFPURGEREC HPSSDB U L
Adding DISKVVPVCON1
14 BFPURGERECIX HPSSDB U L
Adding DISKVVSEGSCON1
15 BFSSEGCHKPT HPSSDB U L
Adding TAPESEGABSADDRCON1
16 BFSSEGCHKPTIX HPSSDB U L
Adding TAPESEGAUXCON1
17 BFTAPESEG HPSSDB U L
Adding TAPEVVMAPCON1
18 BFTAPESEGIX HPSSDB U L
Adding SSPVHISTORYCON1
19 BITFILE HPSSDB U L
Adding TAPEVVPVCON1
20 BITFILEIX HPSSDB U L
Adding TAPEVVSEGSCON1
21 DISKSEGUNLINK HPSSDB U L
Adding NSOBJECTUSERATTRS1
22 DISKSEGUNLINKIX HPSSDB U L
23 DMGFILESET HPSSDB U L
hmt> add indexes vvdisk
24 DMGFILESETIX HPSSDB U L
Creating indexes for table VVDISK
25 MPSCHKPT HPSSDB U L
ALTER TABLE VVDISK ADD CONSTRAINT VVDISK_PKEY PRIMARY KEY ( VVID)
26 MPSCHKPTIX HPSSDB U L
The primary key was not created because VVDISK already has a primary key.
27 NSACL HPSSDB U L
This is assumed not to be an error. If this is an error, you must remove
28 NSACLIX HPSSDB U L
the primary key constraint and then run this command again.
29 NSFILESETATTR HPSSDB U L
Use 'del indexes VVDISK' to remove the indexes and primary key constraint.
30 NSFILESETATTRIX HPSSDB U L
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
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


hmt> add indexes vvtape
Database: subsys1 [Subsystem database]
Creating indexes for table VVTAPE
Schema: HPSS
ALTER TABLE VVTAPE ADD CONSTRAINT VVTAPE_PKEY PRIMARY KEY ( VVID)
Default tablespace: NOT SELECTED
The primary key was not created because VVTAPE already has a primary key.
Default index tablespace: NOT SELECTED
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'''
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
new db2 backup to /db2_backup/offline/ba_after_conversion/hcfg
/db2_backup/offline/ba_after_conversion/subsys
/db2_backup/offline/ba_after_conversion/subsys


9.5.6.6
'''Conversion Guide 9.5.6.6'''


[root@hpsstcr03 ~]# . /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 ~]# . /var/hpss/hpssdb/sqllib/db2profile
[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
[root@hpsstcr03 ~]# /opt/hpss/tools/convert743/hpss/hpss_convertdb743
HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections.
HPSS_DB_INSTANCE_OWNER is set - Using 'hpssdb' for database connections.
Password for hpssdb:
Password for hpssdb:
cnvt> db cfg
cnvt> db cfg
Using existing table 'CONVERT_743' to track conversion progress.
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
Table Name Conversion State Table/Index Space
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
BITFILE CLEANUP BITFILE/BITFILEIX
SSPVHISTORY CLEANUP SSPVHISTORY/SSPVHISTORYIX
CFG> cleanup all
NSTRASH CLEANUP NSTRASH/NSTRASHIX
Cleaning up for SERVERINTERFACES...
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
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.


SUBSYS1> cleanup all
Table Name Conversion State Table/Index Space
Cleaning up for BITFILE...
--------------- --------------- -------------------------
Executing operations for state: CLEANUP
BITFILE CLEANUP BITFILE/BITFILEIX
Done
SSPVHISTORY CLEANUP SSPVHISTORY/SSPVHISTORYIX
Cleaning up for SSPVHISTORY...
NSTRASH CLEANUP NSTRASH/NSTRASHIX
Executing operations for state: CLEANUP
MPSFORCEMIGRATE CLEANUP MPSFORCEMIGRATE/MPSFORCEMIGRATEIX
Done
SUBSYS1> cleanup all
Cleaning up for BITFILE...
Cleaning up for NSTRASH...
Executing operations for state: CLEANUP
Executing operations for state: CLEANUP
Done
Done
Cleaning up for SSPVHISTORY...
Cleaning up for MPSFORCEMIGRATE...
Executing operations for state: CLEANUP
Executing operations for state: CLEANUP
Done
Done
Cleaning up for NSTRASH...
Cleaning up table used to track conversion... Done
Finished converting this database. Closing database connection.
Executing operations for state: CLEANUP
cnvt> quit
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
DB2 Stop:
. /var/hpss/hpssdb/sqllib/db2profile
db2stop




'''HPSS Start as root'''
su - hpssdb
. /var/hpss/hpssdb/sqllib/db2profile
db2stop


/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:'''
HPSS Start


'''On Core:'''
as root:
/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:'''
/opt/hpss/bin/rc.hpss start
rpm -Uvh libtirpc-0.2.1-10.el6.x86_64.rpm libtirpc-devel-0.2.1-10.el6.x86_64.rpm
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
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
server start -all
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:'''
Mover upgrade:
/opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab

hpssadm> server list
On Core:
hpssadm> server start -id 8

/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

Latest revision as of 16:58, 21 June 2016

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

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