Alters table write-ahead log (WAL) settings. Returns information about the
requested table WAL modifications.
Input Parameter Description
array of strings
List of tables to modify. An asterisk changes the system settings.
map of string to strings
Optional parameters.The default value is an empty map ( {} ).
Show options
Maximum size of an individual segment file.
Approximate number of segment files to split the WAL across. Must be at least two.
Maximum size of an individual segment file.
none: Disables the WAL.
background: WAL entries are periodically written instead of immediately after each operation.
flush: Protects entries in the event of a database crash.
fsync: Protects entries in the event of an OS crash.
Specifies how frequently WAL entries are written with background sync. This is a global setting and can only be used with the system {options.table_names} specifier ’*’.
If true each entry will be checked against a protective checksum.The default value is true.The supported values are:
true
false
If true tables with unique WAL settings will be overridden when applying a system level change.The default value is false.The supported values are:
true
false
If true tables with unique WAL settings will be reverted to the current global settings. Cannot be used in conjunction with any other option.The default value is false.The supported values are:
true
false
If true and a system-level change was requested, the system configuration will be written to disk upon successful application of this request. This will commit the changes from this request and any additional in-memory modifications.The default value is true.The supported values are:
true
false
Output Parameter Description
The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:
String
‘OK’ or ‘ERROR’
String
Empty if success or an error message
String
‘alter_wal_response’ or ‘none’ in case of an error
String
Empty string
JSON or String
This embedded JSON represents the result of the /alter/wal endpoint:
Show data_str
map of string to strings
Additional information.
Empty string in case of an error.
Assistant
Responses are generated using AI and may contain mistakes.