So I've successfully upgraded from 8.5.0.6 and I am running 9.0.0.7. I am in the process of upgrading to 9.5.0.5.
I chose a different user for this "admin" and ran though the whole installation process--
./odaix.bin -i console <--successfully ran
fixpack 9.0.0.5 <--successfully ran
'
I then logged in as admin and attempted to run the commands to configure the "archive" database:
devel:/home/admin/IBM/ondemand/V9.5/bin>arsdb -I archive -efv
arsdb: ARS4014E Unable to load >DB2<
Illegal instruction(coredump)
I then did some digging and ran slibclean, db2ln, and also installed Rational, XL C++ Runtime (13.1.3.1, AIX) (All three of these I could NOT find in the documentation. All three looked good.
Now here is the error I am getting:
arsdb: ARS4014E Unable to load >DB2<
Illegal instruction
I then tried running arsdb -efv per documentation:
development:/home/admin>cd IBM/ondemand/V9.5/bin/
development:/home/admin/IBM/ondemand/V9.5/bin>arsdb -I archive -efv
ARS4024I Are you sure you wish to drop the database tables and/or
indexes:yes
ARS4030I Dropping index admin.arsag_name_idx
ARS4054E DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0204N
"ADMIN.ARSAG_NAME_IDX" is an undefined name. SQLSTATE=42704 --
IBM came back and said run arsdb -uv and here is what I get
development:/home/admin/IBM/ondemand/V9.5/bin>arsdb -uv
ARS4030I Dropping index admin.arsagindex_idx
ARS4129W Index does not exist admin.arsagindex_idx
ARS4026I Creating table admin.arsagindex
ARS4040I Reorganizing table admin.arsagindex
ARS4030I Dropping index admin.arscab_name_idx
ARS4129W Index does not exist admin.arscab_name_idx
ARS4030I Dropping index admin.arscab_cid_idx
ARS4129W Index does not exist admin.arscab_cid_idx
ARS4026I Creating table admin.arscab
ARS4040I Reorganizing table admin.arscab
ARS4030I Dropping index admin.arscab2fol_idx
ARS4129W Index does not exist admin.arscab2fol_idx
ARS4026I Creating table admin.arscab2fol
ARS4040I Reorganizing table admin.arscab2fol
ARS4030I Dropping index admin.arscabperms_idx
ARS4129W Index does not exist admin.arscabperms_idx
ARS4026I Creating table admin.arscabperms
ARS4040I Reorganizing table admin.arscabperms
ARS4030I Dropping index admin.arscfsodwork_idx
ARS4129W Index does not exist admin.arscfsodwork_idx
ARS4026I Creating table admin.arscfsodwork
ARS4040I Reorganizing table admin.arscfsodwork
ARS4030I Dropping index admin.arshold_name_idx
ARS4129W Index does not exist admin.arshold_name_idx
ARS4030I Dropping index admin.arshold_hid_idx
ARS4129W Index does not exist admin.arshold_hid_idx
ARS4026I Creating table admin.arshold
ARS4040I Reorganizing table admin.arshold
ARS4030I Dropping index admin.arsholdmap_idx
ARS4129W Index does not exist admin.arsholdmap_idx
ARS4026I Creating table admin.arsholdmap
ARS4040I Reorganizing table admin.arsholdmap
ARS4030I Dropping index admin.arsholdperms_idx
ARS4129W Index does not exist admin.arsholdperms_idx
ARS4026I Creating table admin.arsholdperms
ARS4040I Reorganizing table admin.arsholdperms
ARS4030I Dropping index admin.arsholdwork_idx
ARS4129W Index does not exist admin.arsholdwork_idx
ARS4026I Creating table admin.arsholdwork
ARS4040I Reorganizing table admin.arsholdwork
ARS4030I Dropping index admin.arscmfedwork_idx
ARS4129W Index does not exist admin.arscmfedwork_idx
ARS4026I Creating table admin.arscmfedwork
ARS4040I Reorganizing table admin.arscmfedwork
ARS4030I Dropping index admin.arsftiwork_idx
ARS4129W Index does not exist admin.arsftiwork_idx
ARS4026I Creating table admin.arsftiwork
ARS4040I Reorganizing table admin.arsftiwork
ARS4030I Dropping index admin.arscabnames_cid_idx
ARS4129W Index does not exist admin.arscabnames_cid_idx
ARS4026I Creating table admin.arscabnames
ARS4040I Reorganizing table admin.arscabnames
ARS4030I Dropping index admin.arsfolnames_fid_idx
ARS4129W Index does not exist admin.arsfolnames_fid_idx
ARS4026I Creating table admin.arsfolnames
ARS4040I Reorganizing table admin.arsfolnames
ARS4030I Dropping index admin.arsholdnames_hid_idx
ARS4129W Index does not exist admin.arsholdnames_hid_idx
ARS4026I Creating table admin.arsholdnames
ARS4040I Reorganizing table admin.arsholdnames
ARS4030I Dropping index admin.arsloadwork_idx
ARS4129W Index does not exist admin.arsloadwork_idx
ARS4030I Dropping index admin.arsloadwork_loadid_idx
ARS4129W Index does not exist admin.arsloadwork_loadid_idx
ARS4026I Creating table admin.arsloadwork
ARS4040I Reorganizing table admin.arsloadwork
ARS4054E DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0204N "admin.ARSSYS" is an undefined name. SQLSTATE=42704 -- SQLSTATE=42S02, SQLCODE=-204
arsdb: ARS4125I Failed while processing sql statement >SELECT COUNT(*) FROM admin.ARSSYS <
has anyone came across this issue/scenario?
Hello,
you are wrong, the pre-req for CMOD V9.5 are in the documentation:
http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1363650145499 (http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1363650145499)
on the tab "Prerequisites" in the section "Runtime Environment", you can read that:
Quote
XL C/C++ for AIX 13.1.2 and future fix packs 13.1.2
And if you read the README file in the installation directory of CMOD, it is also describe:
Quote
2.3) AIX Server
2.3.9.5.0.0) Release (9.5.0.0)
- Pre-reqs
- AIX 6.1 TL8 or later
- IBM XL C/C++ Runtime for AIX, V13.1
Well, now to your problem.
If you do in DB2, the following command:
db2> list tables
Do you see the table
ARSSYS ???
If not, but you see all other ARS tables, then something went really wrong...
And I would suggest to restore your backup from DB2.
Just for your info, you can upgrade from CMOD V8.5 -> V9.5 in one shot without doing any stop at V9.0.
The only need to do this stop at V9, is because you have RD/ODF, otherwise this is not needed.
http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21686051#900X
(http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21686051#900X)