Skip to Content

Getting list of all actual parameters via dcmcli

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 24, 2008 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2008 at 09:39 AM

    Hi,

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

    but it's for MaxDB 7.5 or higher

    regards,

    kaushal

    Add comment
    10|10000 characters needed characters exceeded