Skip to Content

In all the hustle and hubbub of SAP TechEd in Barcelona this past week some of you may have missed the fact we launched the brand new SAP HANA Developer Edition sporting revision 101 and SPS10!

Screen Shot 2015-11-15 at 20.31.16.png

As in previous versions this one sports several pre-loaded applications and demos as well as pre-configured users and information. You can also easily enabled HTTPS communication using the self signed certificate and quickly import Delivery Units (DU). It also has Smart Data Streaming pre-loaded – so plenty of reasons to check it out!

Screen Shot 2015-11-15 at 20.31.34.png

You can find it through the SAP Developer Center, HANA Developer Center: Start Developing with HANA | SAP

Screen Shot 2015-11-15 at 20.33.16.png

Also be sure to check out the HANA EFFECTS podcast, very interesting stuff for those diving into the HANA world.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Hagen Dittmer

    Hiya Craig,

    I didn’t miss it! Thanks very much, enjoying playing with SPS10!

    What does one do however, when the the es_server logs are filled up?

    ES Server process has stopped as it’s data and log volumes are chock-a-block (/hana/shared/HDB/data_es/ and /hana/shared/HDB/log_es/). I’ve had a look at resizing the volumes in AWS, but they’re all labelled xvdf through xvdq, and I don’t know which corresponds to what. Have also performs diagnosis file deletion, but to little effect.

    Cheers,

    Hagen

    (0) 
      1. Hagen Dittmer

        Hi Craig, thanks for the reply.

        So the trouble is that the data file is also full-up. Is this as simple as deleting the physical log file? i.e. /hana/shared/HDB/log_es/HDB/mnt00001/es/eslog? There are two log files in there – is it safe to just delete them?

        Cheers,

        Hagen

        (0) 
        1. Craig Cmehil Post author

          Performing a backup  and then issuing the command ALTER SYSTEM RECLAIM LOG will clear the log files. Never delete any of them directly at the file system level. 


          if you can’t perform the backup then try this note

          http://service.sap.com/sap/support/notes/1679938

          Solution

          1. Stop the database:
          HDB stop

          2. Change into the folder mnt00001 of the logvolume (Default: /usr/sap/<SID>/global/hdb/log):
          cd /usr/sap/<SID>/global/hdb/log/mnt00001

          3. You have to move one of the logvolumes temporarily to another volume where enough space is available. You should free at least 2 GB of space to ensure that the database has enough space to start. To find out the space consumption of each volume execute:
          du -sh *

          4. Move a volume which consumes at least 2 GB of space (e.g. hdb00003) to a volume with enough free space, e.g. to the data volume (Default: /usr/sap/<SID>/global/hdb/data):
          mv hdb00003 /usr/sap/<SID>/global/hdb/data

          5. Create a symbolic link to the new folder in the old location:
          ln -s /usr/sap/<SID>/global/hdb/data/hdb00003 /usr/sap/<SID>/global/hdb/log/mnt00001/hdb00003

          6. Start the database (HDB start) and perform a backup.

          7. Wait until log backups are performed.

          8. Use the following SQL-Statement to clean up the logvolume:
          ALTER SYSTEM RECLAIM LOG;

          9. Stop the database again and remove the symbolic link:
          rm -f /usr/sap/<SID>/global/hdb/log/mnt00001/hdb00003

          11. Move the log volume back to its original location:
          mv /usr/sap/<SID>/global/hdb/data/hdb00003 /usr/sap/<SID>/global/hdb/log/mnt00001

          12. Start the database (HDB start)

          (0) 

Leave a Reply