Re: [stellation-res] setting up stellation with DB2

[Dave Shields <shields@xxxxxxxxxxxxxx>]

On Wed, Jul 17, 2002 at 01:03:25PM -0400, Mark C. Chu-Carroll wrote:
> On Wednesday 17 July 2002 12:08 pm, David McMillan wrote:
> > Will Stellation work with DB/2 as a back-end?  
> 
> In the current system, the DB2 back-end only works if you're
> using the system in non-server mode. 
> 
> There are two ways to access a Stellation repos: local
> database access, and through a server. If you're using
> local access mode, then you can use the location
> string "db2:db2inst1:db2pass" to access a Stellation repository
> in stored in DB2. 
> 
> To access remote, we haven't put a back-end selection mechanism
> into the server code yet. 
> 

I agree with Mark that it's best if you wait until the server supports DB2. 
However, if you want to play with local mode in the interim, you can try the following:

Copy the db2 jdbc library:
  $ cp /home/db2inst1/sqllib/java12/db2java.zip $HOME/stellaton/lib

Update the tsvc script to include the above zip (You can also modify build.xml, but I just did 
quick edit to see if code still worked.)

Start up db2, as described in install document.

Use the following local option

	--location db2:db:db2inst1:pass

where pass is the password of the db2inst1 account.

dave
  
-- 
Dave Shields, IBM Research, shields@xxxxxxxxxxxxxx, http://www.eclipse.org/stellation