The guys from SAP HANA Academy wrote a nice post about the new features in the database administration for SAP HANA 2.0. In the following weeks they will release new post about what is new in SAP HANA 2.0. If you want to be updated check the following link: What’s New with SAP HANA 2.0 SPS 00 – by the SAP HANA Academy.
The following video shows the new features with a really good explanation of each of them:
Let’s take a further look!
The SAP HANA Cockpit has change a lot from version 1.0. The cockpit unifies the DBCC tool for managing SAP HANA landscapes with the functionality of the HANA 1.0 cockpit to manage single HANA systems. They say we can manage SDC (Single Data Container) and MDC (Multiple Data Container) databases but since HANA 2.0 is only MDC available there is no so much sense on administrating SDC databases. A star feature of this new HANA Cockpit is the Database Explorer that allows to browse catalog objects and run SQL statement just as we did on SAP HANA Studio.
If you want to upgrade to HANA 2.0 remember to remove first the DBCC tool since it is not supported in HANA 2.0 as stated in the following note: 2385193 – SAP DB Control Center – Uninstalling on Systems Upgraded to SAP HANA 2.0
Some important changes to MDC databases:
We can defined memory and CPU thresholds so HANA will start to queue or reject incoming request in case those thresholds are reached. Also there is a new query timeout with a maximum of time limit to process a SQL statement. I can’t believe we have to wait until version 2.0 to have this implemented…
The HANA HDBSQL command has new input and output options using -V in SQLscript. Also we can skip the welcome screen using the -quiet option. Last but not least we can defined the lenght for binary and long columnds using the option -b and the value we want (32 as default).
As you can see there are some nice new features that improve a lot the database administration as the new HANA Cockpit. Some other features are not so spectacular but they were improvements the SAP community was asking from a really long time. We will see if they decide to release a new version of SAP HANA Studio in the next months.
I hope you all survived the log4j Apocalypse and Christmas, hopefully you had a great…
I know it is being a while since I posted the last time. So far…
UPDATE 11/25/2020 Adobe released a new patch that solves the issue a few days ago:…
Good news for you fanatics of SAP GUI! SAP will release SAP GUI 7.70 in…
Quick update since I don't have a lot of time lately. During my 2019 job…
It's been a while since the last time I wrote an entry in my blog.…