IBM Support

Rational Synergy 7.2 Informix server creation fails on Windows 2008

Troubleshooting


Problem

Attempts to create a database server using IBM Rational Synergy 7.2 on Windows 2008 results in the error ERROR: Failed to write ONCONFIG to SOFTWARE\INFORMIX\ONLINE\\Environment Clean up database server's files.... WARNING: Registry_Delete() for SOFTWARE\INFORMIX\SQLHOSTS\failed on \\.

Symptom

After logging in to the Windows 2008 server as local user informix, opening a command prompt, running the 'ccmsrv create' command, and answering the prompts, the command fails while creating the server. After summarizing the proposed database configuration, the error looks like this:

...
Would you like to create the database server? (Y/N) [Y] y
Failed to write ONCONFIG to SOFTWARE\INFORMIX\ONLINE\<systemname>\Environment
Clean up database server's files....
WARNING: Registry_Delete() for SOFTWARE\INFORMIX\SQLHOSTS\<systemname>failed on \\<systemname>.

Cause

Insufficient privileges for the local informix user.

Environment

Windows 2008

Resolving The Problem

Perform the following steps to resolve this issue:

1) Create a local user account for user informix:
a. Add user informix to the local Informix-Admin group.
b. Add user informix to the local Administrators group for the local machine.

2) Add the following rights on the local machine to the local user informix:
a. Act as part of the operating system.
b. Create a token object.
c. Log on as a service.

3) Ensure that the command prompt has been opened using "Run As Administrator."

If taking these steps do not work, read the following technote:

https://www-304.ibm.com/support/docview.wss?uid=swg21430794 &wv=1

In particular, refer to the section at the bottom that advises the download of the ntutils utility from Informix
(ftp://ftp.iiug.org/pub/informix/pub/ntutils.zip) and running the addrights.exe for the informix user.

4) Finally, read this technote: http://www-01.ibm.com/support/docview.wss?uid=swg21613086 to ensure that the windows\system32 directory is correctly represented in the PATH.

[{"Product":{"code":"SSC6Q5","label":"Rational Synergy"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.2.0.3;7.2.0.2;7.2.0.1;7.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
22 December 2020

UID

swg21615898