Volume setup required for Advanced Copy Services DB2

Technote (FAQ)


Question

When setting up a DB2 instance that will utilize the Advanced Copy Services DB2 for backup, the configuration must be setup to have the instance home on a separate volume group from the database.

Answer

When attempting to perform a flashcopy of the DB2 database, it is failing on the volume group with the following error:



    The Volume Group for the default DB2 Database Path '/home/db2u003' is overlapping Volume Group for the User Data, System Data or Temporary Data.
    Please place the default Database Path on a separate Volume Group and perform a local backup

    Otherwise, you will be unable to recover your database using local restore.
    {date/time} ANS2708E An unexpected error was encountered processing a DB2 UDB request.

The problem is that the instance home directory /home/db2u003 is on the same volume group as the database. This is not allowed because the instance can have other databases in addition to this db.

The configuration must be setup with the instance home on a separate volume group. This restriction coincides with DB2 best practices which state that instance home and db data should not overlap since the instance home has system wide info related to several dbs.

It is also not recommend for other data to be on the same volume group as the database. However, the Advanced Copy Services DB2 product does not look at the other data and therefore will not stop the flash if other data exists on the DB2 data volume.

Product Alias/Synonym

TSM

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager for Advanced Copy Services
DB2 Snapshot

Software version:

5.3

Operating system(s):

AIX

Reference #:

1246632

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation