IBM Support

ONBAR BACKUP RETURNS ERRORS 151, 0x97, 43207

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.

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.5;7.3;9.4;11.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21319715