SAP HANA introduces new and changed administration features.
Partitioning (Changed)
Privileges for Partitioning
- The PARTITION ADMIN system privilege is now available so that users
with this privilege can perform some partitioning operations with the
ALTER TABLE statement. More specific ALTER object privileges for the table
are still required to modify partitions.
Range Partitioning
- For heterogeneous range partitioning the numeric data types now
support negative and positive numbers for the partitioning column.
Dynamic Range Partitioning
- The NVARCHAR data type is now supported for INTERVAL property
values in dynamic range partitioning.
- The numeric data types now support negative and positive numbers
for dynamic range partitioning. Details of how this is applied are given
in the documentation.
Persistent Memory Property
- The Persistent memory (NVM) property is now supported for both
balanced and heterogeneous partitioning types. Persistent memory is
consumed only when the partitioning property is set to TRUE. Consumption
is shown as PERSISTENT_MEMORY_SIZE_IN_TOTAL in the monitoring view
M_TABLE_PARTITIONS. Properties can be modified for a partition using the
ALTER PARTITION key words or using PARTITION BY.
Partition Locations
- When you partition or repartition a table you can now specify at
which location the partition should be created using the AT LOCATION
clause. This option can be used to move a partition to a different
location and can be used with all partitioning types: hash, roundrobin and
range.
Monitoring Views for Partitioning
- You can now enable the collection of additional detailed
statistical information in the monitoring view M_TABLE_PRUNING_STATISTICS.
This will help you to analyze the effectiveness of partition pruning.
System Views for Monitoring Partitions
Global Cache (Changed)
- You can now define limits to apply a global cache size. You can
define upper and lower limits using a set of configuration parameters in
the memoryobjects section of the global.ini file. You can
set values either as an absolute number of bytes or as a percentage of
available memory.
Consistency Checks - Alerts (New
and Changed)
- An additional statistics server alert has been added (Alert #146
Table Consistency Status) for the table consistency check to report the
number of errors in tables with inconsistencies.
- A new statistics server alert checker has been introduced (Alert
#145 Nameserver Topology Inconsistencies) to check the system topology for
any inconsistencies. This runs on the nameserver and issues a warning if
any inconsistency is found.
Workload Management (Changed)
Workload Classes
- The workload mapping property 'Application Source Name' is now
available, this is applied at the statement level and corresponds to the
session variable APPLICATION_SOURCE.
Properties for Workload Classes and Mappings
- The use of wildcard characters for matching workload classes with
the client has been extended. The wildcard character can now be used on
its own without any prefix character so that any value for the property
will match successfully. See the examples in Properties for Workload
Classes and Mappings.
Properties for Workload Classes and Mappings
- The workload class properties to manage thread limits (Statement
Thread Limit and Total Statement Thread Limit) can now also be defined in
hierarchical parent-child relationships so that a total restriction
defined in a parent class can be inherited by child classes.
Hierarchies of Workload Classes
- Enhancements have been introduced to preserve the validity of
workload class mappings in cases where the mapping has dependencies to
other procedures. Mappings may be invalidated if a dependent procedure is
deleted, but validity is restored if the link to the procedure is
restored. You can see the status of a mapping from the
WORKLOAD_MAPPINGS.IS_VALID column.
Managing Workload with Workload Classes
System Replication (Changed and
Deprecated)
- The configuration parameter datashipping_parallel_processing has
been deprecated in SAP HANA 2.0 SPS 07. This is no longer required because
multistreamed datashipping with parallel processing is now always active.
SAP HANA System Replication Configuration Parameters
- The configuration parameter enable_takeover_with_uninitialized_volumes has
been introduced to check before a takeover takes place that all databases
are correctly initialized. This can be used either to prevent a takeover
or to simply issue a warning.
SAP HANA System Replication Configuration Parameters
- The option to use table preloading with the delta data shipping
mode is no longer supported (see configuration parameter preload_column_tables).
SAP HANA System Replication Configuration Parameters
- SSL security is now enabled by default for all system replication
connections. The default value of the configuration parameter enable_ssl has
been changed to 'on'.
Configure Secure Communication (TLS/SSL) Between Primary
and Secondary Sites
- A new option has been added to the hook method srServiceStateChanged.
The parameter --details returns additional information
about services which may have crashed and are no longer available.
SAP HANA Dynamic Tiering
- SAP HANA dynamic tiering 2.0 will not receive any new features
going forward. The current released version of SAP HANA dynamic
tiering is SAP HANA dynamic tiering 2.0 SP 04. Customers
using SAP HANA dynamic tiering with SAP HANA 2.0 SPS 06 or
beyond continue to use the 2.0 SP 04 version of SAP HANA dynamic
tiering.
SAP HANA dynamic tiering is an optional add-on to the SAP HANA
database for managing less frequently accessed warm data. It has been
superseded by SAP HANA native storage extension (NSE) in SAP HANA 2.0 SPS 04.
We recommend that you use NSE for your data tiering requirements.
SAP Note 2636634
Backup Retention
It is now possible to flag complete data backups to be retained. If backups are flagged as retained, they cannot be deleted by the BACKUP CATALOG DELETE command or by the scheduled housekeeping tasks.
BACKUP DATA Statement (Backup and Recovery)
hdbbackupcheck
The hdbbackupcheck tool now supports encrypted backups.