IBM Support

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

Troubleshooting


Problem

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

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

Document Information

Modified date:
16 June 2018

UID

swg21504406

Page Feedback