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.
- GoTo /hana/shared/<Cockpit_SID>/hdblcm
- choose option 10, then it will give you below options.
- 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.
- 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.
How to find SAP ABAP Schema Name?
DB2
db2 "select tabschema from syscat.tables where tabname = 'SVERS'"
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?
- 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"
-
-
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.
You must be logged in to post a comment.