how to create additional instance in different diretory----Help

Question posted by: cat (Guest) on November 12th, 2005 06:04 AM

HiFolks,

I am newbie in DB2 ESE. Here is the question, I already created an
instance db2inst1 under file system /db2home/db2inst1 ( actually the
instance has been created after installation.) Now I want to create an
additional instance which the DB2PATH is point to /aix1/db2test. What
shall I do, I found in IBM doc says

You can change the location of the instance directory from DB2PATH
using
the DB2INSTPROF environment variable. You require write-access for the
instance directory. If you want the directories created in a path
other than
DB2PATH, you have to set DB2INSTPROF before entering the db2icrt
command.
For DB2 Universal Database Enterprise – Server Edition, you also need
to
declare that you are adding a new instance that is a partitioned
database
system.

But after I changed db2instprof ( set DB2INSTPROF=/aix1/db2test )and
using db2icrt -u db2fenc2 db2test, the new instance db2test still be
created in /db2home/db2inst1. Here is the question,
1. How to create a additional instance point to a different directory?
2. How to declare I am adding a new instance is a partitioned database
system?

I am running DB2 V8 ESE( enable partition function) FP2 on AIX4.3.3.

Did I misunderstand something. Please help, tips or docs. Thanks

Cat

Quote | Subscribe