HANA 2.0 SP3 - SQL statements download

[former_member201054]

Hi Experts,

from where can we download the SQL statements for HANA 2.0 SP3 version.

I followed note 1969700, but it has mostly the commands of HANA 1.0

I would particularly need the "HANA_Configuration_Parameters" sql statement for HANA 2.0 SP3.

Can you help me to get it.

Thanks in advance

[lbreddemann]

The SAP note you mentioned is the correct (an only) source for the statement collection.

The statements included are valid for HANA 1 and HANA 2 likewise.

If you check the documentation comments at the very beginning of the configuration parameter script that you mentioned, you'll find a section:

[VALID FOR]
- Revisions:              >= 1.00.70
- Statistics server type: all

The script reflects the recommendations from SAP note 2600030 - Parameter Recommendations in SAP HANA Environments.

In it you find the more specific validity statement for the recommendations:

"Only recommendations for SAP HANA 1.0 SPS 10 and higher are listed."

[thomas_jung]

>The SAP note you mentioned is the correct (an only) source for the statement collection.

The only source part is not exactly true. In the HANA Database Explorer we have the Statement Library:

This statement library is pre-loaded with the scripts that used to only be delivered via the note in question. You can also use them as a starting point and develop and store your own scripts in this Statement Library.

[lbreddemann]

Good pointer to the new tooling!

Given that the pre-loaded scripts are simply a snapshot of whatever was attached to the SAP note, I'd say it's correct to say that the SAP note is the only source for the scripts.

Looking at my HANA Express SP03 (upgraded from SP02) I don't have the pre-loaded statements, so I assume that this pre-loading is rather new!?

Related to that: what's the mechanism for loading "SYSTEM" type statements? With SAP HANA Studio it was always a hassle to roll out script collections to many users as for each HANA Studio installation the statements had to be imported. The Statement explorer, being a centralised tool, now could overcome this hurdle by allowing to load non-user-specific (aka SYSTEM) statements. However, I didn't find any tool, button or documentation to do just that.

Can you help out with that Thomas?

Also: a customer recently asked me why there is no automatic update feature for the script collection built into HANA Studio or the statement explorer. Seeing that the scripts get updated nearly monthly, it would make sense to provide an automated feature to download and install the current version from my point of view. Maybe you can take that onto the backlog.

[thomas_jung]

SPS 03 definitely should have this statement library.

>he Statement explorer, being a centralised tool, now could overcome this hurdle by allowing to load non-user-specific (aka SYSTEM) statements

The Statement Library of the Database Explorer is stored on the server - not on the client side and uploaded scripts are shared by everyone.

>a customer recently asked me why there is no automatic update feature for the script collection built into HANA Studio or the statement explorer

I can't speak to other tools, but the Statement Library of the Database Explorer does get updated when you patch/update the Database Explorer.

>However, I didn't find any tool, button or documentation to do just that.

To upload your own scripts to the Statement Library? There is an upload button in the Statement Library screenshot I posted above. Also any SQL Console window has a save to Statement Library feature in the toolbar.

[lbreddemann]

> The Statement Library of the Database Explorer is stored on the server - not on the client side and uploaded scripts are shared by everyone.

Not quite - only the SYSTEM type statements are.
And that's what I asked about: how to update these shared statements so that all users of the Database Explorer can use the current set of SQL scripts and not whatever was put in at the time the app was released.

Seeing that other HANA DBA tools like HANA Studio and the DBACockpit in ABAP allow for an easy import of new versions of the script library, I'm surprised to see that Database Explorer doesn't seem to provide this option.

The main bit here is that the SQL statement library gets updated far more regularly than the DB Explorer application.

When I do use the IMPORT function it only imports the scripts as USER type statements; which are not shared across users. Also, when I try to IMPORT yet another newer version of the scripts I get an error message for duplicate script names, something that HANA Studio avoided by importing into folders and sub-folders. Database Explorer doesn't have folders, which means I have to manually delete the old versions of scripts before I can import a newer version.

Looking at this it seems you're offering to either use the outdated set of pre-delivered statements or to have more hassle of maintaining a current set of statements than with HANA Studio or DBACockpit.

[thomas_jung]

I was thinking there was an option to choose to save to SYSTEM or USER type, but evidently is just our internal dev system where we develop and test the scripts. I'll have to ask development about the plans to roll this feature out.