On 3/8/11 12:34 PM, "Rudolf Bargholz" <[email protected]> wrote:
>Hi Pierce, > >Don't run OTRS on DB2 - we use MySQL - but our other apps all use DB2, so >we have experience with the problem you describe. [snip] >LONG VARCHARs can have a max length of 32768 characters. I wouldn't go that far. FYI: DB/2 10 for z/OS and AIX do not have this limitation. Doesn't help in this case, but we have successfully run OTRS against both systems using v10 of DB/2. >Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL1585N A system temporary >table space with sufficient page size does not exist. SQLSTATE=54048, >referer: http://1.1.1.1/otrs/index.pl?Action=AgentTicketZoom;TicketID=1 To work around this in v9, make sure you have the fixes listed here applied: https://www-304.ibm.com/support/docview.wss?uid=swg1JR30604 And make sure you do: db2set DB2_EXTENDED_OPTIMIZATION=NLJNORD,NO_HVCHECK_ALL That should allow it to work with DB/2 v9 LUW. (BTW, if you do have access to a z/OS DB/2 and a ZIIP, OTRS *rocks*. Most of the queries are ZIIP-eligible.). --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
