Re: Storage pool

I have received this message - at a live site and need to quickly fix - can you help with a pointer

What is the message? My finderr does not recognize 29275. You might check the informix log. "onstat -c | grep MSG" will show you the name of that log file. j. On Jan 16, 2013, at 7:32 AM, ROB KOTTLER wrote: > I have received this message - at a live site and need to quickly fix = - can=20 > you help with a pointer=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

This is the message: Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. I do not have access to the server with OAT

I could have predicted this open. (not from you, but from the storage = pool concept) I don't have the 20 minutes it would take to figure out the solution for = you, you'll have to google, but I can tell you what the problem is. The storage pool is a set of unallocated disk that the engine can grab = from to add to dbspaces when they are extendable and run low on disk. = Apparently you have a storage pool which is out of empty disk space to = hand to the engine when it wants to extend a dbspace. There is a table in the sysadmin database which records the storage = pools. There will be a sysadmin function (or ph_task) to add more space = to a storage pool - since that is what OAT uses to do the work. You = need to either add more disk to the storage pool called out in that = table, or clean up some disk space so the engine doesn't need to = allocate more disk from the storage pool. Others will be online in a bit, and I'll be done with my meetings around = noon and can dig a little deeper. =20 Good luck. j. On Jan 16, 2013, at 8:07 AM, ROB KOTTLER wrote: > This is the message:=20 > Warning: The storage pool is out of space. To enable automatic chunk=20= > creation use the OpenAdmin Tool to add space to the pool.=20 >=20 > I do not have access to the server with OAT=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

If you look in the manual under "storagepool add" you will find an SQL admin api command which will allow you to add space to the storage pool. In short, it would be something like: database sysadmin execute function task("storagepool add", "file_or_raw_device_or_directory", begin_offset, total_size, minimum_chunk_size, priority); John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 01/16/2013 05:20:57 AM: > From: "Jack Parker" <jack.parker4@verizon.net> > To: ids@iiug.org > Date: 01/16/2013 05:22 AM > Subject: Re: Storage pool [29278] > Sent by: ids-bounces@iiug.org > > I could have predicted this open. (not from you, but from the storage = > pool concept) > > I don't have the 20 minutes it would take to figure out the solution for = > you, you'll have to google, but I can tell you what the problem is. > > The storage pool is a set of unallocated disk that the engine can grab = > from to add to dbspaces when they are extendable and run low on disk. = > Apparently you have a storage pool which is out of empty disk space to = > hand to the engine when it wants to extend a dbspace. > > There is a table in the sysadmin database which records the storage = > pools. There will be a sysadmin function (or ph_task) to add more space = > to a storage pool - since that is what OAT uses to do the work. You = > need to either add more disk to the storage pool called out in that = > table, or clean up some disk space so the engine doesn't need to = > allocate more disk from the storage pool. > > Others will be online in a bit, and I'll be done with my meetings around = > noon and can dig a little deeper. =20 > > Good luck. > j. > > On Jan 16, 2013, at 8:07 AM, ROB KOTTLER wrote: > > > This is the message:=20 > > Warning: The storage pool is out of space. To enable automatic chunk=20= > > > creation use the OpenAdmin Tool to add space to the pool.=20 > >=20 > > I do not have access to the server with OAT=20 > >=20 > >=20 > > = > **************************************************************************= > *****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20= > > >=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thanks John. I really don't like the storage pool concept. It puts = another layer of things to go wrong between the engine and the admin. j. On Jan 16, 2013, at 12:05 PM, John Miller iii wrote: > If you look in the manual under "storagepool add" you will find an SQL=20= > admin api command which will allow you to add space to the storage = pool.=20 > In short, it would be something like:=20 >=20 > database sysadmin=20 > execute function task("storagepool add",=20> "file_or_raw_device_or_directory", begin_offset, total_size,=20 > minimum_chunk_size, priority);=20 >=20 > John F. Miller III=20 > STSM, Embedability Architect=20 > miller3@us.ibm.com=20 > 503-578-5645=20 > IBM Informix Dynamic Server (IDS)=20 >=20 > ids-bounces@iiug.org wrote on 01/16/2013 05:20:57 AM:=20 >=20 >> From: "Jack Parker" <jack.parker4@verizon.net>=20 >> To: ids@iiug.org=20 >> Date: 01/16/2013 05:22 AM=20 >> Subject: Re: Storage pool [29278]=20 >> Sent by: ids-bounces@iiug.org=20 >>=20 >> I could have predicted this open. (not from you, but from the storage = =3D=20 >> pool concept)=20 >>=20 >> I don't have the 20 minutes it would take to figure out the solution = for=20 > =3D=20 >> you, you'll have to google, but I can tell you what the problem is.=20= >>=20 >> The storage pool is a set of unallocated disk that the engine can = grab =3D=20 >> from to add to dbspaces when they are extendable and run low on disk. = =3D=20 >> Apparently you have a storage pool which is out of empty disk space = to =3D=20 >> hand to the engine when it wants to extend a dbspace.=20 >>=20 >> There is a table in the sysadmin database which records the storage =3D= =20 >> pools. There will be a sysadmin function (or ph_task) to add more = space =3D=20 >=20 >> to a storage pool - since that is what OAT uses to do the work. You =3D= =20 >> need to either add more disk to the storage pool called out in that =3D= =20 >> table, or clean up some disk space so the engine doesn't need to =3D=20= >> allocate more disk from the storage pool.=20 >>=20 >> Others will be online in a bit, and I'll be done with my meetings = around=20 > =3D=20 >> noon and can dig a little deeper. =3D20=20 >>=20 >> Good luck.=20 >> j.=20 >>=20 >> On Jan 16, 2013, at 8:07 AM, ROB KOTTLER wrote:=20 >>=20 >>> This is the message:=3D20=20 >>> Warning: The storage pool is out of space. To enable automatic=20 > chunk=3D20=3D=20 >>=20 >>> creation use the OpenAdmin Tool to add space to the pool.=3D20=20 >>> =3D20=20 >>> I do not have access to the server with OAT=3D20=20 >>> =3D20=20 >>> =3D20=20 >>> =3D=20 >>=20 > = **************************************************************************= =3D=20 >=20 >> *****=3D20=20 >>> Forum Note: Use "Reply" to post a response in the discussion = forum.=3D20=3D=20 >=20 >>=20 >>> =3D20=20 >>=20 >>=20 >>=20 >=20 > = **************************************************************************= *****=20 >=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20