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
