Informix Error -32166: RSAM could not be found or executed by the current user.

Reasons / Common Causes

-32166 fires when the current user can't find or execute RSAM (the ISAM component) — per the official guidance.

1. $INFORMIXDIR/$SQLEXEC misconfigured, per the official guidance — the first named case.
2. The current user isn't in the ix_users, ix_dbsa, or ix_dbsso group, per the official guidance — the second named case.
3. The ISAM executable in $INFORMIXDIR/lib isn't executable by the current session, per the official guidance — the third named case.

Solutions / Resolution

1. Check $INFORMIXDIR/$SQLEXEC settings, per the official guidance.
2. Ensure the current user is a member of ix_users, ix_dbsa, or ix_dbsso, per the official guidance.
3. Check that the ISAM executable in $INFORMIXDIR/lib is executable by the session, per the official guidance.

Examples

Checking the ISAM executable's permissions

$ ls -l $INFORMIXDIR/lib/*isam*
$ groups

Diagnostic Checks

1. Check $INFORMIXDIR/$SQLEXEC, group membership, and the ISAM executable's permission bits.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -32166 in this set yet.

RSAM couldn't be found or executed — check $INFORMIXDIR/$SQLEXEC, group membership, and the ISAM executable's permissions.