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_tablespacenot 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"
-
-
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.
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 https://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
SAP JAVA Ports
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.
| Port | Rule |
| IIOP initial context | 5<NN>02 |
| IIOP over SSL | 5<NN>03 |
| P4 | 5<NN>04 |
| P4 over HTTP tunneling | 5<NN>05 |
| P4 over SSL | 5<NN>06 |
| IIOP | 5<NN>07 |
| Telnet | 5<NN>08 |
| JMS | 5<NN>10 |
<NN> = 00, 01, 02, 03, 04, 05, …….. 99
You must be logged in to post a comment.