Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
NEIL HAUGHTON — — source: IIUG Forums & Mailing Lists
I think I may have created my (development) Informix database server with too
small a SBLOBSpace, so I am trying to extend it. (My current file sbspace.000
is only 1024K in size)
Using the command
C:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> onspaces -a sbspace -p C:\\\\IFMXDATA\\\\ol_mat
-o 1024 -s 500000
gives the response:
Verifying physical disk space, please wait ...
Smart Large Objects: sbspace exists but is currently down
I have three questions:
1. How do I confirm the SBLOBSpace file path?
2. What is the meaning of the offfset? Is this the existing file size, or can
I make it zero?
2. How should I respond to the above message?
TIA
Neil.
↪ replying to NEIL HAUGHTON
Jack Parker — — source: IIUG Forums & Mailing Lists
Depends on what you used for the original sblob space. Essentially you =
are trying to add a chunk to an existing dbspace.
If you use the same file as the original sbspace, then you need to =
offset it into the file the size of that original sbspace. If you are =
using a new file, then the offset can be 0.
Sounds like you just added the chunk overlapping your original chunk - =
which would not be a good thing.
If your original chunk was 102400, then your offset should be 102400.
You can check with onstat -d what that size is (or rather was), just =
remember to multiply it by your pagesize.
Regards,
Jack Parker
On Jul 15, 2011, at 9:40 AM, NEIL HAUGHTON wrote:
> I think I may have created my (development) Informix database server =
with too=20
> small a SBLOBSpace, so I am trying to extend it. (My current file =
sbspace.000=20
> is only 1024K in size)=20
>=20
> Using the command=20
>=20
> C:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> onspaces -a sbspace -p =
C:\\\\IFMXDATA\\\\ol_mat=20
> -o 1024 -s 500000=20
>=20
> gives the response:=20
>=20
> Verifying physical disk space, please wait ...=20
> Smart Large Objects: sbspace exists but is currently down=20
>=20
> I have three questions:=20
>=20
> 1. How do I confirm the SBLOBSpace file path?=20
> 2. What is the meaning of the offfset? Is this the existing file size, =
or can=20
> I make it zero?=20
> 2. How should I respond to the above message?=20
>=20
> TIA=20
>=20
> Neil.=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
↪ replying to Jack Parker
NEIL HAUGHTON — — source: IIUG Forums & Mailing Lists
Yup, that's exactly what I did. I've created a new database instance now, but
I'll remember that for the future.
Fortunately I had already scripted the entire set of tables, indexes, pks etc,
so it was not too much of a hassle for recreate a new server instance.
Thanks for the information.
Neil.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.