HANA backtrace 05/2012

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