Hello All,

Environment

DB2 9.7
AIX 6.1

While performing the SAP installation unknowingly the home directory of db2sid was set to /home/db2sid instead of /db2/db2sid . Due to this all the installation files were created under this location except the db which was created under /db2/SID since it's the SAP installation . Is there any standard procedure to move the instance files created under /home to /db2/db2sid . Appreciate your help .

Regards
Satish

db can be created on any place if specified with create db
to change this : backup - restore and specify where to create the db
the syntax is over here
RESTORE DATABASE - IBM DB2 9.7 for Linux, UNIX, and Windows

Hello,

Thanks for your reply . Since this is a SAP installation the db gets automatically installed in the /db2/ABC directory . Here the question about the sqllib directory, db2_software and environment variables are sitting under /home/db2abc instead of /db2/db2abc . Is there any stadard procedure to move these directories and env files to the /db2/db2abc directory .

Regards
Satish

sqllib is created with db2icrt
the home directory will get sqllib
you could try to move these files and make this new directory the home directory
if you don't - db2iupdt will again try to make sqllib in homedir

What I'd do is:

- use db2cfexp to save current configuration
- drop the instance
- make changes to the instance owner id (ie. change home dir)
- re-create the instance
- use db2cfimp to re-import info saved with db2cfexp