Viewing and setting parameters with ADMIN COMMAND

solidDB Help : Configuring and administering : Configuring solidDB : Managing parameters : Viewing and setting parameters with ADMIN COMMAND

You can change most server-side parameters (without restarting the solidDB server) by using ADMIN COMMANDs. All parameters are accessible with the ADMIN COMMANDs even if they are not present in the solid.ini configuration file.

Viewing parameters

You can view the parameter settings for all parameters, for all parameters in a section, or for a single parameter by using the ADMIN COMMAND 'parameter' command, see PARAMETER for details of all the options.

For example, to view all values (current, startup, and factory) for all parameters, use the following command:

ADMIN COMMAND 'parameter';

RC TEXT
-- ----
0 Accelerator ImplicitStart Yes Yes Yes
0 Accelerator ReturnListenErrors No No No
0 Com Listen tcp 2315, tcp 2315, tcp 1964
0 Com MaxPhysMsgLen 8192 8192 8192
0 Com RConnectLifetime 60 60 60
0 Com RConnectPoolSize 10 10 10
0 Com RConnectRPCTimeout 0 0 0
0 Com ReadBufSize 2048 2048 2048
0 Com SocketLinger Yes Yes Yes
0 Com SocketLingerTime 0 0 0
...
192 rows fetched.

Viewing the description of a specific parameter

You can view a detailed description of a specific parameter, which includes the parameter type, access mode, and current, startup, and factory default values, by using the ADMIN COMMAND 'describe parameter' command. For details of the command output, see DESCRIBE.

Note Parameter support can vary between platforms.

For example, to display a description of the Durabilitylevel parameter, use the following command:

ADMIN COMMAND 'describe parameter logging.durabilitylevel';

RC TEXT
-- ----
0 DurabilityLevel
0 Default transaction durability level
0 LONG
0 RW
02
03
02
7 rows fetched.

Setting a parameter value

Most parameters can be changed by using the ADMIN COMMAND 'parameter' command, see PARAMETER for details of all the options.

For example, to set the value of the DurabilityLevel parameter in the [Logging] section to "1", run the command:

ADMIN COMMAND 'parameter Logging.DurabilityLevel=1';

Depending on the access mode of the parameter, the change might not apply immediately, see Access mode and persistence of parameter modifications.

Note Parameter management operations are not part of a transaction and cannot be rolled back.

Go up to

Managing parameters