Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-140 ISAM error: operation illegal on a DR secondary.

UPDATABLE_SECONDARY disabled:

A DR secondary server is meant for read-only operations. Any kind of write operation to a nontemporary dbspace is not allowed. For example, you cannot create a table in a regular dbspace, and you cannot do an insert, update, or delete operation on a table in a regular dbspace.

Review your application logic and rewrite it to remove any operations that would write to a nontemporary dbspace.

UPDATABLE_SECONDARY enabled:

A DR secondary server is updatable. Some of the DML/DDL statements are not supported on an updatable secondary server. For example, create database without log is not supported on an updatable secondary server. Also raw tables and external tables creatiion are also not supported on secondary server.

All secondary servers:

Certain operations on the secondary servers require temporary data to be stored in temporary dbspaces, such as sorting and view processing. Ensure that temporary dbspaces are available for such operations.