DB2, IntelliSnap and Volumes

Last post 08-01-2019, 7:53 AM by elcattivo. 2 replies.
Sort Posts: Previous Next
  • DB2, IntelliSnap and Volumes
    Posted: 07-16-2019, 11:11 AM

    Hello!

     

    We're currently trying to get a DB2 Snapshot working with the IntelliSnap Agent.

    We followed the steps outlined in: https://documentation.commvault.com/commvault/v11_sp15/article?p=34146.htm#o34147

     

    But we ran in two problems:

    1) The logvolume is, contrary to what the FAQ says, also being snapshottet. I think that's because the mountpoint for the DB2 volume is /db2 and the mountpoint for the logvolume is /db2/instance/log_dir.

     

    2) Since it is an SAP-system we would like to include two additional Volumes, where SAP-data is stored.

     

    All volumes are on NFS.

     

    Is there a possibility to exclude the logvolume?

    Is there a possibility to include other volumes?

     

    Thank you in advance for your support.

    Kind Regards

    Rüdiger

     

  • Re: DB2, IntelliSnap and Volumes
    Posted: 07-16-2019, 1:04 PM

    Q1 . Is there a possibility to exclude the logvolume?

     There are two log volumes,

     1. One is archive log location which is not part of IntelliSnap backup and this location should point to disk location, you can change this location if it is pointing IntelliSnap volumes

    Please follow following BOL section for changing location

    (Modifying the DB2 Archive Path, Modifying the DB2 Audit Error Path and Modifying the DB2 Retrieve Path) please make sure new location should have 777 permissions   http://documentation.commvault.com/commvault/v11/article?p=14873.htm

     2. one is active log location which carries db2 active logs, this active log location is part of IntelliSnap backup, you can check this location in db2 database configuration parameter called “Path to log files”

    Q2. Is there a possibility to include other volumes?

    Yes you can add as many as you want to add SNAP volumes in DB2 database, this is done by db2 not from Commvault

    Commvault take IntelliSnap backup for all  the volumes that include the path listed in db2 SQL query "select dbpartitionnum, type, path from sysibmadm.dbpaths" for each database partition.

    Thanks

    Muhammad Baig

  • Re: DB2, IntelliSnap and Volumes
    Posted: 08-01-2019, 7:53 AM

    Hi Muhammad!

     

    Thank you for your response.

     

    Q1:

    Isn't it problematic to snapshot an active-log volume where there are a lot of changes in a short period of time? We don't have any experience with it but I would imagine that the snapshot would become rather big rather fast.

     

    Q2:

    We ended up not adding the additional volumes via the db2 commands but performing seperate Snapshots for them. They don't need to have the same timestamp so the database-team was more comfortable with this way.

     

    Thanks again,

    Rüdiger

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy