cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 on iSeries Configuration

sstrickland
Champ in-the-making
Champ in-the-making
[size=150]Can Alfresco be configured to use DB2 on the iSeries?[/size]
If so, how?

[size=150]Jackrabbit Configuration[/size]
I currently have Jackrabbit running successfully by configuring the repository.xml to use jdbc and db2.ddl.  However, Jackrabbit has some issues I find undesirable.

<PersistenceManager
   class="org.apache.jackrabbit.core.state.db.DerbyPersistenceManager">
      <param name="driver"
   value="com.ibm.as400.access.AS400JDBCDriver" />
      <param name="url"
   value="jdbc:as400://ISERIES_NAME/ISERIES_DATA_LIB;
      errors=basic;
      trace=false;
      thread used=false;
      naming=system;
      libraries=*LIBL,wbtstdta,wbtstexc" />
      />
      <param name="user" value="iseriesUser" />
      <param name="password" value="iseriesPw" />
      <param name="schema" value="db2" />
      <param name="schemaObjectPrefix" value="${wsp.name}_" />
      <param name="externalBLOBs" value="false" />
</PersistenceManager>

[size=150]Background[/size]
We use the iSeries for its extrodinary security, dynamic backup-restore capabilities, clustering, and high-availability portability.  The iSeries systems we have serve our 500+ warehouses, 100,000+ employees, and 20,000+ vendors, both within the US and internationally.  We serve our browser environment from Websphere (currently 5.1) using LDAP authentication.

We will need JAAS and LDAP security, one-to-many clustering, many-to-one clustering, HTTP client (not RMI) interface, using java, js, jsp, JSON, ajax, etc.  The project will manage documents through a workflow.

Something I prefer is a robust forum of users & developers where I can communicate daily with others for ideas and issues.

[size=150]Does Alfresco sound like a viable solution?[/size]
4 REPLIES 4

steve
Champ in-the-making
Champ in-the-making
Hi,

I would expect that Alfresco can be configured to run on your platform.

However, we have done some testing with DB2 and have run into some deadlocking issues.
But, if you do give Alfresco a go on your platform then please post your experiences and questions to the forum and we'll try to help you with any issues you may have.

Thanks,

Steve

rward68
Champ in-the-making
Champ in-the-making
Is there a wiki or how-to available for setting up Alfresco on an IBM System i using DB2/400?  Is it possible?

andy
Champ on-the-rise
Champ on-the-rise
Hi

We are still resolving issues with deployment for DB2. At the moment I would expect locking issues. The other added bit of fun is that DB2 is case sensitive by default and the other DBs we support are not.

Andy

andy
Champ on-the-rise
Champ on-the-rise
Hi

See http://wiki.alfresco.com/wiki/Database_Configuration#DB2

for advice on DB2 set up.

Note, DB2 is not supported.

Let us know how you get on.

Andy