Skip to Content

Can we use SQL PAGE compression for a J2EE system ?


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 ?


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on 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 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.


    Yuksel AKCINAR

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 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:


    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.