gasrabill.blogg.se - Sap hana studio user parameters

#Sap hana studio user parameters upgrade#

Now in this situation you may use ALTER SYSTEM ALTER CONFIGURATION ddls too if you get sql credentials with proper authorization. And I will not go into the details of the script uses because that’s already explained by another colleague in a blog post(will find that in reference section later).Įxample scenario : Let us assume there’s a situation in the middle of a maintenance activity that needs you to change the parameter ‘tcp_keepalive_count’ to 10 from default value 5. You have display-only sql credentials but not having access to client tools. The later one is released with SAP HANA 2.0 SPS05. hdbsql views and a python script : setParameters.py. Let’s use two saviors in this regard i.e.

#Sap hana studio user parameters upgrade#

So what would you do if you are Technology Consultant, middle of an upgrade activity and for some issues you have to see the restart properties some SAP HANA params and tweak them urgently but you’re not entitled to neither SAP HANA Cockpit nor SAP HANA Studio (most preferable client tools for SAP HANA administrations) but have access to server. Why to search for guides when you have access to your system and I can tell you SAP HANA will answer to your queries when asked properly ? You may check from help guides but eventually you feel more convenient to see what your system suggests.

Now again you are in confusion because you don’t know if you change the parameter whether SAP HANA will require a restart or not to get that activated.

It may end up with changing the firewall rules or a certain amount of unnecessary delay if you take my personal experience. And for say if you only have 2 weeks to accomplish your entire activity and raising a bug in DevOps to allow SAP HANA cockpit from your VDI and to have proper access to that and following up and eventually get that done in a completely new customer environment is quintessentially mess.

With the rise of hyperscaler managed services, if you are onboarded for a customer project only for some short term critical maintenance services like upgrades, migrations, often you are going to find several access issues for administrators specially on SAP HANA client level.

Problem Statement & Use Case : Let’s divide the arose problems in two levels : Preamble : Being an SAP technology consultant, throughout my career I have been getting so many helps from the contents written by the experts of SAP Community, hence I thought this is the pay-back time ?.