Home > ASE, Database, SAP > ASE (ASE 15.7 ESD#3) Released & Its New Features !

ASE (ASE 15.7 ESD#3) Released & Its New Features !

December 24th, 2012 Leave a comment Go to comments

New features of ESD#2 and ESD#3 here:

  • Fixes: With ESD#3 you get all of the fixes for database issues that have been made available since the initial release of release 15.7.
  • In-row LOB compression: ASE can store LOB data in-row or off-row (on special LOB pages). Data compression was introduced with ASE 15.7, but in-row LOBs have not been compressed. With the new version you will get in-row LOB compression. For some SAP tables this can make a big difference. For an example, please have a look at this blog from Hüseyin Bilgen who shares his experiences.
  • Hash-based statistics: This feature helps speed up the updating of index statistics.
  • Plan sharing: In the past a database query that was executed more than once in parallel would result in multiple query plans which could be different (depending on the values provided at compilation time). When you are running ESD#3, plans for queries running in parallel are cloned, saving the cost of recompilation and ensuring that the queries use the same plan.
  • Enhanced monitoring: You will see more metrics on several screens of the DBA Cockpit. Since we are using early versions of the ESDs in our development systems, we have already been able to include some of these in the DBA Cockpit versions released during summer 2012 (such as SAP_BASIS 7.02 SP12). For example: enhanced SQL statement statistics, spinlock monitoring, separation of I/O time in read time and write time… There are also new monitoring features that are going to be used in future versions of the DBA Cockpit. One example is the new history of database and transaction dumps.
  • Talking about database and transaction dumps: There are several new features here that will make your life as a DBA easier. You can now run the dump transaction while a dump database is running. There is a new tool ‘sybrestore’ available with ESD#3 that will help you to restore the database when needed. We already updated our backup and recovery SAP Notes when ESD#2 was released to make use of the new features.
  • Reorg rebuild can be run online. I don’t think I need to say more.
  • The maximum size of a database is now 64TB. Just in case your compressed database was close to the 32TB limit before…
  • Asynchronous DB initialization: If you are expanding your database, the database is now available immediately and initialization is done in the background.

Source :

Check the Sybase Wiki @
Categories: ASE, Database, SAP Tags: , , ,
  1. Anurag
    December 25th, 2012 at 18:25 | #1

    Anva, Is it a patch?

  2. Anurag
    December 25th, 2012 at 18:23 | #2

    Hi PR – You should have driver “Adaptive Server Enterprise” installed.

    Control Panel –> Administrative Tools –> Data Source –> Drivers

  3. PR Chauhan
    December 24th, 2012 at 13:26 | #3

    I had install ASE15.7 on linux. now i want make odbc connetion on window.but am not getting driver for make odbc. please help me.


  1. No trackbacks yet.