Home / SAP HANA

SAP HANA

SAP HANA Merge Diagnosis/Log/Trace File

When we are facing any Hana database related issue, we need to check all log files, diagnosis file and trace files to troubleshoot issues. We need to read Hana diagnosis/log/trace files from various different location. If we SAP Hana is installed on multiple host (Distributed installation), then we need to …

Read More »

SAP HANA Innovation Survey

The advent of SAP HANA in early 2010 marked a disruption in enterprise data management and data processing. Combining in-memory technology, parallel processing on a massive scale and column-wise storage – to name at least the most important ones – SAP HANA leveraged innovations in both hardware and software technology. …

Read More »

SAP HANA Under The Hood: HDB – by the SAP HANA Academy

Introduction The objective of this SAP HANA Under The Hood series is to provide some insights on particular SAP HANA topics. Like a mechanic, look under the hood and take apart a piece to examine its functioning. Last month, I posted the first blog about SAPInit and SAPStartSrv or the mechanism used …

Read More »

SAP HANA Innovation Award 2017 – meet the winners running on SUSE

The SAP HANA Innovation Award honors and celebrates SAP’s most forward-thinking customer and partner successes, and promotes these amazing accomplishments to a wider audience. From Accenture to Fitch Ratings to Zappos, from Automotive to Public Sector to Wholesale Distribution, across 5 continents, companies and organizations of all sizes and industries …

Read More »

Automate SAP HANA System Replication with SLES for SAP Applications

SAP HANA System Replication on SLES for SAP Applications You like directly to start with? If you like to know, how to implement the solution including SUSE Linux Enterprise for SAP Applications, please read our setup guide available at: https://www.suse.com/products/sles-for-sap/resource-library/sap-best-practices/ What is this solution about? The solution created by SUSE …

Read More »

10 Useful Python script for HANA

Python support scripts of the HANA Database as HANA 1.0 SPS12 The python support can be found in /usr/sap/<SID>/HDB<XX>/exe/python_support. Usually you can use the option ‘–help’ and ‘–helpGeneral’ on each scripts. Be carefeful before you execute one, these scripts can impact the system. You can use HDBSettins.sh combined with the …

Read More »

HANA: First adaption with NVM

Since Sapphire this year SAP and Intel have announced some new details regarding Skylake and NVM (non-volatile memory). With the new processors it should be possible to gain ~60% more performance when running HANA workload on it. Additionally new DIMMs based on 3D XPoint technology (NVM) help overcome the traditional …

Read More »

What’s your number?

Have you been using the ISNUMERIC() function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog for you. Just recently I’ve seen a customer using my old workaround (first published here) and then a few days later …

Read More »

SAP HANA Spatial Resources

Quick link: bit.ly/hanaspatial Spatial Enthusiasts! The purpose of this page is to provide you with the one-stop-shop for helpful resources for your journey with SAP HANA Spatial. The page will be updated as needed. If you have a recommendation which is missing from here, by all means, please comment. We also …

Read More »

HANA inverts the Thunderdome law

If you’ve watched “Mad Max Beyond Thunderdome”  then “… You know the law: Two men enter, one man leaves …“. Watch out, he’s coming for you! — pic from www.imdb.com. HANA, of course, reverses, sorry, disrupts this law by making two (or more) values get out of functions, even when only …

Read More »

Error “License key could not be installed” on SAP HANA DB

Error: You face an error in HANA Studio/HDBSQL “License key could not be installed” on SAP HANA DB while installing license on existing DB already running with permanent license. Error in detail: =========================================================================== Error while installing license key on  systemId: <xxx> SAP DBTech JDBC: [436]: could not set system license: …

Read More »

Finding extreme points of Europe with SAP HANA

And here by “extreme points” we mean “the geographical points that are farther north, south, east or west than any other location in Europe” [Wikipedia]. Sorry if you expected to find locations for some extreme sports in this blog 🙂 In my previous blog I used geospatial functions ST_Xmin() and ST_XMax() in SAP HANA …

Read More »

XS Exam Quiz – by the SAP HANA Academy

Introduction Most of you will have heard by now that the classic model of SAP HANA Extended Application Services (XS classic) has been deprecated with the latest release of SAP HANA, 2.0 SPS 02, July 2017. We covered this in our What’s New blog What’s New in SAP HANA 2.0 SPS …

Read More »

Join cardinality setting in Calculation Views

Mechanism of join cardinality setting “cardinality” is a setting that can be applied to joins in calculation views. It specifies how many matching entries for entries of one table exist in the other table of a join. It consist of two numbers, the left number describes the number of matching …

Read More »