CMOD 8505 Installation error

[Murale]

-->We are trying brand new installation of CMOD 8505. After installing base 8500 without any errors, we encountered the following error when trying to create archive database and initial cmod tables:
/usr/lpp/ars/bin/arsdb -I archive -gcv
Starting the DB2 ARCHIVE database instance
The ARCHIVE instance has already been started
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
Database created with territory 'US', code page '1208', code set 'UTF-8' and collating sequence ''
Updating the ARCHIVE database configuration
Deactivating database ARCHIVE
The ARCHIVE database was not activated
Backing up the ARCHIVE database so that the updates can take effect
Unable to backup database ARCHIVE.  err=-2036
arsdb:  Unable to create the DB2 ARCHIVE database
-->In fact, it created the archive database but without CMOD system table. But when we tried the following command to create the CMOD system table, we got the following error:

 /usr/lpp/ars/bin/arsdb -I archive -rtvs
Creating table ondemand.arsag
DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "CREATE TABLE ONDEMAND.ARSAG ( name VARCHAR" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<values>". SQLSTATE=42601 -- SQLSTATE=42601, SQLCODE=-104
Failed while processing sql statement >CREATE TABLE ondemand.arsag ( name VARCHAR(60) NOT NULL, description VARCHAR(120) NOT NULL, agid INTEGER NOT NULL, agid_name VARCHAR( NOT NULL, db_seg CHAR(1) FOR BIT DATA NOT NULL, ann_type CHAR(1) FOR BIT DATA NOT NULL, db_exp_date INTEGER NOT NULL, db_mgrt_date INTEGER NOT NULL, sm_cache_doc INTEGER NOT NULL, resgrp INTEGER NOT NULL, load_id INTEGER NOT NULL, log INTEGER NOT NULL, load_id_suffix VARCHAR( NOT NULL, mgrt_cache_date INTEGER NOT NULL, reimport_exp_date INTEGER NOT NULL, sid INTEGER NOT NULL, expire_type CHAR(1) FOR BIT DATA NOT NULL, seg_rows INTEGER NOT NULL, seg_id INTEGER NOT NULL, obj_size INTEGER NOT NULL, type INTEGER NOT NULL, upd_userid VARCHAR(128), upd_date BIGINT, last_doc_date BIGINT, migr_srvr_str VARCHAR(254), sm_cache_delta INTEGER, database_name VARCHAR(, sm_cache_res INTEGER ) IN /usr/opt/db2/tmp1<
arsdb: Unable to create table ondemand.arsag

Please let me know, if you encountered something like this and any possible solutions/suggestions.
Thanks and appreciated for your time.

Murale

[Alessandro Perucchi]

Hello Murale,

Wow... nice error :-)

never seen such error.

I'm wondering, would it be possible to check the different configuration path?
All the entries in ars.dbfs and the following entries in ars.cfg:

ARS_DB2_DATABASE_PATH
ARS_DB2_PRIMARY_LOGPATH
ARS_DB2_ARCHIVE_LOGPATH
ARS_DB2_LOGFILE_SIZE
ARS_DB2_LOG_NUMBER

Something seems wrong in your configuration...

Another question, why 8.5.0.5, and not using 8.5.0.8?

Sincerely yours,
Alessandro

[Murale]

Thanks Alessandro.

In fact the issue was that we specified wrong information in the following:
ARS_DB_TABLESPACE.

We wanted to create the userspace1 tablespace (default one). Once this parameter was commented out and everything went on without any error. Since this is a dev server which has to match the prod version of CMOD (8505).

Murale