In this blog post, I would be sharing a very basic information about SAP HANA features.
With every latest revision, we hustle sometimes in finding out whether a SAP HANA feature is newly introduced or deprecated from previous versions etc. This information is now easily available with SAP HANA monitoring views
M_FEATURES and
M_FEATURE_USAGE.
From Monitoring Views
These views are available for all Hana versions 1.0 and 2.0 as well.
SYS.M_FEATURES : Provides information about all supported features. Eg:
COMPONENT_NAME |
FEATURE_NAME |
FEATURE_VERSION |
ABSTRACT SQL PLAN |
CAPTURE |
4 |
ABSTRACT SQL PLAN |
PLAN GENERATION |
3 |
BACKUP RECOVERY |
BACKUP SCHEDULER |
5 |
SYS.M_FEATURE_USAGE : Provides detailed feature usage statistics. In this view, column name 'IS_DEPRECATED' if set to 'TRUE' it means feature is deprecated otherwise it's available. Eg:
COMPONENT_NAME |
FEATURE_NAME |
IS_DEPRECATED |
OBJECT_COUNT |
CALL_COUNT |
LAST_TIMESTAMP |
LAST_CONNECTION_ID |
LAST_USER_NAME |
LAST_APPLICATION_USER_NAME |
LAST_APPLICATION_NAME |
LAST_APPLICATION_SOURCE |
LAST_STATEMENT_ID |
LAST_STATEMENT_HASH |
SQL CREATE |
WITH PARAMETERS TREX_FLAGS |
FALSE |
? |
0 |
? |
? |
? |
? |
? |
? |
? |
? |
HIERARCHY |
GENERATOR FUNCTION |
FALSE |
? |
0 |
? |
? |
? |
? |
? |
? |
? |
? |
HIGH AVAILABILITY |
HOST AUTO FAILOVER |
TRUE |
25 |
13914 |
15:11.0 |
-1 |
|
|
|
|
|
|
From SQL statements
You can use the following SQL statements available via SAP Note
1969700 to display this information:
SQL statement |
Details |
SQL: "HANA_Features" |
Overview of SAP HANA features available in the system, including their version |
SQL: "HANA_Features_Usage" |
Overview of SAP HANA features available in the system, including their usage and deprecation state |
Deprecated Features with HANA 2.0
There exists a nice SAP Note
2425002 which provides further details for features being deprecated with SAP HANA 2.0.
Earliest removal of a deprecated feature will be one SPS after deprecation start. The table below lists the specific information, migration steps to follow, and so on.
Description |
M_FEATURE_USAGE.
COMPONENT_NAME |
M_FEATURE_USAGE.
FEATURE_NAME |
Public |
Migration
Guide |
Deprecated with SPS |
Decommissioned with SPS |
In memory optimized (IMO) DSO is a special BW object that was introduced when BW was released for HANA. Meanwhile standard DSOs are also optimized for HANA and there is no need for IMO DSOs any more. |
DSO |
IMO |
yes |
SAP Note 1849497 1849498 |
HANA 2 SPS 01 |
HANA 2 SPS 04 |
Procedure to migrate data from an existing standard DSO to an IMO DSO |
DSO |
IMO CONVERSION |
yes |
SAP Note 1849497 |
HANA 2 SPS 01 |
HANA 2 SPS 04 |
Removal of empty system view SYS.M_TENANTS |
SYSTEMVIEW |
M_TENANTS |
yes |
SAP Note 2424899 |
HANA 2 SPS 01 |
HANA 2 SPS 04 |
Removal of support for legacy Text Mining implementation, including support for HIGHLIGHTED option on TM_ SQL functions |
TEXT |
LEGACY TEXT MINING |
yes |
SAP Note 2435642 |
HANA 2 SPS 01 |
|
Removal of ALTER VIEW ... ADD CACHE RETENTION 0 |
STATIC RESULT CACHE |
RETENTION 0 |
yes |
SAP Note 2487744 |
HANA 2 SPS 02 |
HANA 2 SPS 03 |
Removal of OpenSSL support in the SAP HANA database kernel |
SECURITY |
OPENSSL |
yes |
SAP Note 2093286 |
HANA 2 SPS 02 |
HANA 2 SPS 04 |
Removal of the Repository component in favor of the Deployment Infrastructure (HDI) |
REPOSITORY |
API |
yes |
SAP Note 2465027 |
HANA 2 SPS 03 |
|
Removal of DDL extension for creation of column views of type calculation along with the underlying calculation scenario in a single statement. |
CALCENGINE |
EXPOSE NODE |
yes |
SAP Note 2556245 |
HANA 2 SPS 03 |
|
Removal of system view SYS.COLUMNS |
SYSTEMVIEW |
COLUMNS |
yes |
SAP Note 2713947 |
HANA 2 SPS 04 |
|
Remove fallback for SAP timezone dataset |
TIMEZONE |
SAP_DATASET_FALLBACK |
yes |
SAP Note 2744153 |
HANA 2 SPS 04 |
|
XS Classic: several features |
XSC |
REQUEST: *
JOB: * |
yes |
SAP Note 2465027 (exists since HANA 2 SP00) |
HANA 2 SPS 03 |
|
Hadoop controller |
SDA |
ADAPTER HADOOP |
yes |
SAP Note 2806496 |
HANA 2 SPS 04 |
HANA 2 SPS 05 |
System procedure CHECK_PLATFORM |
SYSTEMPROCEDURE |
CHECK_PLATFORM |
yes |
SAP Note 2816929 |
HANA 2 SPS 05 |
|
If you have any further questions, please contact SAP Support.
Thanks & Regards,
Vivek Sahu
