OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: Shannan on January 21, 2014, 03:16:51 PM

Title: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Shannan on January 21, 2014, 03:16:51 PM
I am trying to split up my DB2 DB and my OD server due to an issue with TSM V6+ and db2 conflict.  Is anyone doing this currently?  Are there any special considerations?  I have installed OD on a separate server from the db2 db and created the db2 catalog entries for the db/node, etc...  but am having issues getting the service start.  Have turned on tracing but so far haven't found issue.  Says it's an error in opening a file in the event monitor.  Suggestions from anyone would be appreciated.  Thanks.
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: jeffs42885 on January 21, 2014, 04:38:33 PM
So you are trying to place your instance of OnDemand On another box somewhere, and just run ARSSOCKD / Any other authentication methods on your LIBSERV, and ARSOBJD and have TSM nodes defined for each object server?
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Shannan on January 21, 2014, 06:28:40 PM
I would like to have TSM and all of my OnDemand services running on one server while having the OD db2 database on another server.  We don't have an extremely large OD system - but a much larger Content Manager system. 
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Shannan on January 21, 2014, 11:25:22 PM
maybe I can't do what I was wanting to - it seems that the library server expects db2 to be installed on the same server (looking for db2 dll's).  Would love any feedback on this please as I'm not as experienced with OD.  Thanks!
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Justin Derrick on January 22, 2014, 02:40:53 PM
You'd be better off moving TSM elsewhere -- but it shouldn't be required.  You didn't mention which platform you're on, or which version of TSM 6.x that you're on.  I know for a fact that CMOD 8.x + DB2 9.7+ TSM 6.3 co-exists on the same AIX server without issues.  I believe TSM 6.1 and 6.2 didn't play nicely when a DB2 instance was installed elsewhere on the server.

The only thing to remember is that now that TSM has DB2 'under the covers', you're going to need substantially more RAM for the server in order to keep things running smoothly.

If you're on TSM 6.1, consider moving up to TSM 6.3 soon -- TSM 5.5 and 6.1 will have their support withdrawn in April 2014.

-JD.
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Alessandro Perucchi on February 03, 2014, 08:01:27 AM
Shannan,

On which kind of server are you?

Windows? If yes, then you must separate CMOD and TSM (http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/topic/com.ibm.itsm.srv.install.doc/r_srv_knowfirst.html (http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/topic/com.ibm.itsm.srv.install.doc/r_srv_knowfirst.html))

Unix, then in that case you can have both at the same time in the same server, but you need to be careful.
You will need to link the DB2 libraries from your DB2 CMOD instance in <CMOD path>/lib64

Here is the list of library to link (at least with DB2 9.7)

then you can have the same box with TSM 6.X and CMOD DB2 in a Unix environment

Sincerely yours,
Alessandro
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Shannan on April 15, 2014, 06:33:10 PM
This is still presenting challenges.  Looking for anyone with experience with CMOD (8.5) with db2 on Windows that has used ODBC to access the CMOD DB from another server.  I have seen configuration diagrams that show this - some have not specified the os and some have shown zOS or Unix.  Can a remote DB be used with CMOD?  I have had differing input from IBM....
Title: Re: Running OD 8.5 server on separate server from DB2 DB - is anyone doing this?
Post by: Justin Derrick on April 16, 2014, 07:59:55 AM
I've never personally seen this under UNIX systems, so take this with a grain of salt:

DB2 has a client-server architecture.  If you're going to move the DB2 server off of the hardware where CMOD lives, you're still going to need the client component on your CMOD server, so that you can communicate with DB2.

Have you tried just installing the client?  Or does that still interfere with your local TSM installation?

-JD.