Sometimes it is neccessary to access Informix via a DOS command line window. Doing so can result in the error: Could not initialize the security subsystem.
Running any Informix commands in a MS DOS command line window can result in the error: Could not initialize the security subsystem. Please ensure that
this account has the necessary privileges and ensure INFORMIXSERVER
value exists in the registry and environment.
This error is due to the environment variables not set in order to access Informix correctly.
Resolving the problem
1.From the DOS command line window, cd to the folder where the Informix Database Server is installed
2. Run the dir command and locate a file named ol_yourserver.cmd
09/20/2013 12:45 PM 285 ol_informix1210_1.cmd
1 File(s) 285 bytes
0 Dir(s) 346,147,696,640 bytes free
3. Simply type the name of the file ol_yourserver.cmd. This will set the environment to access Informix from the DOS command line.
Here is an example of the contents of the ol_server.cmd file
> type ol_informix1210_1.cmd
set INFORMIXSQLHOSTS=C:\Program Files\IBM Informix Software Bundle\etc\sqlhosts.