Db2

 View Only
Expand all | Collapse all

Need assistance with Windows snapshot write pause freeze thaw scripts.

  • 1.  Need assistance with Windows snapshot write pause freeze thaw scripts.

    Posted Sat June 19, 2021 03:19 PM

    I have a Dell EMC SC array, and am only using array based snapshots and replication. I am experiencing issues with restoring the volumes from a crashed state. My NTFS drives go to a read-only state after the DB2 databases complete crash recovery, causing Windows to be completely locked up. Researching this further, I found DB2 is not VSS aware, and I need to perform pre and post snapshot DB2 scripts to successfully write suspend these snaphots. I am experiencing issues trying to create these scripts.

    Server 2012 R2

    IBM DB2 11.1

    VMware ESXi 6.7

    I tried a bunch of commands similar to the below in DB2 command line window, with no lunch. Ideally, I need something in a bat file that can be run every 30 minutes. I have 14 total databases that would be paused temporarily until the snapshot is created.

    db2 connect to <db name>

    db2 set writer suspend for database

    <create snapshot on array>

    db2 set writer resume for datatabase

    Any insight or ideas would be helpful. I am also open to ideas with using Veeam or a different backup solution, however I am not finding any application consistent programs that utilize DB2 built-in.





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration


  • 2.  RE: Need assistance with Windows snapshot write pause freeze thaw scripts.

    Posted Wed July 21, 2021 12:10 PM

    I am testing pretty much all this as well with veeam, Win 2012R2, db2 10.5, and vmware (don't know version as I am just dba not vm admin). Hopefully today the vm admin will do a restore of the vm and we'll see if it works.

    When does it go into crash recovery? Are you running the suspend script just before the snapshot?





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration