Skip to Content

Welcome back to the first instalment of HANA backtrace for 2012.
\   Let’s look at what I’ve seen and heard about SAP HANA lately:
\  
\   Accessing data in a SAP HANA box from ABAP requires the well known database \   library (DBSL) and there are some new notes on this:
\   SQL hints\   have a long tradition with nearly all databases and SAP HANA is no exception.
\   Which of these and how are supported by the DBSL is explained in SAP note:
\   #1622681 – DBSL hints for SAP HANA
\  
\   If you’re about to figure out what version of the DBSL is installed on \   your system you should have look into
\   #578324 – Make and release information for MaxDB \   DBSL.
\  
\   An overview about the DBSL versions can be found in SAP note
\   #1600066 – Available DBSL patches for NewDB
\   ++++ —- ++++ —- ++++
\  
\   Since also the SAP HANA box should be monitorable via Solution Manager, the saphostctrl \   program needs to be installed on it.
\   SAP note
\   #1625203 – saphostagent/sapdbctrl for NewDB
\   has the specifics for SAP HANA and in SAP note
\    #1031096 – Installation of paket SAPHOSTAGENT
\   you’ll find a nice PDF explaining how to install the agent in general.
\  
\   I just installed it on my test machine and it seems to work:

\  \   \     \       \         \       \     \  

\         

/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname HAN -dbtype hdb
Database Status: Running
    Component name: hdbdaemon (HDB Daemon), Status: Running (Running)
    Component name: hdbnameserver (HDB Nameserver), Status: Running (Running)
    Component name: hdbpreprocessor (HDB Preprocessor), Status: Running (Running)
    Component name: hdbindexserver (HDB Indexserver), Status: Running (Running)
    Component name: hdbstatisticsserver (HDB Statisticsserver), Status: Running (Running)
    Component name: hdbconnectivity (HDB Connectivity), Status: Running (connect possible)
    Component name: hdbalertmanager (HDB Alertmanager), Status: Running (No alerts on database.)
\

\        

\  \  

In the same area SAP note
\    #1672908 – sapdbctrl getProperties on NewDB failed
\   fixes a bug.
\   ++++ —- ++++ —- ++++
\  
\   Of course since the last HANA backtrace several new revisions have been released and \   hundreds of bugs and enhancements have been made available (though not all listed in \   detail):
\  
\    #1673965 – SAP HANA appliance: Revision 24 of SAP HANA database
\    #1680966 – SAP HANA Modeler – revision 24 – upgrade news and \   fixes.
\    #1680966 – SAP HANA Modeler – revision 24 – upgrade news and \   fixes.
\    #1664657 – SAP HANA Modeler Rev. 23: upgrade news and fixes
\    #1661415 – SAP HANA Studio – Rev 23: Attr.reihenfolge in \   Berechnu.sicht
\    #1663228 – SAP-HANA-appliance: Revision 23 of SAP HANA database
\    #1653292 – SAP-HANA-Appliance: Revision 21 of SAP HANA database
\    #1654160 – SAP HANA Modeler – revision 21 – upgrade news and tips.
\  
\   Due to the large number of bugs that have been fixed, make sure to install the current \   revision as soon as possible.
\   ++++ —- ++++ —- ++++
\  
\   If you’re running BW on HANA SAP notes
\    #1637145 – SAP BW on HANA: Sizing SAP In-Memory Database
\    #1660125 – SAP HANA database: Table consistency check
\    #1664983 – RSHDB: Consistency check (004)
\   will be interesting to you.
\   ++++ —- ++++ —- ++++
\  
\   That’s so far about the SAP notes I stumbled over – the following links are some SDN \   blog posts I found pretty interesting.
\   Make sure to check them out:
\  
\   In his two posts Krishna explains the design of the new In-Memory \   versions of InfoCube and DSO:http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/28081

\  \  

\  \  

++++ —- ++++ —- ++++

\  \  

For the BWA user base thinking about the future of this BW add-on is quite common \   nowadays, and my colleague from SAP Labs provides some insight:
\   SAP NetWeaver BW Accelerator is NOT Dead
\   ++++ —- ++++ —- ++++
\  
\   Very interesting and as usual nicely written are the posts from Blag about the interaction of R (a free statistics \   package) and HANA:http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/28445

\  \  

\  \  

As R is about to be fully integrated into HANA in later versions, these information \   might become obsolete, but given the state of development today they help a great \   deal.
\   ++++ —- ++++ —- ++++
\  
\   Even more hype-oriented and tech-nerdy is the phantastic project to have Apples Siri\   interact with HANA:
\   Siri meets HANA
\   ++++ —- ++++ —- ++++
\  
\   Finally Jeffrey is off to a long journey and he takes us along:
\  
\   Starting the Journey is a the first part of what likely will become a \   little series of blog posts about writing a book about HANA.
\   ++++ —- ++++ —- ++++
\  
\   That’s all folks – see you next week.
\  
\   Best regards,
\   Lars

To report this post you need to login first.

5 Comments

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

  1. Gregory Misiorek
    Hi Lars,

    it may be already included in one of the ‘revisions’, but are there any specific notes relating to MDX or should we just assume that it’s licensed from a third party and not really in the SAP’s support path?

    great overview as always,

    thx, greg

    (0) 
    1. Lars Breddemann Post author
      HI Greg,

      as MDX is not a software product but a query language definition, SAP of course takes care of its own implementations of it in the various products (like HANA server, BO tools, ODBO drivers and so on).
      For HANA you’ll find remarks on fixes and enhancements in the same revision release notes.
      Just now, in the revision 24 release note there are many points adressing MDX.

      regards,
      Lars

      (0) 
    2. Lars Breddemann Post author
      Hi Greg,

      the MDX implementation is of course fully supported by us. After all MDX is a language description – not a piece of code.
      So, if there are any issues with our implementation(s), we take care of that.

      For HANA server you’ll find information about the fixed bugs in the MDX area also in the general “revision” note. For example, in the current note #1673965 there are several MDX related entries.

      Best regards,
      Lars

      (0) 
  2. Mikhail Budilov

    Hello Lars, Greg.

    Is there any plans to add virtual tables functionality in HANA (in Sybase IQ they calling  proxy tables) ?

    By example  – HANA virt table -> IQ phis. table.

    (0) 

Leave a Reply