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(as hpssdb user)
  • 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