wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Unlock / delete snapshopts =====

As DB2 user list, unmount and delete snapshots:

<code>
$ db2acsutil query status
Instance   Database   Part Image Time     Status
========== ========== ==== ============== ========================================
db2inst    T24PRD        0 20130214151134 Remotely mountable + Repetitively restorable + Swap restorable + Physical protection + Full copy + Tape backup pending (614400 / 614400 MB)
db2inst    T24PRD        0 20130214121241 Remotely mountable + Repetitively restorable + Swap restorable + Physical protection + Full copy + Tape backup pending (614400 / 614400 MB)



$ fcmcli -f inquire

                   IBM Tivoli Storage FlashCopy(R) Manager offload agent
                 - Version 3, Release 1, Level 0.1  for AIX LF 64-bit -
                           Build: 536C generated on Feb 27 2012
              (c) Copyright IBM Corporation, 2000, 2012, All Rights Reserved.


-------------------------------------------------------------------------------
FMM8806I IBM Tivoli Storage FlashCopy(R) Manager  3.1.0.1 (536C) Feb 27 2012

FMM8800I The command is: query
FMM8801I Time: 2013-02-15-14.13.25.0656 --- PID: 20775074
#BACKUP 20130214151134
#BACKUP 20130214121241
#CLONE 20130204092859
#CLONE 20130104141824

FMM0020I End of program at: Fri Feb 15 14:13:26 2013.
FMM0021I Elapsed time: 01 sec.
FMM0024I Return code is: 0.


$ fcmcli -f unmount -B 20130214151134

                   IBM Tivoli Storage FlashCopy(R) Manager offload agent
                 - Version 3, Release 1, Level 0.1  for AIX LF 64-bit -
                           Build: 536C generated on Feb 27 2012
              (c) Copyright IBM Corporation, 2000, 2012, All Rights Reserved.

FMM0005I Start of program at: Fri Feb 15 14:14:32 2013.
FMM8800I The command is: unmount
FMM6501I Initializing 'unmount' request.
FMM6502I Executing 'unmount' request.

FMM1232I Executing operation 'unmount' on host 'db2server'.
FMM6901I Response to Init request.
FMM0172I Start of listing of exported volume groups/unmounting file systems ...
FMM0188I Trying to set the semaphore for the critical part of importing/exporting ...
0516-010 : Volume group must be varied on; use varyonvg command.
FMM0568I Removing volume group T24PRDtdp1 ....
FMM0569I Varied off and exported volume group : T24PRDtdp1
FMM0546I Removing device : hdisk41
FMM0546I Removing device : hdisk39
FMM0546I Removing device : hdisk38
FMM0546I Removing device : hdisk20
FMM0546I Removing device : hdisk18
FMM0546I Removing device : hdisk16
FMM0546I Removing device : hdisk14
FMM0546I Removing device : hdisk12
FMM0189I Semaphore released.
FMM0159I End of listing.
FMM0138I Time stamp: 02/15/13-14:14:36.
FMM0188I Trying to set the semaphore for the critical part of importing/exporting ...
FMM0189I Semaphore released.
FMM0159I End of listing.
FMM1233I Operation 'unmount' completed.
FMM6959I Script 'LIBPATH=/home/db2inst/sqllib/acs/pegasus /home/db2inst/sqllib/acs/fmcima -l /home/db2inst/acs -N unmount -f unmount' returned with code 0.
FMM6555I Selected snapshot backup with ID 'db2inst,T24PRD,20130214151134'.
FMM6503I Terminating 'unmount' request.
FMM6512I The 'unmount' request for database 'T24PRD' with partitions (0) processed successfully.
FMM0020I End of program at: Fri Feb 15 14:14:36 2013.
FMM0021I Elapsed time: 04 sec.
FMM0024I Return code is: 0.


$ db2acsutil delete
Instance   Database   Part Image Time     Host       First Log
========== ========== ==== ============== ========== ==========
db2inst    T24PRD        0 20130214151134 db2server1          1132
Are you sure (y/[n])?  y
Deleted.


db2inst    T24PRD        0 20130214121241 db2server1          1075
Are you sure (y/[n])?  y
Deleted.


db2inst    T24PRD        0 20121115142843 db2server1          1364
Are you sure (y/[n])?  n
Skipped.

db2inst    T24PRD        0 20121113142122 db2server1          1338
Are you sure (y/[n])?  n
Skipped.


$ db2acsutil query status
Instance   Database   Part Image Time     Status
========== ========== ==== ============== ========================================
$ fcmcli -f inquire

                   IBM Tivoli Storage FlashCopy(R) Manager offload agent
                 - Version 3, Release 1, Level 0.1  for AIX LF 64-bit -
                           Build: 536C generated on Feb 27 2012
              (c) Copyright IBM Corporation, 2000, 2012, All Rights Reserved.


-------------------------------------------------------------------------------
FMM8806I IBM Tivoli Storage FlashCopy(R) Manager  3.1.0.1 (536C) Feb 27 2012

FMM8800I The command is: query
FMM8801I Time: 2013-02-15-14.17.34.0772 --- PID: 12452012
#CLONE 20130204092859
#CLONE 20130104141824

FMM0020I End of program at: Fri Feb 15 14:17:36 2013.
FMM0021I Elapsed time: 02 sec.
FMM0024I Return code is: 0.


</code>
wiki

User Tools

Site Tools

Page Tools
