Hi, We are trying to set up OTRS 3.0.6 with DB2 9.7 FP3a on a 64bit Linux system. We have run into a couple of issues however, and it looks like the SQL/data type sizes are not supported by DB2.
When we try to view the example ticket, the following error is printed to the Apache error logs: 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 The database is created with a pagesize of 32K (32768). Our DBA checked the query in question, and determined that it required a pagesize of '33529'; i.e. db2 'describe SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject, sa.a_reply_to, sa.a_message_id, sa.a_in_reply_to, sa.a_references, sa.a_body, st.create_time_unix, st.ticket_state_id, st.queue_id, sa.create_time, sa.a_content_type, sa.create_by, st.tn, article_sender_type_id, st.customer_id, st.until_time, st.ticket_priority_id, st.customer_user_id, st.user_id, st.responsible_user_id, sa.article_type_id, sa.a_freekey1, sa.a_freetext1, sa.a_freekey2, sa.a_freetext2, sa.a_freekey3, sa.a_freetext3, st.ticket_answered, sa.incoming_time, sa.id, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8, st.freekey9, st.freetext9, st.freekey10, st.freetext10, st.freekey11, st.freetext11, st.freekey12, st.freetext12, st.freekey13, st.freetext13, st.freekey14, st.freetext14, st.freekey15, st.freetext15, s t.freekey16, st.freetext16, st.ticket_lock_id, st.title, st.escalation_update_time, st.freetime1 , st.freetime2, st.freetime3, st.freetime4, st.freetime5, st.freetime6, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time, st.change_time FROM article sa, ticket st WHERE sa.ticket_id = ? AND sa.ticket_id = st.id' | cut -c23-35 | awk '{i=i+$1; print $1,i;}' | tail -n 1 33529 This is above the maximum supported by DB2 (32768). Has anyone successfully ran OTRS3 and DB2? Any suggestions on how we can overcome this problem? Thanks! Pierce CONFIDENTIALITY NOTICE: The contents of this email are confidential and for the exclusive use of the intended recipient. If you receive this email in error, please delete it from your system immediately and notify us either by email, telephone or fax. You should not copy, forward, or otherwise disclose the content of the email. --------------------------------------------------------------------- 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
