IBM Support

Your On-Bar Command Fails with Error 329 in the Activity Log and the Sysutils Database is Missing.

Technote (troubleshooting)


Your Informix server sysutils database does not exist. How do you recreate it?


You execute a standard On-Bar (onbar) archive like the following:

onbar -b -L 0

The archive fails with the following messages reported to the online.log:

Archive on rootdbs ABORTED.
Aborted by client.

You examine the onbar activity log and find the following lines:

Archive started on rootdbs (Requested Level 0).
SQL -329 Database not found or no system permission.
ISAM -111 ISAM error:  no record found.

Note: The online log file and onbar activity log file are configured as MSGPATH and BAR_ACT_LOG, respectively.

Diagnosing the problem

Open menu DB-Access at the command prompt (%) as follows:


Select the following options in the DB-Access menu and determine if sysutils is among the listed databases:

Database -> Select

Resolving the problem

Execute the following command as user informix to build the sysutils database:

%dbaccess - $INFORMIXDIR/etc/sysutils.sql

Document information

More support for: Informix Servers

Software version: 11.1, 11.5, 11.7, 12.1

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris

Reference #: 1504406

Modified date: 01 October 2013

Translate this page: