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 List

 	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. There is possible to use "db2 quiesce instance" instead)

su - hpssdb . /var/hpss/hpssdb/sqllib/db2profile db2start SQL1063N DB2START processing was successful.

• • 3.2 Take an offline backup for all databases
    • 3.2.1 Take an offline backup for hcfg data base

-bash-4.1$ db2 backup db hcfg to /db2_backup/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/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 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