Skip to Content

Can we use SQL PAGE compression for a J2EE system ?

Hello,

we have a Netweaver 7.40 Process Orchestration system running on a single stack J2EE system with SQL 2012. It looks like the tables are currently not compressed. All the notes etc. about compression that I've found are in the context of an ABAP stack and talk about running a report to do the compression. We could compress the J2EE DB tables using the appropriate SQL commands but I'm not sure whether this is supported and/or recommended. Has anyone come across any explicit SAP documentation discussing compression in the context of a J2EE stack ?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 20, 2015 at 06:01 PM

    Hello Andrew,

    1488135 - Database compression for SQL Server note is for ABAP servers and tells to check "Using SQL Server Database Compression with SAP NetWeaver" in http://www.sdn.sap.com/irj/sdn/sqlserver  link.

    The document that is directed by sqlserver page is saying that "SAP NetWeaver Application Server Java does not currently support SQL Server database compression". Here is the link for the document.

    Using SQL Server Database Compression with SAP NetWeaver

    This document is written in 2011. This rule could have changed for newer versions maybe. But unfortunately there is no link on scn sqlserver page.

    Regards,

    Yuksel AKCINAR

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 06:09 PM

    Hi Andrew,

    The data dictionary for JAVA does not support compression, therefore for a Java application server there is currently no compression support. You can see on detail this information in SAP Note 1488135 and this document: http://scn.sap.com/docs/DOC-1009

    Regards,

    Luis Darui

    edit: by the time I was answering I didn't see the Yuksel answer. Probably I took too much time to answer it.

    Message was edited by: Luis Darui

    Add comment
    10|10000 characters needed characters exceeded