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''' |
|||
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''' |
|||
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -d stop |
[root@hpsstcr03 /]# /opt/hpss/bin/rc.hpss -d stop |
||
;: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.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.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.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.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.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.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 |
|||
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] |
|||
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 |
|||
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 |
[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 |
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 |
|||
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 |
[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 |
|||
BITFILE 24 |
|||
SSPVHISTORY 0 |
|||
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: |
|||
--------------- --------------- |
|||
Table Name Conversion State Table/Index Space |
|||
--------------- --------------- ------------------------- |
|||
SSPVHISTORY 0 |
|||
BITFILE CLEANUP BITFILE/BITFILEIX |
|||
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: |
|||
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 |
|||
'''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> |
SUBSYS1> convert SSPVHISTORY |
||
Converting SSPVHISTORY... |
|||
Reverting BITFILE... |
|||
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 |
|||
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 |
Cleaning up for NSTRASH... |
||
Executing operations for state: CLEANUP |
Executing operations for state: CLEANUP |
||
Done |
Done |
||
Cleaning up for |
Cleaning up for MPSFORCEMIGRATE... |
||
Executing operations for state: CLEANUP |
Executing operations for state: CLEANUP |
||
Done |
Done |
||
Cleaning up |
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