More 9.5 install questions

[jsquizz]

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?

[Alessandro Perucchi]

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

on the tab "Prerequisites" in the section "Runtime Environment", you can read that:

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:

  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:

Code Select Expand


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