Oninit
Talk to an expert →

Informix Error -19844: Tables of type RAW are not allowed in a logged database on an HDR primary server.

Cause and resolution

Tables of type RAW are not allowed in a logged database on an HDR primary server.

DML statements on RAW tables are not logged, and therefore not replicated to the HDR secondary server. If you need RAW tables on an HDR primary server, you must temporarily disable HDR. To use RAW tables on an HDR primary server: 1. Stop replication by shutting down the HDR secondary server. 2. Convert the HDR primary server into standard mode with the onmode -d standard command. 3. Create or alter the appropriate tables to type RAW. 4. Perform the required DML statements on the RAW tables. 5. Convert the RAW tables back to STANDARD tables. 6. Perform a level-0 archive. 7. Convert the server to an HDR primary server with the onmode -d primary command. 8. Physically restore the secondary server from the level-0 archive. 9. Restart replication by running the onmode -d secondary command on the secondary server.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19844 fires when a RAW table is created/altered in a logged database on an HDR primary server — per the official guidance. RAW-table DML isn't logged, so it can't replicate to the HDR secondary.

  1. A RAW table created/altered in a logged database on an HDR primary, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Temporarily disable HDR if RAW tables are genuinely needed on the primary, per the official guidance's documented procedure:
    1. Stop replication by shutting down the HDR secondary.
    2. onmode -d standard on the primary.
    3. Create/alter the tables to RAW.
    4. Perform the required DML.
    5. Convert the tables back to STANDARD.
    6. Take a level-0 archive.
    7. onmode -d primary to restore HDR primary mode.
    8. Physically restore the secondary from the level-0 archive.
    9. onmode -d secondary on the secondary to restart replication.
Examples
N/A

No specific triggering statement is documented beyond attempting a RAW table on an HDR primary.

Diagnostic Checks
  1. Check whether the server is an HDR primary with a logged database, before creating/ altering a table to RAW.
Related Errors / Related Topics
  • -19845 — "You cannot alter the logging mode of a table in a logged database on a primary server." A related HDR/logging restriction, about altering an existing table's logging mode rather than creating a new RAW table.
  • -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 rather than creating one on the primary.

RAW tables can't exist in a logged database on an HDR primary — temporarily disable HDR if genuinely needed, per the documented procedure.