IBM Support

Set or modify an NPS registry variable

Question & Answer


Question

How to modify or set an NPS registry variable that is persistent across NPS reboot?

Answer


There are two (2) ways where you can set or modify a registry variable.

(1) Not persistent across NPS reboot

    $ nzstate # Ensure that NPS is online

    $ nzsystem pause # to pause system
    $ nzsystem set -arg system.allowDiskHashJoin=false # to set value

    $ nzsystem resume # to resume system
    Note:
    - This will take effect for the duration of the system's uptime and the registry variable will return to default on subsequent nzstop/nzstart.

    - to set value, numeric values or true or false can be used

(2) Persistent across NPS reboot
    Edit (create if not present) system.cfg file

    vi /nz/data/config/system.cfg

    modify or set or add a line for the registry variable you want

    system.allowDiskHashJoin=false

    and then

    $ nzstop

    $ nzstart

To check and confirm the setting, please run :
nzsystem showRegistry | grep allowDiskHashJoin

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Administration","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2019

UID

swg21681311