Failing initialization during installation

[Johannes Lebek]

Hello,

I'm trying to install Informix Dynamic Server 9.3 on Windows XP Professional
without any error messages. But I always get the same message:

"Unable to initialize the Dynamic Server. Check Event Viewer's Security log
and C:\Progra~1\Informix\sfo.log file for additional information."

"sfo" is my computer's host name. The file shows no warnings or error
messages and the Security view of the Event viewer is completely empty. The
other views do not show any error messages or warnings as well.

After reboot the database seems to work properly. "dbaccess" did not show
any unusual behaviour. I run into problems if I want to access smart BLOBs
via JDBC.
Then the SQL error message is

"Invalid default sbspace name (sbspace)."

Is it not allowed to name the default sbspace "sbspace", although Informix'
installation procedure suggests it?
Does anybody know this issue and how to work around?
Thanks in advance,

Johannes

[Johannes Lebek]

I made another installation of Informix. This time I named the default
sbspace 'def_sbspace'. The initialization failed again. The JDBC SQL
exception returns now "Invalid default sbspace name (def_sbspace)." as
expected. So, it is not really the name that bothers Informix...

Johannes.

[Lukas Eder]

In case anyone is still looking for this issue, I found a recent blog post explaining what to do in this case:
http://blog.facilelogin.com/2013/03/deploying-ibm-informix-on-microsoft.html

Essentially, I needed to create an sbspace.dbs file and register it with onspaces:

C:\> onspaces -c -S sbspace2 -p c:\informix_data\data.dbs -o 100 -s 20000 -Df "LOGGING=ON"

Hope this helps,
Lukas

[super...@t-online.de]

Hello Johannes,

When it is created you have to put it in onconfig too.

cd %INFORMIXDIR%\etc

write %ONCONFIG%

search for SBSPACE and fill in the space created above eq sbspace2.

stop and start the database....



Hope this helps


Superboer.