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

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

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