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

---

back to HPPS main page