dbspaces/tempspace shows up with a "B" flag

I recently installed IDS 9.40 FC6 on an HP 11i (64 bit). I set up the dbspaces using onmonitor. I didn't intend for any of them to be blob spaces, however when I do an onstat -d, here's what I see. Any idea what happened? How do I fix it? IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 04:47:36 -- 226252 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c000000008efce60 1 0x20001 1 1 N informix rootdbs c00000000a030b50 2 0x20001 2 1 N informix morenor c00000000a030cd0 3 0x42001 3 1 N TB informix tempspace1 c00000000a030e50 4 0x60001 4 1 N B informix holdspace c00000000a031028 5 0x20001 5 1 N informix acctspace c00000000a0311a8 6 0x20001 6 1 N informix soldspace c00000000a031328 7 0x20001 7 1 N informix physlog c00000000a0314a8 8 0x60001 8 1 N B informix oldspace c00000000a031628 9 0x20001 9 1 N informix norspace c00000000a0317a8 10 0x60001 10 1 N B informix extraspace

"mongie" <conniec@northlandcorp.com> wrote in message news:1131738104.373370.146270@g49g2000cwa.googlegroups.com... >I recently installed IDS 9.40 FC6 on an HP 11i (64 bit). I set up the > dbspaces using onmonitor. I didn't intend for any of them to be blob > spaces, however when I do an onstat -d, here's what I see. > Any idea what happened? You fucked up. > How do I fix it? Drop the "wrong" spaces. Re-add them correctly. If it were me I'd use onspaces.

The database server has been enabled to use chunks >2Gb. These dbspaces probably use large chunks (greater than 2Gb).