Re: dbspaces/tempspace shows up with a "B" flag

Refer to 9.40 Admin Reference Guide. (onstat -d output description) http://publibfp.boulder.ibm.com/epubs/pdf/ct1syna.pdf here is what those flags means...(in your output B is in Position:4) flags Uses the following letter codes to describe each storage space: Position 1: M Mirrored N Not mirrored Position 2: X Newly mirrored P Physically recovered, waiting for logical recovery L Being logically recovered R Being recovered Position 3: B Blobspace S Sbspace Position 4: B Dbspace has large chunks greater than 2 GB Regards, Nilesh. Friday, November 11, 2005 4:13 PM To: informix-list@iiug.org cc: From: "mongie" <conniec@northlandcorp.com> Subject: 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 sending to informix-list