Hello,
I'm installing an ibm CMOD 8.4.1 on a vm windows 2008 R2.
After creating the DB with the command db2 create db archive and the ondemand system table with arsdb.exe -I archive -rtv. I'm not able to initialize the system log table and System load table.
Below the logs :
C:\IBM\OnDemand for WinNT\bin>db2 create db archive
DB20000I The CREATE DATABASE command completed successfully.
-------------
C:\IBM\OnDemand for WinNT\bin>arsdb.exe -I archive -rtv
Creating table db2admin.arsag
Creating index db2admin.arsag_name_idx
Creating index db2admin.arsag_agid_idx
Creating table db2admin.arsag2fol
Creating index db2admin.arsag2fol_idx
Creating table db2admin.arsagfld
Creating index db2admin.arsagfld_idx
Creating table db2admin.arsagfldalias
Creating index db2admin.arsagfldalias_idx
Creating table db2admin.arsagindex
Creating index db2admin.arsagindex_idx
Creating table db2admin.arsagperms
Creating index db2admin.arsagperms_idx
Creating table db2admin.arsann
Creating index db2admin.arsann_idx
Creating table db2admin.arsapp
Creating index db2admin.arsapp_idx
Creating table db2admin.arsappusr
Creating index db2admin.arsappusr_idx
Creating table db2admin.arscab
Creating index db2admin.arscab_name_idx
Creating index db2admin.arscab_cid_idx
Creating table db2admin.arscab2fol
Creating index db2admin.arscab2fol_idx
Creating table db2admin.arscabperms
Creating index db2admin.arscabperms_idx
Creating table db2admin.arscfsodwork
Creating index db2admin.arscfsodwork_idx
Creating table db2admin.arsfol
Creating index db2admin.arsfol_name_idx
Creating index db2admin.arsfol_fid_idx
Creating table db2admin.arsfolfld
Creating index db2admin.arsfolfld_idx
Creating table db2admin.arsfolfldusr
Creating index db2admin.arsfolfldusr_idx
Creating table db2admin.arsfolperms
Creating index db2admin.arsfolperms_idx
Creating table db2admin.arsgroup
Creating index db2admin.arsgroup_gid_idx
Creating index db2admin.arsgroup_name_idx
Creating table db2admin.arshold
Creating index db2admin.arshold_name_idx
Creating index db2admin.arshold_hid_idx
Creating table db2admin.arsholdmap
Creating index db2admin.arsholdmap_idx
Creating table db2admin.arsholdperms
Creating index db2admin.arsholdperms_idx
Creating table db2admin.arsholdwork
Creating index db2admin.arsholdwork_idx
Creating table db2admin.arsload
Creating index db2admin.arsload_idx
Creating index db2admin.arsload_name_idx
Creating table db2admin.arsnameq
Creating index db2admin.arsnameq_idx
Creating table db2admin.arsnode
Inserting default values into table db2admin.arsnode
Creating index db2admin.arsnode_idx
Creating table db2admin.arsprt
Creating index db2admin.arsprt_name_idx
Creating index db2admin.arsprt_pid_idx
Creating table db2admin.arsprtopts
Creating index db2admin.arsprtopts_idx
Creating table db2admin.arsprtusr
Creating index db2admin.arsprtusr_idx
Creating table db2admin.arsres
Creating index db2admin.arsres_idx
Creating table db2admin.arsseg
Creating index db2admin.arsseg_name_idx
Creating index db2admin.arsseg_idx
Creating index db2admin.arsseg_cdate_idx
Creating table db2admin.arsset
Inserting default values into table db2admin.arsset
Creating index db2admin.arsset_name_idx
Creating index db2admin.arsset_sid_idx
Creating table db2admin.arssys
Inserting default values into table db2admin.arssys
Creating table db2admin.arsuser
Inserting default values into table db2admin.arsuser
Creating index db2admin.arsuser_id_idx
Creating index db2admin.arsuser_name_idx
Creating table db2admin.arsusrgrp
Creating index db2admin.arsusrgrp_idx
Creating table db2admin.arsusrgrpid
Creating index db2admin.arsusrgrpid_idx
C:\IBM\OnDemand for WinNT\bin>arsdb.exe -vy C:
Backing up the DB2 ARCHIVE database offline
Deactivating database ARCHIVE
The ARCHIVE database was not activated
Backing up the DB2 ARCHIVE database at 11/30/15 08:10:50
Timestamp for backup image is: 20151130081051
C:\IBM\OnDemand for WinNT\bin>arssyscr.exe -I archive -l
arssyscr: Updating db2admin.ARSSYS
arssyscr: Updating db2admin.ARSSYS
arssyscr: Updating UPDATE db2admin.ARSSYS SET id = 5006 WHERE CURRENT OF S
QL_CURSH200C4.ARSSYS
arssyscr: Adding to db2admin.ARSAG with Storage Set Id = 0
arssyscr: Adding to db2admin.ARSAGPERMS
arssyscr: Adding to db2admin.ARSAGFLD
arssyscr: Adding to db2admin.ARSAGFLDALIAS
arssyscr: Adding to db2admin.ARSAGINDEX
arssyscr: Adding to db2admin.ARSAPPUSR
arssyscr: Adding to db2admin.ARSAPP
arssyscr: Adding to db2admin.ARSAG2FOL
arssyscr: Adding to db2admin.ARSFOL
arssyscr: Adding to db2admin.ARSFOLPERMS
arssyscr: Adding to db2admin.ARSFOLFLD
arssyscr: Adding to db2admin.ARSFOLFLDUSR
DB Error: [IBM][CLI Driver][DB2/NT64] SQL0117N The number of values assigned is
not the same as the number of specified or implied columns or variables. SQLST
ATE=42802 -- SQLSTATE=21S01, SQLCODE=-117
can anyone help me.
thank you
Hello,
why do you want to install CMOD V8.4.1? It is not supported anymore...
Which version of CMOD V8.4.1 do you have exactly? Can you give us the exact Fix Pack?
Did you try to run "arssyscr -I archive -l" again? Maybe that works... sometimes the first time it doesn't work...
And use the -c option in CMOD to create the database, don't do it manually (because you're omitting crucial database configuration options!).
-JD.
Hello,
Finnaly i installed and configured the 9.5 version and that works (Y)
Thanks for your help.
M.M