AIX 5.3
DB2 8.1 FP2

We have noticed our /home filesystem on AIX filling up and it seems related to the fact that we have for some unknown reason found out that one of our larger database's has a local database directory like the below

Database alias = AVC
Database name = AVC
Local database directory = /home/avcpb1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0


What we would like the entry to be is the following:

Database alias = AVC
Database name = AVC
Local database directory = /archive/prodb/DB2/avcpb1/avc
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0


Is there a way to do this without affecting any of the data in the database?

thanks in advance

Mark

Another DB2Move Question

thanks for the info

I tried it out in our development environment and had the below results

$ more relocate
DB_NAME=SALES_DB
DB_PATH=/home/avcd1,/archive/devz/DB2/avcd1/sales_db
INSTANCE=avcd1
$ chmod 755 relocate
$ db2relocatedb -f relocate
DBT1007N An error occurred while attempting to perform operation "read" on file/device "/archive/devz/DB2/avcd1/sales_db/avcd1/NODE0000/sqldbdir/sqldbdir".

$ ls -ltr /archive/devz/DB2/avcd1/sales_db/avcd1/NODE*
total 8
drwxrwsrwx 2 avcd1 avcd1 512 Sep 17 12:04 sqldbdir

$ ls -ltr /archive/devz/DB2/avcd1/sales_db/avcd1/NODE*/*
total 0
-rwxrwxrwx 1 avcd1 avcd1 0 Sep 17 12:04 sqldbdir

I opened up all permissions on the file in question and it still doesn't work, any suggestions?

thanks in advance

Mark