Hello Gyan,
From what I see, you have mixed up a little bit the different concept of instance, instance_owner, etc...
Since you are using the unix user db2inst1 with a database name CMODB, then you should have this in the ars.ini
ars.ini
-------
[@SRV@_archive]
HOST=172.27.18.156
PROTOCOL=2
PORT=0
SRVR_INSTANCE=CMODDB
SRVR_INSTANCE_OWNER=db2inst1
SRVR_OD_CFG=/opt/ondemand/config/ars.cfg
SRVR_DB_CFG=/opt/ondemand/config/ars.dbfs
SRVR_SM_CFG=/opt/ondemand/config/ars.cache
May I ask you what do you have choosen the following path for the database and logs?
ARS_DB2_DATABASE_PATH=/home/db2inst1/db2inst1/NODE0000/CMODB/arsdb
ARS_DB2_PRIMARY_LOGPATH=/home/db2inst1/db2inst1/NODE0000/CMODB/arsdb_primarylog
ARS_DB2_ARCHIVE_LOGPATH=/home/db2inst1/db2inst1/NODE0000/CMODB/arsdb_archivelog
and
/home/db2inst1/db2inst1/NODE0000/CMODB SMS
Because I have the impression you give the internal path of DB2, instead of using just a simple path...
I mean, just give path that makes sense for you:
ARS_DB2_DATABASE_PATH=/home/db2inst1/ars/CMODB/dbfs
ARS_DB2_PRIMARY_LOGPATH=/home/db2inst1/ars/CMODB/primarylog
ARS_DB2_ARCHIVE_LOGPATH=/home/db2inst1/ars/CMODB/archivelog
/home/db2inst1/ars/CMOD/dbfs-appg01
my base directory (/home/db2inst1), with the type of application (ars), and the database (CMODB). Then I attache the function of each part (dbfs, primarylog, archivelog or dbfs-appg01).
Everything with NODE000* is an internal path for DB2, so you shouldn't even bother about
I'll try to answer your questions:
1) I'm getting SQLCODE=-1390, stating unable to start/create "archive" database. But my DB2 instance is DB2INST1 and database is CMODB, so why is is picking archive database.
In ars.ini, you define the name of the Instance with the variable SRVR_INSTANCE, if you put archive, then CMOD will search for a DB called archive.
2) My above parameters correct or it need some changes.
I think, I've covered that already :-D
3) If my DB2 instance (DB2INST1) have multiple databases like CMODB, CMDB etc, where to mention to point to CMODB.
Check the answer 1), and to be precise, the "DB2INST1" is
not your DB2 instance, but DB2 instance owner.
4) Is it necessary to give ARS_DB_TABLESPACE or its optional.
It is optional, if you want to use it, then maybe look at the documentation (
http://publib.boulder.ibm.com/infocenter/cmod/v8r4m1/topic/com.ibm.ondemand.installingmp.doc/ars1i071504.htm#wq583)
The name of the table space for the OnDemand system tables. The value of this parameter must match an existing table space name in the database. You must have created the table space in DB2.5) I ran chown on arsdb* directories using archive user, it should be archive or root as instance owner is root.
It should be the DB2 Instance owner... in your case db2inst1.
Sincerely yours,
Alessandro