> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# alterWal

<div className="kinetica-doxygen">
  <div id="adf7af66ea19fd2293ee08504613b7d91" />

  <h2 className="memtitle"><span className="permalink"><a href="#adf7af66ea19fd2293ee08504613b7d91">◆ </a></span>alterWal() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1AlterWalResponse">AlterWalResponse</a> kinetica.Kinetica.alterWal </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1AlterWalRequest">AlterWalRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
                <td>)</td>

                <td />
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Alters table write-ahead log (WAL) settings.Returns information about the requested table WAL modifications. </p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L14963">14963</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a9653a364068141e2466ba572bd68c1a9" />

  <h2 className="memtitle"><span className="permalink"><a href="#a9653a364068141e2466ba572bd68c1a9">◆ </a></span>alterWal() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1AlterWalResponse">AlterWalResponse</a> kinetica.Kinetica.alterWal </td>
                <td>(</td>
                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">table\_names</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Alters table write-ahead log (WAL) settings.Returns information about the requested table WAL modifications. </p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_names</td>
              <td>List of tables to modify. An asterisk changes the system settings.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a836f6796d532f8e91a1f0d19fc9e559d">MAX\_SEGMENT\_SIZE</a>: Maximum size of an individual segment file. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a8cf0ab48a05ffd6aec28ab054b632e77">SEGMENT\_COUNT</a>: Approximate number of segment files to split the WAL across. Must be at least two. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7147ad29c1e65e003a3169c6beab14e2">SYNC\_POLICY</a>: Maximum size of an individual segment file. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a0df15791ca417f5d749daa0f51a19a38">NONE</a>: Disables the WAL. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a4d26f0ca0392a810177f5d89b8d4d9bd">BACKGROUND</a>: WAL entries are periodically written instead of immediately after each operation. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#ada4d89882551f398d5f01cc262be31de">FLUSH</a>: Protects entries in the event of a database crash. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a72d1781b47baab908255a9641b524543">FSYNC</a>: Protects entries in the event of an OS crash. </li>
                    </ul>
                  </li>

                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a81680ff046ef26fa162473e4c37e89c5">FLUSH\_FREQUENCY</a>: 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 '\*'. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a45d0de124d7060fb3ac75f18beef2d24">CHECKSUM</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> each entry will be checked against a protective checksum. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#ae8ef7b4477483162f61b8dd4a5267665">OVERRIDE\_NON\_DEFAULT</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> tables with unique WAL settings will be overridden when applying a system level change. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a993f4b146fbe957cb7e75e700e60fbfe">RESTORE\_SYSTEM\_SETTINGS</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> tables with unique WAL settings will be reverted to the current global settings. Cannot be used in conjunction with any other option. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7bad29895452731d5881cd43d8fbf5bf">PERSIST</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> 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. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L15145">15145</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a4c06e92f65e8b4351e61edd38171f4ce" />

  <h2 className="memtitle"><span className="permalink"><a href="#a4c06e92f65e8b4351e61edd38171f4ce">◆ </a></span>AlterWalAsync() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1AlterWalResponse">AlterWalResponse</a> > kinetica.Kinetica.AlterWalAsync </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1AlterWalRequest">AlterWalRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Alters table write-ahead log (WAL) settings.Returns information about the requested table WAL modifications. </p>
      <p>(async)</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L14980">14980</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="acab553153bb878dfb628d1d042e7249a" />

  <h2 className="memtitle"><span className="permalink"><a href="#acab553153bb878dfb628d1d042e7249a">◆ </a></span>AlterWalAsync() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1AlterWalResponse">AlterWalResponse</a> > kinetica.Kinetica.AlterWalAsync </td>
                <td>(</td>
                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">table\_names</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Alters table write-ahead log (WAL) settings.Returns information about the requested table WAL modifications. </p>
      <p>(async)</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_names</td>
              <td>List of tables to modify. An asterisk changes the system settings.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a836f6796d532f8e91a1f0d19fc9e559d">MAX\_SEGMENT\_SIZE</a>: Maximum size of an individual segment file. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a8cf0ab48a05ffd6aec28ab054b632e77">SEGMENT\_COUNT</a>: Approximate number of segment files to split the WAL across. Must be at least two. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7147ad29c1e65e003a3169c6beab14e2">SYNC\_POLICY</a>: Maximum size of an individual segment file. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a0df15791ca417f5d749daa0f51a19a38">NONE</a>: Disables the WAL. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a4d26f0ca0392a810177f5d89b8d4d9bd">BACKGROUND</a>: WAL entries are periodically written instead of immediately after each operation. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#ada4d89882551f398d5f01cc262be31de">FLUSH</a>: Protects entries in the event of a database crash. </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a72d1781b47baab908255a9641b524543">FSYNC</a>: Protects entries in the event of an OS crash. </li>
                    </ul>
                  </li>

                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a81680ff046ef26fa162473e4c37e89c5">FLUSH\_FREQUENCY</a>: 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 '\*'. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a45d0de124d7060fb3ac75f18beef2d24">CHECKSUM</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> each entry will be checked against a protective checksum. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#ae8ef7b4477483162f61b8dd4a5267665">OVERRIDE\_NON\_DEFAULT</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> tables with unique WAL settings will be overridden when applying a system level change. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a993f4b146fbe957cb7e75e700e60fbfe">RESTORE\_SYSTEM\_SETTINGS</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> tables with unique WAL settings will be reverted to the current global settings. Cannot be used in conjunction with any other option. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7bad29895452731d5881cd43d8fbf5bf">PERSIST</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> 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. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a97c468b28c860708b0a081de7e340b07">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1AlterWalRequest_1_1Options#a7d85772270ee04c20842e11ceb4246c5">TRUE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L15311">15311</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>
</div>