IBM Support

How to recreate the sysuser or sysutils database?

Technote (troubleshooting)

This document applies only to the following language version(s):



If you drop by mistake the sysuser or sysutils database, how can they be recreated?

Resolving the problem

There is a script under $INFORMIXDIR/etc called sysuser.sql and sysutils.sql.

To execute this scrip run:

Dbaccess -> Query-language -> sysmaster -> Choose -> sysuser.sql > run


Dbaccess -> Query-language -> sysmaster -> Choose -> sysutils.sql > run

Document information

More support for: Informix Servers

Software version: 11.70

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

Reference #: 1616921

Modified date: 19 November 2012