Hi,
We are working on fixing this issue which also exists in HSQLDB and Sybase.
It should be ok in the next release.
Ludovic
  I'm interested in using XWIKI with a DB2 database
back-end. I've had some
 success creating the DB2 schema, populating with data from the MySQL
 database supplied for xwiki v. 0.9.793. However, when I hit the following
 URL:
 
http://127.0.0.1:8080/xwiki/bin/view/Main/WebHome
 DB2 doesn't like the following query, which is generated from
 XWikiHibernateStore starting on line 1775:
 select distinct xwikidocum0_.XWD_WEB as col_0_0_, xwikidocum0_.XWD_NAME as
 col_1_0_ from xwikidoc xwikidocum0_, xwikiobjects baseobject1_ where
 baseobject1_.XWO_NAME=xwikidocum0_.XWD_FULLNAME and
 baseobject1_.XWO_CLASSNAME='XWiki.XWikiUsers' order by
 xwikidocum0_.XWD_CREATION_DATE desc
 From reading the DB2 docs, I think DB2 doesn't
permit use of a column in
 the 
 order by clause that does not also appear in the select clause, if the
 distinct keyword is present. I was able to fix the problem by removing the
 word "distinct" from the query on line 1775 of XWikiHibernateStore. That
 allowed me to view the home page, and do several other tasks -- edit
 pages,
 attach documents, etc.
 I don't know how critical that "distinct" is to the correct operation of
 xwiki. I was wondering if the developers could answer that. If "distinct"
 is
 not needed and can be removed, or the query can somehow be reworked then I
 will be glad to submit my DB2 schema on the Database Development page.
 Stephen