Need help to install CMOD on Linux

[gyanendu.gangrade]

Hi All,

Need help in installing training instance of CMOD 8.4 on Linux server using DB2 9.5.3.

But getting below error message -

[db2inst1@localhost config]$ /opt/ondemand/bin/arsdb -I archive -gcv
Starting the DB2 archive database instance
Unable to start database archive.  SQLCODE = -1390
arsdb:  Unable to start the DB2 archive database instance

[db2inst1@localhost config]$  /opt/ondemand/bin/arsdb -I archive -cv
Creating the DB2 archive database
Creating links for the following file:
        db2uext2
Do you wish to use DISK(1) or ADSM(2)?
Please specify 1 or 2:1
Using Locale 'en_US' and Codeset 'ISO8859-1'
Unable to create the archive database.  err=-1390
arsdb:  Unable to create the DB2 archive database


Here are the output of ars.* files

ars.ini
-------

[@SRV@_archive]
HOST=172.27.18.156
PROTOCOL=2
PORT=0
SRVR_INSTANCE=archive
SRVR_INSTANCE_OWNER=root
SRVR_OD_CFG=/opt/ondemand/config/ars.cfg
SRVR_DB_CFG=/opt/ondemand/config/ars.dbfs
SRVR_SM_CFG=/opt/ondemand/config/ars.cache


ars.cfg
-------

#######################
# Database Parameters #
#######################

#
# Database for OnDemand to use (Library Server Only)
#
ARS_DB_ENGINE=DB2

#
# Used for arstblsp command and reloading migrated tables (Library Server Only)
#   0 (import)
#   1 (load w/TSM - DB2 only)
#   2 (load w/DISK - DB2 only, using ARS_TMP)
#
ARS_DB_IMPORT=0

#
# Used to specify if the database supports partitioning (Library Server Only)
#   Blank (No partition support)
#
ARS_DB_PARTITION=
#ARS_DB_TABLESPACE=CMODB_TABLESPACE

########################################
# DB2 Parameters (Library Server Only) #
########################################
DB2INSTANCE=DB2INST1

#
# These parameters used only during database creation
#
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
ARS_DB2_LOGFILE_SIZE=1000
ARS_DB2_LOG_NUMBER=40



ars.dbfs
--------

# DEFINITIONS:
# Filesystem                        Tablespace Type (SMS)
# -------------------------------------------------------------
/home/db2inst1/db2inst1/NODE0000/CMODB    SMS


I have following doubts/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.
2) My above parameters correct or it need some changes.
3) If my DB2 instance (DB2INST1) have multiple databases like CMODB, CMDB etc, where to mention to point to CMODB.
4) Is it necessary to give ARS_DB_TABLESPACE or its optional.
5) I ran chown on arsdb* directories using archive user, it should be archive or root as instance owner is root.

Appreciate if anyone respond to my queries. Thanks a ton in advance.

Thanks,
Gyan

[Alessandro Perucchi]

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?

Code: [Select]

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:

Code: [Select]

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