496
MP Server / Re: Install/Configure as non root user
« on: June 09, 2016, 06:15:04 AM »
Whats the actual benefit of installing as a non-root user? Not having to bug your system admins?
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
497
MP Server / Re: Install/Configure as non root user
« on: June 07, 2016, 07:13:15 AM »
I think there is some confusion on my end.
The new feature that was added to 9.5 was to INSTALL/CONFIGURE ondemand as a non-root user.
Correct me if I'm wrong
The new feature that was added to 9.5 was to INSTALL/CONFIGURE ondemand as a non-root user.
Correct me if I'm wrong
498
OD/WEK & JAVA API / Re: ODWEK Files
« on: June 03, 2016, 09:58:22 AM »
Does the install of odwek in Windows create/update/depend upon registry entries? Or it is simply an msi file that gets run?
499
OD/WEK & JAVA API / Re: ODWEK Files
« on: June 02, 2016, 11:00:43 AM »Nope, you need to use the full installer, and then only configure the components you need.
Does this mean that I need to install CMOD for windows/linux, and grab the correct files that I need to hand over?
500
OD/WEK & JAVA API / ODWEK Files
« on: June 01, 2016, 12:32:52 PM »
In version 9.5 for CMOD the ODWEK or OnDemand Web Enablement Kit is now bundled or included with the full install. Is there any way just to download \ install the ODWEK for the different platforms (windows, Linux, aix) without going through the full install?
After reading through this link (http://www.ibm.com/support/knowledgecenter/SSEPCD_9.5.0/com.ibm.ondemandtoc.doc/redbooks.htm ) I have found another link to a redbook describing the ODWEK platforms and install. Only chapter 12 talks about the install for the windows environment. See Referenced HTML Version of Redbook below.
http://www.redbooks.ibm.com/redbooks/SG246338/wwhelp/wwhimpl/js/html/wwhelp.htm
The end goal I am trying to accomplish is to supply the internal web team with the necessary files to install and use the odwek for (AIX, windows, and linux).
After reading through this link (http://www.ibm.com/support/knowledgecenter/SSEPCD_9.5.0/com.ibm.ondemandtoc.doc/redbooks.htm ) I have found another link to a redbook describing the ODWEK platforms and install. Only chapter 12 talks about the install for the windows environment. See Referenced HTML Version of Redbook below.
http://www.redbooks.ibm.com/redbooks/SG246338/wwhelp/wwhimpl/js/html/wwhelp.htm
The end goal I am trying to accomplish is to supply the internal web team with the necessary files to install and use the odwek for (AIX, windows, and linux).
501
MP Server / More 9.5 install questions
« on: May 23, 2016, 12:17:15 PM »
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?
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?
502
MP Server / Install/Configure as non root user
« on: May 12, 2016, 07:25:06 AM »
Greetings all,
I'm in the process of upgrading to 9.5 from 9.0.0.7 and I want to take advantage of the one new feature I've read about, but I can't seem to find the right documentation about it. I've read about (and heard at IBM road shows) about installing/configuring/running CMOD as a non-root user (such as ODADMIN, Admin, etc)
Correct me if I am wrong, but are these steps correct?:
1) Install CMOD as root
2) Configure CMOD (arsdb/arssycr, etc..) as root
3) Run ARSSOCKD as whatever user I would like
Am I right, or completely wrong? Thanks in advance as always folks!
I'm in the process of upgrading to 9.5 from 9.0.0.7 and I want to take advantage of the one new feature I've read about, but I can't seem to find the right documentation about it. I've read about (and heard at IBM road shows) about installing/configuring/running CMOD as a non-root user (such as ODADMIN, Admin, etc)
Correct me if I am wrong, but are these steps correct?:
1) Install CMOD as root
2) Configure CMOD (arsdb/arssycr, etc..) as root
3) Run ARSSOCKD as whatever user I would like
Am I right, or completely wrong? Thanks in advance as always folks!
503
MP Server / Re: New install, new issue (8.5.0.0 - 8.5.0.6)
« on: April 15, 2016, 09:52:02 AM »
checked that, looks good.
uid=0(root) gid=0(system) groups=996(db2util),1501(dbasys),993(sysadm),214(dbsysadm),991(sysadm1)
uid=0(root) gid=0(system) groups=996(db2util),1501(dbasys),993(sysadm),214(dbsysadm),991(sysadm1)
504
MP Server / Re: New install, new issue (8.5.0.0 - 8.5.0.6)
« on: April 15, 2016, 05:00:10 AM »
No JD I didn't that's my bad. I should have combined them.
I am trying to create an environment that mimics prod:
[@SRV@_ARCHIVE]
HOST=
PROTOCOL=2
PORT=0
SRVR_INSTANCE=ARCHIVE
SRVR_INSTANCE_OWNER=root
is what I am using in the ars.ini
btw- I started over and raised a PMR
I am trying to create an environment that mimics prod:
[@SRV@_ARCHIVE]
HOST=
PROTOCOL=2
PORT=0
SRVR_INSTANCE=ARCHIVE
SRVR_INSTANCE_OWNER=root
is what I am using in the ars.ini
btw- I started over and raised a PMR
505
MP Server / New install, new issue (8.5.0.0 - 8.5.0.6)
« on: April 14, 2016, 02:36:16 PM »
So I am building a lab environment running older versions of CMOD to anticipate an upgrade and going right to 8.5.0.0 gave me headaches with security issues. I ran the 8.5.0.6 binary and it completed OK. I am now getting this error when I run:
/usr/lpp/ars/bin/arsdb -I archive -cvf
[root@labbox:/usr/lpp/ars/bin]# ./arsdb -I archive -cvf
arsdb: Unable to load >DB2<
Creating the DB2 archive database
Illegal instruction(coredump)
Does anyone have any ideas? Also I am using RDF in production and I would like to mimic the environments as much as possible, so are there any special flags that I need to include?
Thanks in advance.
/usr/lpp/ars/bin/arsdb -I archive -cvf
[root@labbox:/usr/lpp/ars/bin]# ./arsdb -I archive -cvf
arsdb: Unable to load >DB2<
Creating the DB2 archive database
Illegal instruction(coredump)
Does anyone have any ideas? Also I am using RDF in production and I would like to mimic the environments as much as possible, so are there any special flags that I need to include?
Thanks in advance.
506
MP Server / Re: arsdb error on fresh install
« on: April 14, 2016, 04:20:12 AM »Unable to start database archive. SQLCODE = -1092
Still a file/user permissions issue.
https://www-01.ibm.com/support/docview.wss?uid=swg21437767
-JD.
JD- and this can cause this error when trying to run ARSDB?
507
MP Server / Re: arsdb error on fresh install
« on: April 13, 2016, 12:31:17 PM »
Tried all that and still stuck here at
Starting the DB2 archive database instance
Unable to start database archive. SQLCODE = -1092
arsdb: Unable to start the DB2 archive database instance
[root@aix71lab4:/usr/lpp/ars/bin]#
Starting the DB2 archive database instance
Unable to start database archive. SQLCODE = -1092
arsdb: Unable to start the DB2 archive database instance
[root@aix71lab4:/usr/lpp/ars/bin]#
508
MP Server / Re: arsdb error on fresh install
« on: April 13, 2016, 04:24:13 AM »
Heres what I am getting running this command as archive
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
Unable to create the archive database. err=-1326
arsdb: Unable to create the DB2 archive database
$
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
Unable to create the archive database. err=-1326
arsdb: Unable to create the DB2 archive database
$
509
MP Server / Re: arsdb error on fresh install
« on: April 12, 2016, 01:13:57 PM »
Didnt get that far with arsload.
per my ars.ini (as well as in other working environments)
Instance is archive
Owner is root
I am trying to execute via root
per my ars.ini (as well as in other working environments)
Instance is archive
Owner is root
I am trying to execute via root
510
MP Server / arsdb error on fresh install
« on: April 12, 2016, 06:02:32 AM »
I am creating a sandbox enviroment running 8.5 CMOD and 9.5 DB2...I know, old!
Installed db2
Created user archive, gave admin permissions
I created the instance archive, owner as root
I created the db archive
I activated the db
I verified I could connect to the db archive
when I go to run arsdbI get the following error: **********typo
arsdb -I archive -gcv
I get the following error:
Starting the DB2 archive database instance
Unable to start database archive. SQLCODE = -1092
arsdb: Unable to start the DB2 archive database instance
Has anyone seen this error before or know a resoluton?
Installed db2
Created user archive, gave admin permissions
I created the instance archive, owner as root
I created the db archive
I activated the db
I verified I could connect to the db archive
when I go to run arsdbI get the following error: **********typo
arsdb -I archive -gcv
I get the following error:
Starting the DB2 archive database instance
Unable to start database archive. SQLCODE = -1092
arsdb: Unable to start the DB2 archive database instance
Has anyone seen this error before or know a resoluton?