Tuesday, 11 May 2021

How to install & run the ABAP on HANA Sizing Report (SAP Note 1872170) – A Step-by-Step Guide

In this blog post you will get a clear, step-by-step process of how to install and run the ABAP Sizing Report (described in SAP Note 1872170), with screenshots accompanying each step.

Steps involved

1) Check System Version

The first thing to do is to verify the version of your system that you are going to install and run the report on. This report runs on SAP_BASIS 620 and higher.

Click System > Status then under SAP System Data click the magnifying glass icon:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Once you know you are on the required system version, you can follow the steps to run the report.

2)  Run the Report

Access the system you want to run the report on via SAP Logon with your system credentials.

In the search bar you need to access transaction SE38:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

In the next window access program /SDF/HDB_SIZING and then click the Execute button (or hit the F8 key):

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

If you see a screen like this, it would indicate a very old version of the report and an update of the report will be required:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

The steps for how to do the update are explained in the final section of this blog: “4) Update the Report on the System”

The newer version contains a lot more fields. It looks like this:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

In the Technical Options section you can set the number of parallel dialog processes. It is recommended that you change the number of parallel processes from the default, here it was 1 by for example. But the standard recommendation would be to set it to 3.

To execute the program, Click Program in top left, and then choose to either Execute or Execute in Background:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

For background execution, click the green tick button:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Click Immediate to run straight away:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Then click the Save icon:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

A message will be displayed the the report is now running:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

To check on the progress of the job running, you can go to transaction SM37:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Click the Execute button:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

You will see it is the Active job that is currently running under /SDF/HDB_SIZING. Click on the “Active” status in the table:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Then on the next screen click on the Job Log button:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

This will display how much of the report has been completed so far (In this example it would have needed about another hour to complete. The runtime will always depend on the size of the system):

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

3) Show Output Spool

To show output of finished report, run transaction SE38 > /SDF/HDB_SIZING > Execute then tick Display a stored Sizing result:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

The result is displayed:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

This result can also be downloaded to a file. Enter %p as a transaction on the open screen of the result (or use the icon if available):

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Choose the format of the file you wish to save the output to from the list then click the green tick:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

On the next screen give the file a name and click Save:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

4) Update the Report on the System

If you wish to install or update the report to the latest version, SAP Note 1872170 contains the details for how this is done, highlighted in this section:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Currently the latest version of the note to implement is 2987346 using transaction snote. However in this example detailed below, the note 2810633 was used in line with the system version at the time.

Run the snote transaction on the system:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Click on the note browser icon:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

Enter the note number 2810633 and click the Execute button:

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Certification, SAP HANA Certification, SAP HANA Career

The note will then install. If your support package is too low then the system will tell you that it cannot be implemented. Instead you might be able to use correction 9 (note 2504480) instead of the one listed in the previous step.

No comments:

Post a Comment