Oninit
Talk to an expert →

Informix Error -29049: Unable to locate/open Gateway setup file filename.

Cause and resolution

Unable to locate/open Gateway setup file filename.

If you are using IPC-pipe mode to start the Gateway process, you should ensure that the INFORMIXDIR environment variable was set correctly before the application starts.

* For IBM Informix Enterprise Gateway with DRDA:

An error occurred while locating or opening a Gateway ISAM setup file that the gwdba utility manages. The name of the ISAM setup file that is causing the error is returned in SQLERRM.

If you are using network connections, the IBM Informix Enterprise Gateway with DRDA database administrator must ensure that the named file exists in the $INFORMIXDIR/gw/sysinfo directory. If the file is missing, run gwdba to create it. The DBA also must ensure that the INFORMIXDIR environment variable was set correctly at the time that the gwd daemon was started.

* For IBM Informix Enterprise Gateway:

An error occurred while locating or opening an IBM Informix Enterprise Gateway ISAM setup file that the egwdba utility manages. The name of the ISAM setup file that is causing the error is returned in SQLERRM.

If you are using network connections, the IBM Informix Enterprise Gateway DBA must ensure that the named file exists in the $INFORMIXDIR/egw/sysinfo directory. If the file is missing, run egwdba to create it. The DBA also must ensure that the INFORMIXDIR environment variable was set correctly at the time that the egwd daemon was started.

* For IBM Informix Enterprise Gateway Manager:

An error occurred while locating or opening a Gateway ISAM setup file that the egmdba utility manages. The name of the ISAM setup file that is causing the error is returned in SQLERRM.

If you are using network connections, the IBM Informix Enterprise Gateway Manager database administrator must ensure that the named file exists in the "$INFORMIXDIR/egm/sysinfo" directory. If the file is missing, run "egmdba" to create it. The DBA also must ensure that the INFORMIXDIR environment variable was set correctly at the time that the "egmd" daemon was started.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29049 fires when a Gateway ISAM setup file can't be located or opened — per the official guidance, the setup file's name is returned in SQLERRM.

  1. The setup file missing from the product's sysinfo directory, per the official guidance — $INFORMIXDIR/gw/sysinfo for Gateway with DRDA, $INFORMIXDIR/egw/sysinfo for Enterprise Gateway, or $INFORMIXDIR/egm/sysinfo for Enterprise Gateway Manager.
  2. INFORMIXDIR not set correctly, per the official guidance — before the application starts (IPC-pipe mode) or at the relevant daemon's startup (network mode).
Solutions / Resolution
  1. Confirm the named file exists in the correct sysinfo directory for the Gateway product in use, per the official guidance.
  2. Run the matching *dba utility (gwdba/egwdba/egmdba) to create a missing file, per the official guidance.
  3. Confirm INFORMIXDIR was set correctly when the relevant daemon (gwd/egwd/egmd) started, per the official guidance, for network-mode setups.
Examples
N/A

No specific triggering statement is documented beyond an unreachable Gateway setup file.

Diagnostic Checks
  1. Extract the setup filename from SQLERRM, check for it in the product's sysinfo directory, and confirm INFORMIXDIR was correctly set.
Related Errors / Related Topics
  • -29048 — "ISAM Error: error message." A related Gateway setup-file error, on an ISAM-level failure reading a file rather than the file being unreachable at all.

A Gateway ISAM setup file couldn't be located/opened — check the product's sysinfo directory and INFORMIXDIR, recreating the file via the matching *dba utility if missing.