

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.
