Getting list of all actual parameters via dcmcli

[ThomasT]

Hello,

until now we checked parameter changes between different MaxDB-Versions via dbmcli-command "paramsdirectgetall". Now we noticed that there are not all parameters in the output (e.g. OPTIMIZE_OPERATOR_JOIN_COSTFUNC).

Is there any command to get a complete List of the actual parameters including Support-Parameters?

Regards,

Thomas True

[Melanie · Accepted solution]

Hello Thomas,

you have more parameters than can be transferred in one communication package.

Please use

dbmcli -d <db_name> -u <user>,<password>

> param_directgetall

> param_directgetallnext

> param_directgetallnext

...

Until the first line of the result is OK instead of CONTINUE.

Alternatively you can use

dbmcli -d <db_name> -u <user>,<password> -nohold param_directgetall

The nohold option automatically gets the next set of parameters until there are none left.

Regards,

Melanie

[ThomasT · Accepted solution]

Thanks Melanie,

the "-nohold" option was just the right way to get all the parameters.

Regards,

Thomas

[Former Member]

Hi,

Check SAP Note 1111426 - Parameter check for liveCache/MaxDB instances

but it's for MaxDB 7.5 or higher

regards,

kaushal