View source for hidden:Restore Test System 7.4.3p1 from DB2 OfflineBackup

1. '''Make a Bare Metal backup before starting restore'''

 /usr/sbin/rear mkbackup

2. '''List HPSS current configuration'''
 
 /opt/hpss/bin/lshpss -all > /db2_backup/lshpss-hpss7.4.3p3/lshpss-7.4.3p3_before_downgrade_to_7.4.3p2.txt

3. '''Stop HPSS'''

 hpssadm> server shutdown -all
 /opt/hpss/bin/rc.hpss -d stop
 /opt/hpss/bin/rc.hpss -m stop

4. '''Stop db2 and restart it in order to close all active connections. 
 Alternatively db2 quiesce instance <inst_name> restricted access immediate force connections....take a closer look at db2 documentation ...it was not tested here...
 http://www-01.ibm.com/support/docview.wss?uid=swg21636292)

 /opt/hpss/bin/rc.hpss stop
 su - hpssdb
 .  /var/hpss/hpssdb/sqllib/db2profile
 db2start

5. '''Make DB offline backup'''
 db2 backup db hcfg to /db2_backup/offline/hcfg compress
 db2 backup db hsubsys1 to /db2_backup/offline/hsubsys1 compress

6. '''Stop DB2'''

 db2stop

7. '''Restore db2/HPSS /7.4.3p1/ from an offline backup'''
 
 su - hpssdb
 .  /var/hpss/hpssdb/sqllib/db2profile
 db2start
 db2 list history backup since 20151201 for hcfg
 db2 "restore db hcfg from /db2_backup/offline/hcfg taken at 20151221154752"
 db2 "restore db hsubsys1 from /db2_backup/offline/hsubsys1 taken at 20151221154835"
 db2 "rollforward db hcfg to end of logs and complete"
 db2 "rollforward db hsubsys1 to end of logs and complete"
 db2 activate db hcfg
 db2 activate db hsubsys1
 NOTE:
 if you do not want the redo logs to applied do only complete turn off the rollforward state of the database
 db2 "rollforward db hcfg complete"
 db2 "rollforward db hsubsys1 complete"



8. '''Make hpss linkk to version 7.4.3p1'''
 
 rm /opt/hpss
 ln -s /hpss_src/hpss-7.4.3.1-0.el6 /opt/hpss
 /opt/hpss/bin/rc.hpss start

9. '''7.4.3p2 needs no DB2 conversion, simply make the link'''

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

10.  '''Make a link to 7.4.3p2 on test mover'''

11. '''Reconfigure HPSS'''

 Delete disk devices: delete files, delete cos, delete hierarchy, delete storage class. 
 Delete resource, export volume, delete disk/device

12. '''SCSI Library and drives'''

 library scan drive address on core
 /opt/hpss/bin/device_scan


 scan scsi drive address on mover
 sg_map -st -x -i ----> take generic drive /dev/sgXX
 /opt/hpss/bin/device_scan -t tape -s /dev/sgXX


13. '''STK Library and drive'''

 take device address from acsls maschine and define STK library in HPSS

14. '''If a tape volume cannot be removed do this:'''

 /opt/hpss/tools/unsupported/bin/removesegs -i1 -v TK0528 --delete-segments     (twice)

15. '''New cartridges in library iu1 hpss_test_01:'''
 
 TS0213JC
 TS0214JC

16. '''New cartridges in stk hpsst partition:'''

 TK024300
 TK024400

17. '''Write some files with patch 2'''

18. '''Set cartridges on read only'''

19. '''Upgrade to patch3 (see [[hidden:Upgrade Test System from 7.4.3p2 to 7.4.3p3|Upgrade Test System from 7.4.3p2 to 7.4.3p3]])

 read the files written with patch 2 and compare the checksums

20. '''Create new tape storage classes and enable Block Protection'''

 110 PrimaryCopySTK_T10KD E2EDP  
 111 SecondaryCopyIUT1_TS1140 E2EDP with BP enabled

21. '''Create new hierarchies 110,111,112'''

22. '''Create new COSs 110,111,112 with "hash algorithm"=MD5'''

23. '''Import new cartridges in SC110''' 

 TK024500
 TK024600
 TK024800
 TK024900

24. '''Import new cartridges in SC 111'''

 TS024600
 TS024700
 TS024800
 TS024900

25. '''Import new cartridges in old SC100 for migrate force tests'''

 TK052100
 TK052200
26. '''Import new cartridges in old sc101 for migrate force tests'''

 TS024400
 TS024500

 TK0521 set readonly
 TS0245 set readonly

27. '''Set p2 cartridges as read only TS0213,TS0214,TK0243,TK0244'''

28. '''Problem'''

 Migration does not run 
 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: "SELECT". Object: "HPSS.BFMIGRRECBITFILEVIEW".  SQLSTATE=42501)

29. '''This step was of no use'''

 See Conversion Guide 10.5.1)
 Stop hpss
 [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> mpsforcemigrategrant
 DB20000I  The SQL command completed successfully.
 DB20000I  The SQL command completed successfully.
 cnvt> quit
 start hpss 

30. '''Grant hpss user the required privileges''' 

 su - hpssdb
 db2 connect to hsubsys1
 bash-4.1$ db2 grant control on table hpss.BFMIGRRECBITFILEVIEW to user hpss
 DB20000I  The SQL command completed successfully.

 '''Migrations runs'''


----[[ hidden:HPSS|<small>back to HPPS main page</small>]]