Informix Error -24136: CREATE DATABASE: dbspace '<dbsname>' not found on coserver one. </dbsname>
Cause and resolution
CREATE DATABASE: dbspace '<dbsname>' not found on coserver one. </dbsname>
In a version 8.x database server, you can only create databases in dbspaces on the first coserver.
Check the dbspace name you specified for the correct spelling. If the spelling is correct, see your database server administrator for the name of a dbspace that exists on coserver one. If you do not specify a dbspace in the CREATE DATABASE statement, the database server uses the dbspace specified in the ONCONFIG file parameter DBCREATE_DBS.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24136 fires when CREATE DATABASE names a dbspace that doesn't exist on coserver
one — per the official guidance, on a version 8.x database server, databases can only be
created in dbspaces on the first coserver.
- A
CREATE DATABASEdbspace name that doesn't exist on coserver one, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check the dbspace name's spelling, per the official guidance, as the first check.
- Ask the database server administrator for a dbspace that exists on coserver one, per the official guidance, if the name was correct.
- Omit the dbspace clause, per the official guidance, to let the server use the
DBCREATE_DBSONCONFIG parameter's dbspace instead.
Examples
N/A
No specific triggering statement is documented beyond naming a dbspace absent from coserver one.
Diagnostic Checks
- Check the dbspace name's spelling and confirm it exists on coserver one, or omit the
dbspace clause to use the
DBCREATE_DBSdefault.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -24136 in this set yet.
CREATE DATABASE named a dbspace not present on coserver one — use a dbspace that exists
there, or omit the clause to use the ONCONFIG default.