cancel
Showing results for 
Search instead for 
Did you mean: 

Can we use SQL PAGE compression for a J2EE system ?

andrew_greig
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

luisdarui
Active Contributor
0 Kudos

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

yakcinar
Active Contributor
0 Kudos

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.

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