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:
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.
05/31/06 15:07:43 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
TDP ACS TSM
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.