Global Data Management Forum

 View Only
  • 1.  DB2 database backup recovery

    Posted Mon January 23, 2023 11:15 AM
    Hello,
    We are configured DB2 database for one of IBM ELM application and we are looking out the strategy of database backup at file system level in production environment.
    I am new from this point so need someone assistance.
    Thank You.
    Regards,
    Raj

    ------------------------------
    Raj Asthana
    ------------------------------


  • 2.  RE: DB2 database backup recovery

    Posted Tue January 24, 2023 04:19 AM
    Hi Raj,

    There are many different ways to protect DB2 databases.
    1. Snapshots
    2. Logical backup to a IBM Spectrum Protect server
    3. Logical backup to a filesystem

    Spictera Snapshot can be used to take snapshots of your DB2 instances, and save the data on an IBM Spectrum Protect backup server
    Spictera SPFS can be used to take logical backups of your DB2 instances, and store this on the IBM Spectrum Protect backup server
    DB2 backup database online use TSM is also an option
    DB2 backup database online to /a/path is also on option

    Let me know what your requirements are, so that we can help you with the best option for you

    info@spictera.com
    https://www.spictera.com

    Regards Tomas

    ------------------------------
    Tomas Dalebjörk
    ------------------------------



  • 3.  RE: DB2 database backup recovery

    Posted Tue January 24, 2023 05:16 AM
    Hi Raj,

    You can certainly do that but you have a number of considerations regarding recovery/restore and data consistency. (in flight transactions), file system layout etc. I would recommend to explore the regular Db2 backup/restore functionality first and then consider backup methods that are kind of a combination of Operating System technologies combined with Db2. 

    kind regards

    ------------------------------
    Guido Verbraak
    IBM Expert Labs
    ------------------------------



  • 4.  RE: DB2 database backup recovery

    Posted Tue January 24, 2023 05:41 AM
    one can queisce the database and perform regular filesystem backup, and later perform an unquisce
    But the time between the quiesce and unquiesce is not intended to be too long

    ------------------------------
    Tomas Dalebjörk
    ------------------------------



  • 5.  RE: DB2 database backup recovery

    Posted Tue January 24, 2023 07:07 AM
    Hi Raj
    Db2 has built-in support for IBM storage array flashcopy support.  What type of storage array are you using?
    Regards,

    ------------------------------
    Dale McInnis
    ------------------------------



  • 6.  RE: DB2 database backup recovery

    Posted Tue January 24, 2023 08:57 AM
    Yes, that is correct too!
    Forgot to mention that as an option too.

    So now you have several options.

    Snapshot using FlashCopy
    Snapshot with Spictera Snapshot using IBM Spectrum Protect
    Logical backup using IBM Spectrum Protect
    Logical backup to local filesystem
    Logical backup to Spictera SPFS mounted IBM Spectrum Protect

    ------------------------------
    Tomas Dalebjörk
    ------------------------------



  • 7.  RE: DB2 database backup recovery

    Posted Mon April 03, 2023 08:45 AM
    Edited by Andres Parada Tue April 04, 2023 11:00 AM

    IBM recommends using their native database backup and recovery tools to ensure data integrity and reliability. The DB2 database provides several backup and recovery tools, including the DB2 Backup and Recovery Tool, the DB2 Recovery Expert, and the DB2 Recovery Manager.

    To ensure that you have a reliable backup and recovery strategy in place, you should work with your DBA team and IBM support to determine the best backup and recovery tools and strategies for your specific application and environment.



    ------------------------------
    Daniel Mason
    ------------------------------