Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Create SAP HANA database administration guides on the day to day
database administration tasks like starting and stopping,
changing the configuration settings and performing table
administration.
Study Material
The study material for this topic comes from training
Note that C_HANATEC_13 covers SAP HANA 2.0 SPS 00 only. C_HANATEC_14 will cover SPS 02.
Administration Tools
You are expected to be (to some extent) familiar with the SAP HANA administration tools. There used to be quite a number of questions about Solution Manager but this appears to be a thing of the past. Your mileage may vary, but in HEC13 I did not count a single one.
As you might expect for a tool that's new for SAP HANA 2.0, there were quite a number of questions about or referencing SAP HANA cockpit - a good 20% in my case - although studio also came up a couple of times.
As of SAP HANA 2.0, there has been no more development on SAP HANA studio, no more updates on the documentation, and part of the functionality (repository, XS classic development) has already been marked deprecated in the SPS 02 release. You can expect studio to quietly leave the stage of the exam in the near future.
If not mistaken, there was one question about ALM (Application Lifecycle Management), one or two about the SAP HANA interactive terminal, hdbsql, and a couple about the SAP HANA database lifecycle management tool hdblcm, and one that referenced the hardware check configuration tool, but none (0) about XS Advanced administration, Landscape Manager, Solution Manager (as mentioned) or ITOA.
One of the training objectives is to be able to work with the SAP (Netweaver AS ABAP) DBA cockpit. However, is it not explicitly mentioned as exam objective and I did not have any question about it (but your exam might be different). In past exams, the only questions I have seen were about scheduling backups (as this could not be done in SAP HANA studio). However, as we can now schedule backups in SAP HANA cockpit, it looks like DBA Cockpit takes the same way out as SAP HANA studio.
If you are not familiar at all with DBA cockpit, you might want to browse the documentation a bit or scan the internet for a video. Otherwise, I would not invest too much time into this subject.
Most of you will be very familiar with SAP HANA studio so you can check the boxes: perspectives, add a system, diagnosis mode. No need for any hard study here.
For those new to this tool, here is an overview from 2015.
No surprise, as an SAP HANA technician, you are expected to know how to start and stop an SAP HANA system using cockpit, HDB, and sapcontrol, start and stop tenant databases, start and stop services, but also troubleshooting an unresponsive system (unplanned maintenance).
There is a blog post about all the ins and outs of starting and stopping SAP HANA systems and tenants (on GCP but the same applies to on-premise).
Additionally, we have posted two under-the-hood blogs that cover the inner workings of the HDB system management script, and the role of sapinit and SAPStartSrv (in a lot more detail than you are expected to know for the exam).
Another exam requirement is to be at ease with common database administration tasks like making a backup (for this see the Backup and Recovery section), checking system health, CPU and memory usage, alerts, sessions, statements, etc., all with focus on the SAP HANA cockpit.
Closely related to performance monitoring is the topic of tracing and diagnostics. The objective here is that you are familiar with the several trace options and working with diagnosis information.
For the monitoring playlist on the SAP HANA Academy, see
For this topic, you need to know how to execute SQL in SAP HANA cockpit (using the Database Explorer), how to monitor expensive statements, and use the SQL Plan Cache.
SAP HANA Academy - Web IDE for HANA: Database Explorer
For this topic, you need to know when to use a column-based and when to use row-based table storage, how to create a table, display definition and content, and how to work with table partitioning.
This topic is about XS classic: SAP HANA content, delivery units, packages, repository, design-time/runtime objects and how to transport these between systems.
As the XS classic repository has been deprecated for release SAP HANA 2.0 SPS 02, this is probably the last exam with questions about this topic.
If you have never seen ALM for classic XS (a new UI was introduced for SPS 11), you might find the video tutorial below of interest.
ALM for XS Advanced works quite different but is not (yet) included in the exam requirements; no need to study XSA.
The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.