View source for hidden:Database Offline Backup on HPSS Test Core

1.'''Stop hpss'''

*1.1 [root@hpsstcr03 scripts]# /opt/hpss/bin/hpssadm.pl -U hpssssm -a /var/hpss/etc/hpss.unix.keytab
**hpssadm> server shutdown -all
**hpssadm> server list -all
  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  
**hpssadm> quit
*1.2 	Stop startup daemon
**root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss -d stop
*1.3 	Stop system manager
**root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss -m stop

2.'''Stop the database''' 

*2.1.	[root@hpsstcr03 scripts]# /opt/hpss/bin/rc.hpss stop
 SQL1064N  DB2STOP processing was successful.

3.'''Data base offline backup'''

*3.1	Start only the data base 
**it is necessary to stop and restart it in order to be sure all connections are closed
**It is possible to use "db2 quiesce instance hpssdb user hpssdb defer" "db2 force application all" "db2 deactivate db hcfg/hsubsys1" instead
**su - hpssdb
**db2start
*3.2	Take an offline backup for all databases(as hpssdb user)
**3.2.1 Take an offline backup for hcfg data base
***-bash-4.1$ db2 backup db hcfg to /db2_backup[1|2]/offline/hcfg compress
 Backup successful. The timestamp for this backup image is : 20160620134530
**3.2.1 take an offline backup for hsubsys1
***db2 backup db hsubsys1 to /db2_backup[1|2]/offline/hsubsys1 compress
 Backup successful. The timestamp for this backup image is : 20160620134852
**3.2.3 on the productive system do it for ghi datbase too
**3.2.4 exit #(exit from hpssdb user shell)

4. '''Offline backups on hpss test system:'''

*4.1 Offline backup of 7.4.3p3 before database restore on 16.06.2016 
**/db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160616105201.001
**/db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160616105224.001
*4.2 on 16.06.2016 a 7.4.3p2 database restore has been done.
**Here is an offline backup of 7.4.3p2 done on 20.06.2016
***/db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160620134530.001
***/db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160620134852.001
*4.3 hpss test system upgrade from 7.4.3p2 to 7.4.3p3 done on 20.06.2016
**Here is an offline backup of 7.4.3p3 done on 20.06.2016
***/db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20160620142740.001
***/db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20160620142756.001
*4.4 here is an offline backup of test system 7.4.3p3 taken on 13.02.2017
***/db2_backup/offline/hcfg/HCFG.0.hpssdb.DBPART000.20170213152722.001
***/db2_backup/offline/hsubsys1/HSUBSYS1.0.hpssdb.DBPART000.20170213152812.001


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