scott is the user used by informix at the data source. Example: Owner value as specified in SQL statement Owner value used by the data source ANSI database Non-ANSI database "Valau" "Valau" "Valau" Valau "VALAU" "valau" not specified "informix" "scott" In this Symptom You might get Errors -206 and -111 when referring to a database object (table, view, synonym) using a fully qualified name with IBM Informix Enterprise Gateway Manager™ (EGM) in SELECT, United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search.
The -d option indicates that all files and tables from the previous run of archecker table-level restore are removed before the new restore begins. These working tables refer to acu_ tables in the sysutils database that are created during an archecker table-level restore. Resolving the problem Make sure that the table exists at the data source and consider the rules that apply to the owner value on fully qualified object names. If the database logging mode is a non-ANSI database, do not send an owner value.
ontape example: archecker -tdvs -f schema_command_file onbar example: archecker -bdvs -f schema_command_file Document information More support for: Informix Servers Software version: 10.0, 11.1, 11.5, 11.7 Operating system(s): AIX, HP-UX, Linux, Solaris, Symptom Archecker table level restore returns ERROR: -206: The specified table (informix.ext_tlr_1) is not in the database. Cause Previous restore attempts failed Resolving the problem If you repeatedly run the same archecker table-level restore, you must clean up the archecker table-level restore working files and tables from the Get More Info Watson Product Search Search None of the above, continue with my search Archecker table level restore returns ERROR: -206: The specified table (informix.ext_tlr_1) is not in the database Technote (troubleshooting) Problem(Abstract)
Cause Errors -206 and -111 indicate the object does not exist in the remote target. Document information More support for: Informix Tools Informix Enterprise Gateway Manager Software version: 1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 3.0, Watson Product Search Search None of the above, continue with my search Errors -206 and -111 attempting to access database objects with Enterprise Gateway Manager egm 211 111 uppercase lowercase Technote To construct the fully qualified name, the following rules apply: 1.