Troubleshooting
Problem
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.
Symptom
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.
Cause
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
- example:
>dir *.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.
- example:
> ol_informix1210_1.cmd
Here is an example of the contents of the ol_server.cmd file
> type ol_informix1210_1.cmd
set INFORMIXDIR=C:\PROGRA~1\IBMINF~1
set REGMACHINE=\\ADMINIB-IBTFJTS
set INFORMIXSERVER=ol_informix1210_1
set ONCONFIG=onconfig.ol_informix1210_1
set INFORMIXSQLHOSTS=C:\Program Files\IBM Informix Software Bundle\etc\sqlhosts.
ol_informix1210_1
set PATH=%INFORMIXDIR%\bin;%PATH%
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21651873