hidden:Database Offline Backup on HPSS Test Core

From Lsdf
Jump to navigationJump to search

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