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