Oninit
Talk to an expert →

Informix Error -19845: You cannot alter the logging mode of a table in a logged database on a primary server.

Cause and resolution

You cannot alter the logging mode of a table in a logged database on a primary server.

You cannot change a logged table in a logged database on a primary server into a RAW, nonlogging table because changes to that table would no longer be replicated to secondary servers. You cannot change a RAW, nonlogging table to a logged table in a logged database on a primary server because the secondary servers would not be able to process replicated transactions for that table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19845 fires when a table's logging mode is altered in a logged database on a primary server — per the official guidance.

  1. A logged table altered to RAW, per the official guidance — changes would no longer replicate to secondaries.
  2. A RAW table altered to logged, per the official guidance — secondaries couldn't process replicated transactions for a table that was never logged.
Solutions / Resolution
  1. Don't alter the logging mode of tables in a logged database on a primary server, per the official guidance — if RAW behavior is genuinely needed, follow the documented temporarily-disable-HDR procedure instead (see -19844).
Examples
N/A

No specific triggering statement is documented beyond an attempted logging-mode change on a primary server.

Diagnostic Checks
  1. Check whether the server is a primary with a logged database, before altering a table's logging mode.
Related Errors / Related Topics
  • -19844 — "Tables of type RAW are not allowed in a logged database on an HDR primary server." A related HDR/logging restriction, about creating a new RAW table rather than altering an existing one's mode.
  • -19846 — "You cannot access a nonlogging table (%s) in a logged database on a secondary server." A related HDR/logging restriction, about accessing a RAW table on the secondary.

A table's logging mode can't be altered in a logged database on a primary server — follow the documented temporary-HDR-disable procedure if RAW behavior is genuinely needed.