can't create database

Hello i have one problem i can't create database on my dbspace.What should i do? Recently i have added new dbspace on my new instance but i could't create database on that dbspace.The error occured is: 225 : Cannot create file for system catalog (systables) 196 : ISAM error: operation not allowed in temporary DBspace I use dbaccess to create those database. Anyone please help me......

It looks like you're trying to create a database in a temporary DBspace. Try creating the database in a "regular" DBspace. I don't know if it's possible to actually create a database in temporary space if that's what you really want to do! The command onstat -d can be used to identify the purpose of the DBspaces: <snip> Dbspaces address number flags fchunk nchunks flags owner name d09f67e8 1 0x1 1 1 N informix rootdbs d1436318 2 0x1 2 1 N informix physicallog d1436468 3 0x1 3 1 N informix logicallogs d14365b8 4 0x2001 4 1 N T informix tempdbs d1436708 5 0x2001 5 1 N T informix tempdbs1 d1436858 6 0x2001 6 1 N T informix tempdbs2 d14369a8 7 0x1 7 1 N informix data1 </snip> The above is an example of my onstat -d output. Note for the tempdbs spaces (nos. 4,5,6) the presence of the T in the flags column. In the instance above, I'd want to create my database in the data1 dbspace, not one of the temp dbspaces. Hope this helps Rob NOOR ANSARI.... wrote: > Hello i have one problem i can't create database on my dbspace.What should i do? > Recently i have added new dbspace on my new instance but i could't create database on that dbspace.The error occured is: > > 225 : Cannot create file for system catalog (systables) > 196 : ISAM error: operation not allowed in temporary DBspace > > I use dbaccess to create those database. > > Anyone please help me...... > > > > ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________