Troubleshooting
Problem
Trying to use onbar as root but seeing errors 151, 0x97, and 43207. Have to manually run onbar because scheduled backups fail with errors 151, 0x97, and 43207.
Symptom
2009-04-15 11:07:46 1234 2345 /opt/informix/bin/onbar_d -b -L 0
2009-04-15 11:07:46 1234 2345 (-43207) Unable to open connection to database server: IBM Informix Dynamic Server Stopped..
2009-04-15 11:07:46 1234 2345 /opt/informix/bin/onbar_d complete, returning 151 (0x97)
Cause
The group id (gid) for user informix is not set to the gid of group informix.
Diagnosing The Problem
If your informix entries in /etc/group and /etc/passwd do not match up similarly to the example this is likely the problem you are experiencing.
The gid for user informix in this example is 202.
%grep informix /etc/group
informix:!:202:informix,root
The user id (uid) for user informix in this example is 101. The gid is set to 202 in the fourth position.
%grep informix /etc/passwd
informix:!:101:202:Informix Software:/home/informix
The id command will look like this:
%id informix
uid=101(informix) gid=202(informix)
Resolving The Problem
Change the user informix /etc/passwd entry to use the informix gid.
See the Related URL section for more information regarding the creation of the informix uid and gid.
Workarounds
- Run the backup as user informix instead of root.
- Run the backup script as root but su to informix in the script.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21319715