SAP HANA is an in memory database
for performing real time data analysis, and development of applications on the
top of real time data. Learn SAP HANA from SAP HANA Training. HANA administration deals with managing SAP HANA system in a
single and distributed system environment. Each HANA system can contain multi
node architecture with each node containing multiple processors for fast speed
data analysis and real time data provisioning. You can use Smart data access to
get the data from non SAP systems without importing the data to HANA, and
virtual tables can be used to perform read/write data operations. SAP HANA Admin training includes the
following types of license keys.
SAP HANA License
management and keys are required to use HANA database. You can install or
delete HANA License keys using HANA studio.
Types of license keys:
SAP HANA system supports
two types of License keys:
Temporary license key: Temporary License
keys are automatically installed when you install the HANA database. These keys
are valid only for 90 days and you should request permanent license keys from
SAP marketplace before the expiry of 90 days period after installation.
Permanent license key: Permanent License
keys are valid only till the predefined expiration date. License keys specify
the amount of memory licensed to target HANA installation. They can be
installed from SAP Marketplace under Keys and Requests tab. When a permanent
License key expires, a temporary license key is issued, which is valid for only
28 days. During this period, you have to install a permanent License key again.
There are two types of
permanent License keys for HANA system:
Unenforced: If unenforced license key is
installed and consumption of HANA system exceeds the license amount of memory,
the operation of SAP HANA is not affected in this case.
Enforced: If Enforced license key is
installed and consumption of HANA system exceeds the license amount of memory,
HANA system gets locked. If this situation occurs, HANA system has to be
restarted or a new license key should be requested and installed.
There are different
License scenarios that can be used in HANA system depending on the landscape of
the system (Standalone, HANA Cloud, SAP BW on HANA, etc.) and not all of these models are based on the memory of
HANA system installation.
SAP HANA System Lockdown
There are various scenarios when your SAP HANA system locks down.
This happens when a License key expires or license keys are deleted.
When a system is locked, it is not possible to run any transactions
by connecting to the database. To renew license keys/unlock the system, only
HANA user with License Admin system privilege can connect to HANA database.
Following are the scenarios which can cause the lockdown of SAP HANA
system:
·
When hardware license key
changes and Temporary license key is used in SAP HANA system.
·
Temporary License key expires
in HANA system.
·
All license keys installed in
HANA database are deleted.
·
SAP HANA system permanent
license key expires and has not been renewed in the grace time period of 28
days.
·
You are using Enforced License
key and your memory consumption exceeds the licensed amount and tolerance limit
assigned.
How to check and install
license keys of HANA
The role required to install/delete an existing License Key: LICENSE
ADMIN.
To check and install a new License key, navigate and right-click
HANA system → Properties → License.
It tells about License type, Start Date and Expiration Date, Memory Allocation
and the information (Hardware Key, System Id) that is required to request a new
license through SAP Marketplace.
Now to renew/install a new License key, navigate to Install License
key → Browse → Enter Path, is used to install a new License key. The Delete
option is used to delete any old expiration key.
All Licenses tab under License tells about the Product name,
description, Hardware key, First installation time, etc.
To delete the license key, you can use SAP HANA Studio or it can
also be performed using SQL console. Deleting a license key is required in
various scenarios such as you have installed permanent license keys with an
incorrect installation number or incorrect system number on the database. You
can also execute the following SQL command (Learn to write and execute SQL
queries from SQL Server training) to
delete all license keys in HANA database that results in a system lockdown.
Learn IT Training is the one stop destination for all online IT training
courses with best experienced professionals and skilled resources We have been
offering courses to beginners, consultants
so that they can meet all the challenges in their respective
technologies. We provide trainings in India, USA, UK, Canada, Australia,
Newzealand, Saudi Arabia and many countries all over the world.
Want a free demo with us Register Here
For more details visit:
Visit: www.learnittraining.com
Email: contact@learnittraining.com
Phone: India +91 9912989639, USA +12108585008
Comments
Post a Comment