Cannot add a new chunk to the DBspace

Hi, i tried to add new chunk to database but it's failed with error. chunk size is 2GB and this dbspace has 55 chunks exist. OS version: AIX 5.3 informix version: IDS 7.31 in disk level and VG level has enough space. error: $ onspaces -a regdbs -p /dblinks/dbsreg59 -o 0 -s 2096128Verifying physical disk space, please wait ... Cannot add a new chunk to the DBspace. ISAM error: no free disk space what would be the case for this issue ? any one has idea about this. Thanks Pushpa

Hu, really old version. That one can only handle 2GB chunks. The size parameter should work (maximum would be 2097152). Check if you have enough space on the device (with dd maybe), I would suspect a partitioning problem. dd if=/dev/zero of=/ dblinks/dbsreg59 bs=1024 count= 2096128 (should run through, not break with an error, like end of medium reached or similar) (We recently replaced such an old version with a Linux based 11.70 Innovator Edition, which now runs on virtualized hardware and has the same functionality as before, addressed over TCP from a very old SCO based legacy system. Definitely, you should consider upgrading since you will get no support in case you run into any problem. We upgraded only the IDS and all the old apps were usable without change, you should give it a try maybe with a 11.70 Innovator edition, normally you would not touch the memory/processor restriction compared to such an old system and gain a performance improvement, together with the ability to backup in files instead of tapes (which was one of the reasons we replaced the old system). Of course, there is no direct upgrade path, so we did a dbexport/dbimport which was really fast (estimate data size was 25GB). There is one drawback - you cannot use the 12.x version of Innovator, looking on the amount of data you handle, because there is a restriction. But there maybe the choice to use the express edition or workgroup edition instead, in case nobody would be interested to invest a lot of money to licence costs. It is more expensive to run into a non-functional system because of failing old hardware) Hope this helps, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "PUSHPA KUMARA" <pushpa@cybersoft.lk> An: ids@iiug.org Gesendet: Mittwoch, 29. Juni 2016 09:18:24 Betreff: Cannot add a new chunk to the DBspace [37323] Hi, i tried to add new chunk to database but it's failed with error. chunk size is 2GB and this dbspace has 55 chunks exist. OS version: AIX 5.3 informix version: IDS 7.31 in disk level and VG level has enough space. error: $ onspaces -a regdbs -p /dblinks/dbsreg59 -o 0 -s 2096128Verifying physical disk space, please wait ... Cannot add a new chunk to the DBspace. ISAM error: no free disk space what would be the case for this issue ? any one has idea about this. Thanks Pushpa ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

I'd rather assume this old 7.31 server has no more room in root chunk to=20 expand reserved pages required for storing the additional chunk=20 descriptor. -> use 'oncheck -pe' to verify this assumption - no or only little=20 (contiguous) free space in root chunk -> try and free some space in root chunk, e.g. by unloading and dropping a = table residing there Once the chunk could be added, you might recreate and reload the dropped=20 table and it would find other space in rootdbs. HTH, Andreas From: "Marcus Haarmann" <marcus.haarmann@midoco.de> To: ids@iiug.org Date: 29.06.2016 10:19 Subject: Re: Cannot add a new chunk to the DBspace [37324] Sent by: ids-bounces@iiug.org Hu, really old version.=20 That one can only handle 2GB chunks.=20 The size parameter should work (maximum would be 2097152).=20 Check if you have enough space on the device (with dd maybe),=20 I would suspect a partitioning problem.=20 dd if=3D/dev/zero of=3D/ dblinks/dbsreg59 bs=3D1024 count=3D 2096128=20 (should run through, not break with an error, like end of medium reached=20 or=20 similar)=20 (We recently replaced such an old version with a Linux based 11.70=20 Innovator=20 Edition, which now runs=20 on virtualized hardware and has the same functionality as before,=20 addressed=20 over TCP from a very old SCO based legacy system.=20 Definitely, you should consider upgrading since you will get no support in = case you run into any problem.=20 We upgraded only the IDS and all the old apps were usable without change,=20 you=20 should give it a try=20 maybe with a 11.70 Innovator edition, normally you would not touch the=20 memory/processor restriction=20 compared to such an old system and gain a performance improvement,=20 together=20 with the ability to backup in=20 files instead of tapes (which was one of the reasons we replaced the old=20 system).=20 Of course, there is no direct upgrade path, so we did a dbexport/dbimport=20 which was really fast (estimate data size was 25GB).=20 There is one drawback - you cannot use the 12.x version of Innovator,=20 looking=20 on the amount of data you handle,=20 because there is a restriction. But there maybe the choice to use the=20 express=20 edition or workgroup edition instead, in case nobody would=20 be interested to invest a lot of money to licence costs. It is more=20 expensive=20 to run into a non-functional system because=20 of failing old hardware)=20 Hope this helps,=20 Marcus Haarmann=20 ----- Urspr=FCngliche Mail -----=20 Von: "PUSHPA KUMARA" <pushpa@cybersoft.lk>=20 An: ids@iiug.org=20 Gesendet: Mittwoch, 29. Juni 2016 09:18:24=20 Betreff: Cannot add a new chunk to the DBspace [37323]=20 Hi,=20 i tried to add new chunk to database but it's failed with error. chunk=20 size is=20 2GB and this dbspace has 55 chunks exist.=20 OS version: AIX 5.3=20 informix version: IDS 7.31=20 in disk level and VG level has enough space.=20 error:=20 $ onspaces -a regdbs -p /dblinks/dbsreg59 -o 0 -s 2096128=20 Verifying physical disk space, please wait ...=20Cannot add a new chunk to the DBspace.=20 ISAM error: no free disk space=20 what would be the case for this issue ? any one has idea about this.=20 Thanks=20 Pushpa=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.=20

