Home » SAP

Category Archives: SAP

find if a parameter is dynamic in HANA

We many times need to know whether a hana parameter is dynamic or a restart is required to make it effective. To check this goto below

  • open cdexe on the OS side, if you already configured this alias
  • otherwise go to the folder “cd /usr/sap/$SAPSYSTEMNAME/SYS/exe/hdb”
  • open the config folder by command “cd config”
  • open the Master ini files you need with the editor (do not adjust value in these files)
  • check the hint for the parameter you are looking for, there you will find configure online or offline


Below files contains details about

  • Default values (not to be adjusted)
    • /usr/sap/<sid>/HDB<inst>/exe/config
    • /hana/shared/<sid>/HDB<inst>/exe/config
  • Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts
    • /usr/sap/<sid>/SYS/global/hdb/custom/config/<service_or_component>.ini
    • /hana/shared/global/hdb/custom/config/<service_or_component>.ini
  • Valid for all services on all hosts
    • /usr/sap/<sid>/SYS/global/hdb/custom/config/global.ini
    • /hana/shared/<sid>/global/hdb/custom/config/global.ini
  • Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host <host>
    • /usr/sap/<sid>/HDB<inst>/<host>/<service_or_component>.ini
    • /hana/shared/HDB<inst>/<host>/<service_or_component>.ini
  • Valid for all services on a specific host <host>
    • /usr/sap/<sid>/HDB<inst>/<host>/global.ini
    • /hana/shared/<sid>/HDB<inst>/<host>/global.ini


understanding sgen and pxa buffer

There are n number of ABAP program in the system used for various functionalities/purposes, all these ABAP programs are stored in REPOSRC, for example below are the total number of programs in a S4HANA system.

Some are kind of must programs that needs to be compiled instantly when a user logs into the system or executes a transaction code. These compiled codes are placed in a table REPOLOAD, for example below are the total entries in a S4HANA system.

This table REPOLOAD is tightly integrated with PXA buffer, the PXA buffer is controlled by below parameters

  • abap/buffersize
  • abap/pxa_cache
  • abap/pxa_preload
  • abap/buffer_fragments

we can see the utilization of PXA or program buffer in ST02


  • When we start the AS ABAP Server, pxastat and pxanew in work directory is created, first wp-1 loads pxauserload, then pxanew, then pxastat, then will rename pxanew to pxastat, this deletes old pxastat, the pxa buffer is filled up to the percentage specified in abap/pxa_preload, once it is reached the preload is stopped. Once wp shutsdown it writes its pxa to pxanew.
  • if we run the ABAP program (or tcode) first time, it compiles and stores in REPOLOAD then stores in PXA buffer.
  • If we run another time the same ABAP program (or tcode), and the compiled program in REPOLOAD is changed then it will relook in REPOSRC compile it, place the compiled program in REPOLOAD, whenever a program is compiled it is placed in PXA buffer.

Now as I mentioned above parameters, there can be situations where the program might be dropped, then it will be again picked up from REPOLOAD into PXA, now if DB version is different we will get dump LOAD_PROGRAM_LOST.

Now if we activate a program from SE80 or SE38 then the activation timestamp is changed and PXA marks it as old, this information is sent to all abap servers asynchronously. Then all the reactivation process mentioned above is carried out.

With S4HANA we have a new job introduced with 1909, “SAP_SGEN_REGENERATE_LOADS”. The purpose of this is to minimize waiting times for users or developers by regenerating invalidated loads.

This job is periodic job which runs every hour, and run sgen for invalidated loads.


uninstall hana cockpit

Note: The versions in my system is below

  • SAP HANA Database – version
  • SAP HANA XS Advanced Runtime – version
  • SAP HANA Cockpit Stack – version

To Uninstall HANA cockpit please follow below.

  1. GoTo /hana/shared/<Cockpit_SID>/hdblcm20210531_204914
  2. choose option 10, then it will give you below options.20210531_204938
  3. to uninstall all component choose all, or choose the required option and it will give you prompt for y/n, if everything looks good press y to proceed.20210531_205554
  4. then uninstallation will start and once it completes it will give you below details, you should also check the log file mentioned at the last for any issues.20210531_205645

How to find SAP ABAP Schema Name in DB2?

How to find SAP ABAP Schema Name in DB2?

  • db2 "select tabschema from syscat.tables where tabname = 'SVERS'"schemasap

Log utilization in DB2

How to find log utilization in DB2?

  • db2 "select * from sysibmadm.log_utilization"

What do we mean by logs?

<in Progress>

How to find all schema names in DB2?

  1. How to find all schema names in DB2?
    • db2 connect to <db_name>
    • db2 "select schemaname from syscat.schemata" OR
    • db2 "select distinct tabschema from syscat.tables"
    • schemalist


List all Kernel Parameters

In every Kernel Patches, either sap changes some parameter or adds/remove a parameter. If we are planning to add a new parameter we have to first verify if the parameter is supported by KERNEL or not. OR we can check by going through its particular note.

To do this follow below step to check if the parameter is included in the KERNEL or not

sappfpar all          # will give list of all parameters

You can grep to check the parameter is supported in your KERNEL or not.

IDEALLY we should run sappfpar check after doing parameter changes, especially memory related parameters, but for planning for adding of new parameters we can use this step.

Important Links
* https://wiki.scn.sap.com/wiki/display/SI/SAP+Kernel:+Important+News

How to check what Components Versions are installed on SAP JAVA AS?

First open the start page by referring to http://ipraby.com/sap/how-to-open-startpage-of-sap-java

once it is open click on System Information

Or use link – http://<hostname>:5<NN>00/nwa/sysinfo
NN = SAP JAVA Instance Number

Then Goto, Component Info Tab,

In the Development Components, select “All Display Components” in Display Drop Down Combo Box.

Apply Filter in name section, and check what is the SPS level of the SAP JAVA AS Component.

How to open startPage of SAP JAVA?

You can open startPage of SAP JAVA system by providing the correct HTTP or HTTPS port.

Please refer http://ipraby.com/sap/sap-java-ports for more details on JAVA ports.

In SAP AS JAVA 7.0X by default index.html was used.

  • HTTP Link – http://<hostname>:5<NN>00/index.html
  • HTTPS Link – https://<hostname>:5<NN>01/index.html

In SAP AS JAVA 7.1X onwards by default startPage was getting used.

  • HTTP Link – http://<hostname>:5<NN>00/startPage
  • HTTPS Link – https://<hostname>:5<NN>01/startPage

Where NN = Instance number of SAP JAVA AS


if connecting to SAP AS via HTTP port use rule 5<NN>00
else if connecting from SAP SCS/ASCS via HTTP port use rule 5<NN>13
in later case, sapctrl<NN> must be defined in /etc/services file.

If connecting directly to SAP AS via HTTPS port over SSL use rule 5<NN>01
else if connecting from SAP SCS/ASCS via HTTPS port over SSL use rule 5<NN>14
in later case, sapctrls<NN> must be defined in /etc/services file.

for connecting through any AS use below for java systems.

IIOP initial context5<NN>02
IIOP over SSL5<NN>03
P4 over HTTP tunneling5<NN>05
P4 over SSL5<NN>06

<NN> = 00, 01, 02, 03, 04, 05, …….. 99


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers