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

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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:

%dbaccess

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


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.1, 11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris

Reference #:

1504406

Modified date:

2013-10-01

Translate my page

Machine Translation

Content navigation