DB2 Express Support?

Re: DB2 Express Support?

Submitted by senakafdo on November 27, 2009 - 06:40.

Hi Peter,

Please find the related discussion on our developer list, [1].

[1] http://markmail.org/thread/x6xpk3u243k5evxm.

Thanks,
Senaka.

Senaka, Thanks for the

Submitted by peterjb on November 29, 2009 - 14:02.

Senaka,

Thanks for the updates.. I'm more than happy to give this a go.. If you can point me in the right direction in the code base that would be great! :-)

Cheers

Peter

Doh!! Should have read the

Submitted by peterjb on November 29, 2009 - 14:57.

Doh!! Should have read the Carbon Developer Mailing list thread first! It would appear that the work is already underway. :-) I use V3.57.82 ( JDBC 3.0 ) at work and verified that it does not include any upper case package names.. I also looked at V4.7.85 ( JDBC 4.0) and it does contain an upper case package name, but only for COM. ibm.db2os390 package all the others are lower case.

You should be able to grab them from the IBM DB2 LUW Support area ( http://www-01.ibm.com/software/data/db2/support/db2_9/ )

Cheers

Peter

Re: Doh!! Should have read the

Submitted by senakafdo on November 29, 2009 - 19:29.

Hi Peter,

Apologies on our behalf for not mentioning this on list before Sumedha (I too was not aware) started working on this, which could've saved your time. It seems that both of you roughly started at the same time. :-)..

Regarding your findings, many thanks. I will keep the list updated. You are most welcome to take part in the conversation on the list as well.

Thanks,
Senaka.

Hi Peter, In case you want

Submitted by sumedha on December 1, 2009 - 21:17.

Hi Peter,
In case you want to have a look, I have checked in the database script for db2 here[1].
/sumedha

[1] https://svn.wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts

Sumedha, Thanks.. I'll give

Submitted by peterjb on December 5, 2009 - 18:41.

Sumedha,

Thanks.. I'll give it a go this week some time..

Cheers

Peter

Sumedha, Running the script

Submitted by peterjb on December 14, 2009 - 20:51.

Sumedha,

Running the script on DB2 9.7 Express-C fails with an SQL0355N error on the tables REG_CONTENT, REG_CONTENT_HISTORY, REG_SNAPSHOT. This error is caused by the BLOB column in these tables being larger than 2GB. DB2 Supports BLOBs of 2GB, but they cannot be logged. As such you can either reduce the BLOB column to 1GB or add the NOT LOGGED statement to the BLOB column definition.

The entry :

CREATE UNIQUE INDEX REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME ON REG_RESOURCE(REG_PATH_ID, REG_NAME);

is also incorrect, I think it should be:

CREATE UNIQUE INDEX REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME ON REG_RESOURCE_HISTORY(REG_PATH_ID, REG_NAME);

Cheers

Peter

hi Peter, Thanks for the

Submitted by sumedha on December 17, 2009 - 05:07.

hi Peter,
Thanks for the feedback.
Just wondering how I did not get this when I ran the script. I will incorporate these changes after running few tests.

Thanks,
/sumedha

Sumedha, Not sure about the

Submitted by peterjb on December 19, 2009 - 15:06.

Sumedha,

Not sure about the BLOB errors, It could be a DB2 9.7 difference? The creation of a duplicate index also only throws a warning not an error..

Cheers

Peter

Senaka, No problems.. I'd

Submitted by peterjb on November 29, 2009 - 21:44.

Senaka,

No problems.. I'd only started to have an initial look at the code, so I hadn't progressed anywhere really! :-) You can download the latest versions of the DB2 JDBC drivers at http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217

Cheers

Peter

Re: DB2 Express Support?

Submitted by senakafdo on November 27, 2009 - 05:52.

Hi Peter,

You are most welcome to try this out. IIRC, no one in the G-Reg team has tried it so far (since Registry was implemented on top of WSO2 Carbon). If you are familiar with DB2, and also another RDBMS from the ones supported, H2, Derby, MySQL, MSSQL, and Oracle, you shouldn't find this very hard since most of our DB Scripts are less than 500 lines.

I will raise this question on the Carbon-Dev list. Please find the DB Scripts at [1].

[1] https://svn.wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts

Thanks,
Senaka.