Skip to Content
Author's profile photo John Appleby

Favorite Linux tools for HANA

Interested in your favorite Linux tools on your HANA appliance. Please share! Note that I mean those that are not installed by default and you need to grab from the web.

1) p7zip http://p7zip.sourceforge.net

p7zip allows you to compress files larger than 32GB, which is very handy. Plus, it has some parallel algorithms for compression which can speed things up.

2) pigz http://zlib.net/pigz/

pigz is AWESOME! Thanks to Ethan Jewett for introducing me. It requires zlib from http://zlib.net and pthreads and it has a completely parallel algorithm for GNU zip (gz) and it is gzip/gunzip compatible. It can compress files 40x faster on a 40 core machine! Unfortunately it doesn’t decompress any faster, though that is quick on most systems.

3) rar http://www.rarlab.com/download.htm

Get the Linux version of RAR for very good compression… but slow speeds.

4) iotop http://guichaz.free.fr/iotop/

iotop allows you to look at I/O processes in a HANA system. Very handy to measure load performance.

5) iftop http://www.ex-parrot.com/pdw/iftop/

iftop is very handy when you need to see intra-node traffic in a HANA scale-out cluster. It shows network traffic.

6) GNU Parallel http://www.gnu.org/software/parallel/

GNU parallel allows you to run N processes in parallel. When you have single-threaded processes on a Linux HANA system you can get massive speed-ups.

Assigned tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      hwinfo to detect what harddisks, network cards etc you have

      uptime to detect if you are really on the computer that you just rebooted

      scp to copy your just-created packed files to another computer over the network

      ssh-copy-id to create passwordless logins

      I document all this on http://www.linuxintro.org

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Hi Thorsten,

      Thanks for these and these are indeed useful tools. In my mind (though I didn't specify this) I meant tools which aren't part of the standard SUSE Linux install and which add specific value to the HANA admin.

      John

      Author's profile photo Former Member
      Former Member

      http://www.linuxintro.org/wiki/ClusterSsh allows you to enter a command one time and have it executed on all cluster nodes simultaneously 🙂

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Nice!

      Author's profile photo Rudolf Wiesmayr
      Rudolf Wiesmayr

      Hi John, this is a beginner's question:

      How do your recommended tools comply to

      1730929 - Using external tools in an SAP HANA appliance

      Kind regards, Rudi

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Neither SAP nor myself certify 3rd party software that you install on your PC, Laptop or HANA Server. Did you expect anything else? 🙂

      Do check SAP Note 1730996 though, it says "Up to now, no software components or software versions are known to have caused problems in the customer environments or in the laboratories of SAP or SAP HANA hardware suppliers."

      John

      Author's profile photo Rudolf Wiesmayr
      Rudolf Wiesmayr

      😀 No, I do not expect that SAP would refrain from not publishing any whitelists or "internal documentatioin not authorized by the lawyers".

      At least, we have an empty blacklist.

      What I would like to see: A "community list of tools" positively tested by reliable sources.

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Well it's like this. HANA appliances are pretty sensitive to being ruined by lazy administrators installing hundreds of programs.

      From a developer's perspective they are also really powerful 40/80-core systems that have really fast I/O, so they are an awesome way to get stuff done fast.

      I regularly use HANA appliances for ETL and CSV manipulation, but they shouldn't be used that way in production.

      All the tools above work great and are useful, in my experience.

      John

      Author's profile photo Rama Shankar
      Rama Shankar

      Thanks John! 🙂

      Author's profile photo Former Member
      Former Member

      Some of my favourite tools are:

      htop - like top but horizontal with pretty colours and better navigation.

      screen - gives you a virtual detachable tty, useful for log running commands, think of nohup but better.

      /proc - not a command but the /proc file system gives lots of really useful information about processes, disks, network, memory etc.  Try 'man proc' for more information

      mmdsh - if you're using an IBM HANA scale out solution, you can use mmdsh to run commands on multiple nodes at the same time, really useful for admin.  Just remember to export the WCOLL variable.

      python - Not only is python a powerful programming language, it also has a native HANA interface.

      Author's profile photo Former Member
      Former Member

      Also:

      dmidecode - makes BIOS/uEFI information available via the command line, handy for retrieving model and serial numbers.

      Author's profile photo Lars Breddemann
      Lars Breddemann

      Ok, time to chip in...


      collectl and it's helper tool colmux for distributed system monitoring.

      For parallel compression pbzip2 showed impressive performance and automatic adaption for the degree of parallelism.

      In general useful is sfk (Swiss File Knife | Free Security & Utilities software downloads at SourceForge.net)  - as it works the same way on Windows and Linux and brings a lot of stuff into one place.

      Finally, the ssh/XTerm tool of my choice would be MobaXTerm. It's all in one place (X-Server and SSH, SCP... )

      It's a nice tool that works just like a charm.

      - Lars

      Author's profile photo Former Member
      Former Member

      I find nmon for Linux nmon for Linux | Main / HomePage very useful.

      Author's profile photo Henricus Bouten
      Henricus Bouten

      Install xrdp on the SLES server and you don't need VNC or other simular tools on you laptop to connect to the SLES graphical desktop.

      xrdp is available on the SLES DVD, but not installed by default.

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Yuck, did you say Graphical Desktop? I change the runlevel to 3 in all HANA systems I'm near. By the time you get near large-scale HANA systems with 8+ nodes, you can't be dealing with a GUI anyhow!

      Only time I ever use X-Windows is to use hdbdmin for hardcore performance troubleshooting. Otherwise it's command line all the way.

      Author's profile photo Henricus Bouten
      Henricus Bouten

      Yup, graphical desktop you read this correctly. There are plenty SAP customers that have a SAP Windows only environment and they find the transition to the command line difficult. For these customers the xrdp is a fine solution.

      I always combine command line and graphical desktop and pick the one that is on that moment the best tool for the job.

      Because my laptop is running Linux Mint to I would run HDBAdmin like this:

      ssh -X <sid>adm@myhanaserver /usr/sap/TST/HDB40/HDBAdmin.sh