Troubleshooting
Problem
A query is run on a target server of an HDR pair. Whether the target is a read-only or updateable secondary, RSS, or SDS, the server can be enabled to run queries that can be held in a temporary dbspace. When a 'Select' query is run that requires 'into temp with no log', an SQL error -229 and ISAM error -140 may be returned.
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix Internet Foundation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"10.0;11.1;11.5;11.7","Edition":"Enterprise;Workgroup;Ultimate;Growth","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:
16 June 2018
UID
swg21605942