Troubleshooting
Problem
Your secondary server is up and running, but when you try to create a temporary table you receive errors -229 and-140
Symptom
From a Secondary Server you try to run a statement that creates a temp table similar the following:
'select * from <tableName> into temp <tempTable>'
Database selected
229: Could not open or create a temporary file.
140: ISAM error: operation illegal on a DR Secondary
Error in line 1
Near character position 39
Database closed.
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
29 September 2018
UID
swg21673824