Windows administrative utilities

You can use Informix® utilities and Windows utilities to administer and monitor the database server on Windows operating systems.

The following Informix® utilities simplify administration of the database server on Windows.

Utility Description and usage
ixpasswd.exe Changes the logon password for all services that log on as user informix. You can change the password interactively or on the command line by running the -y option. Using this utility, you are not required to manually change the password for each service whenever you change the informix password.

If you are logged on locally and run ixpasswd, it changes the password for services that log on as the local informix user. If you are logged on domain and run ixpasswd, it changes the password for services that log on as domain\informix

Usage: ixpasswd [-y new_password]

ixsu.exe Opens a command line window that runs as the specified user. The user is a local user unless you specify a domain name. If you do not specify a user name, the default user is informix. You no longer are required to log off as the current user and log on as informix to do DBA tasks that must be run as informix.

The ixsu utility requires Advanced User Rights:

  • Act as part of the operating system
  • Increase quotas
  • Replace a process-level token

For information about setting Advanced User Rights, see your Windows documentation.

Usage: ixsu [[domain\]username]

ntchname.exe Changes the registry entries for HCL Informix® from the old host name to the new host name. Run ntchname after you change the host name. This utility does not change user environment variables.

After you run ntchname, edit the %INFORMIXDIR%\%INFORMIXSERVER%.cmd file and change the INFORMIXSQLHOSTS entry to the new host name.

Usage: ntchname old_name new_name

Windows Event Viewer

The Event Viewer shows informational, warning, and error messages for the operating system, other applications, and the database server.

To show database server messages, from the Administrative Tools window, choose Event Viewer > Security. Double-click any event for a detailed message.

Windows Performance Monitor

The Windows Performance Monitor (perfmon.exe) shows resources such as processor, memory, cache, threads, and processes. The Performance Monitor also creates charts, alerts, and reports. You can save information to log files for later analysis.

To show the Performance Monitor, from the Administrative Tools window, choose Performance.