On 3/8/11 12:34 PM, "Rudolf Bargholz"
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.).