Why can't I create a database in a 107GB dbspace I created for my instance? 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit:


Downloaded via IIUG link and installed it.
I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs".
Install wizard created a Windows user "informix".
I connected to instance "server", logging in as "informix".
Executed an SQL script "CREATE DATABASE voters IN datadbs NLSCASE INSENSITIVE;"
This failed (see first image), then tried creating the db via dbaccess menu.
In dbaccess, dbspaces options did not show "datadbs", only root, phys, log &amp; sbs dbs',
but when I do a dir of the dbspaces it shows "datadbs" with 107GB (see second image).
I set the following values in "onconfig.server" (see third image), but still no dice!
How did you create the dbspace ? I'm a bit astonished that you showed up a directory listing instead of the output from onstat -d - just creating a file does not do the job.
Run onstat -d and see if there is a dbspace called "datadbs". If not, cd to the directory where the dbspace should reside, create a suitable file (i. e. echo gaga &gt;datadbs content does NOT matter) and create the dbspace using "onspaces". This should look similar to

onspaces -c -d datadbs -p c:\dbspaces\datadbs -o 0 -s 128000000


For more options enter onspaces -?

Hope this will help