Q:

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 & 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!

A:

Since the datadbs file is not anywhere near 128 MiB, I wonder if you were successful in adding that dbspace.  One might be forgiven for thinking that in fact you were unsuccessful since the database server doesn't think it exists.
Use 'oncheck' or 'onstat' (or both) to check whether the dbspace exists and is intact.  If not, arrange to drop it, or simply remove the datadbs file and try again with the onspaces command.

