life and legacy

We live our lives thinking we need to leave something behind before we die, but a person legacy can mean so many different things it’s the shared experiences we all go through that binds us together, paving the way for new relationships, while also reminding us its never too late to amend the past and hope for the future, and if we are lucky enough we get to see the lessons of our life passed down to those we loved most; that’s the thing about the legacy, its never too late to change or make it better, we just have to know where to start…..

uninstall hana cockpit

Note: The versions in my system is below

  • SAP HANA Database – version 2.00.047.00.1586595995
  • SAP HANA XS Advanced Runtime – version 1.0.127.426
  • SAP HANA Cockpit Stack – version 2.0.12.14.0

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?

DB2

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

Oracle

SELECT username from dba_users where default_tablespace not in ('SYSTEM','SYSAUX');

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

 

update name in zoom

If you are already signed in to ZOOM app, just click on your user icon, and click on settings.

This will open below settings page, click on below highlighted “view more settings”

This will take you to web page where you can change your first name and last name.

OR

Simply login to https://zoom.us/profile

then click Personal > Profile > Name > Edit

Enter your first name and last name, as soon as you hit save, it will reflect in your zoom client also.

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 https://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.