Hi Andreas, this instance has total 78 data chunks and 55 chunks for this dbspace and root chunk has free space as bellows 70000028006e2a8 1 1 50 65475 8 PO- /dblinks/rootpr 70000028006e3c0 1 1 50 65475 0 MO- /dblinks/rootmr 700000280cd45a0 75 1 25 131072 107509 PO- /dblinks/rootpr2 700000280cd4a00 75 1 25 131072 0 MO- /dblinks/rootmr2 thanks Pushpa

Pushpa From recollection of a similar error (many years ago) the free space required must be in the original root chunk and not in any additional chunk. Keith On 29 June 2016 at 10:57, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hi Andreas, > > this instance has total 78 data chunks and 55 chunks for this dbspace > and root chunk has free space as bellows > 70000028006e2a8 1 1 50 65475 8 PO- /dblinks/rootpr > 70000028006e3c0 1 1 50 65475 0 MO- /dblinks/rootmr > 700000280cd45a0 75 1 25 131072 107509 PO- /dblinks/rootpr2 > 700000280cd4a00 75 1 25 131072 0 MO- /dblinks/rootmr2 > > thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11469dec21c0e6053667f219

Correct, and this root chunk only has 8 free pages left which, even if=20 contiguous, might be too little - depends a bit on on your chunk path=20 lengths which, in v7, still used to impact the number of chunks fitting on = a single reserved page. Go and find some table in root dbspace, with an extent in root chunk (#1), = that you can drop and later recreate after you've added the chunk.=20 Alternatively, if you have your logical logs in rootdbs, find and drop one = residing in root chunk. HTH, Andreas From: "Keith Simmons" <smiley73@gmail.com> To: ids@iiug.org Date: 29.06.2016 12:09 Subject: Re: Cannot add a new chunk to the DBspace [37327] Sent by: ids-bounces@iiug.org Pushpa=20 >From recollection of a similar error (many years ago) the free space=20 required must be in the original root chunk and not in any additional=20 chunk.=20 Keith=20 On 29 June 2016 at 10:57, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote:=20 > Hi Andreas,=20 >=20 > this instance has total 78 data chunks and 55 chunks for this dbspace=20 > and root chunk has free space as bellows=20 > 70000028006e2a8 1 1 50 65475 8 PO- /dblinks/rootpr=20 > 70000028006e3c0 1 1 50 65475 0 MO- /dblinks/rootmr=20 > 700000280cd45a0 75 1 25 131072 107509 PO- /dblinks/rootpr2=20 > 700000280cd4a00 75 1 25 131072 0 MO- /dblinks/rootmr2=20 >=20 > thanks=20 > Pushpa=20 >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --001a11469dec21c0e6053667f219=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20