SAP HANA

hanadba.com

We are all told, “Knowledge increases by sharing it, not saving it”.

hanadba.com serves as a vessel to project my passions for learning database skills and sharing knowledge in a common platform, where all SAP consultants & aspirants over the globe can clue in together.

Home: Welcome

Mar 142 min read

Understanding the Key Functionality Differences between SAP HANA Cloud and SAP HANA On-Premise

Choosing between SAP HANA on-premise and SAP HANA Cloud is challenging as both platforms offer unique advantages.

48 views1 comment

VIVEK SAHU

Nov 25, 20222 min read

SAP HANA : System Usage

system_usage It specifies the usage type of the system to be installed. This setting is stored in the global.ini file, and can be used to...

108 views0 comments

SAP HANA : Adjust the data retention time of Embedded Statistics Server tables

VIVEK SAHU

Nov 25, 20221 min read

SAP HANA : Adjust the data retention time of Embedded Statistics Server tables

Why ? With the embedded statistics server the retention time for most of the histories is already 42 days. Nevertheless there are still a...

116 views0 comments

VIVEK SAHU

Dec 9, 20213 min read

SAP HANA Data backups can include configuration files (ini-files) - SPS06 and above

Why it's required ? Whenever you want to perform hardware move or system copy for your HANA system, including all the customer...

362 views0 comments

VIVEK SAHU

Dec 8, 20212 min read

SAP Hana Automatic filesystem fallback for backint-based log backups : SPS06 and above

Problem When using a third-party backup tool to back up SAP HANA log segments, if the external storage system cannot be accessed, log...

259 views0 comments

VIVEK SAHU

Aug 19, 20214 min read

SAP HANA Monitoring Views & Record Handling

Some of the well known monitoring views and how can we manage the amount of data within it are as follows : M_ACTIVE_PROCEDURES This view...

482 views0 comments

VIVEK SAHU

Mar 8, 20211 min read

SAP HANA - Platform Edition or Express Edition ?

SAP HANA identify platform edition or express edition is very easy now.

474 views0 comments

VIVEK SAHU

Oct 7, 20203 min read

SAP HANA - Partitioning Data Volumes

Since SAP HANA 2.0 SPS03 and above versions, data volumes on the indexserver can be partitioned so that read and write operations can run in

2,198 views0 comments

VIVEK SAHU

Sep 4, 20203 min read

HANA – Consistency Check of the Persistence (hdbpersdiag)

Introduction (hdbpersdiag) Both understanding the root cause of the corruption and resolving it are very important. You may not be able...

236 views0 comments

VIVEK SAHU

Sep 4, 20201 min read

SAP HANA Available, Used & Deprecated Features

In this blog post, I would be sharing a very basic information about SAP HANA features. With every latest revision, we hustle sometimes...

117 views0 comments

VIVEK SAHU

Sep 4, 20201 min read

HANA parameter change without DB user from console tool setParameter.py – SPS05 and above

Introduction – Console Tool setParameter.py From SAP HANA version 2.0 SPS05, you can use the console tool setParameter.py to make changes...

276 views0 comments

VIVEK SAHU

Sep 3, 20202 min read

HANA Table Consistency Check – Exclude Big Tables/Checks – SPS05 and above

Introduction Corruptions are not necessarily recognized quickly after they have been introduced. It might take weeks and months until the...

626 views0 comments