cannot add index - dbimport error

Posted in 2006

Summary

A dbimport (IDS 9.40) failed when creating a unique index with error 212 "Cannot add index" plus ISAM error 28 "No space left on device". Initial suggestions were that the target dbspace was full, but onstat -d showed free space in the data and temp dbspaces. The real cause: DBSPACETEMP was not set in onconfig, so index builds used the operating system /tmp filesystem, which ran out of room. Setting DBSPACETEMP to the existing tempspace1 and tempspace2 dbspaces let the dbimport complete successfully.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Migration, Import/Export & Data Conversion

Wahyu Cahyadi — Thu, 23 Nov 2006 06:55:45 — source: IIUG Forums & Mailing Lists

Hi, Now, I am trying to do dbimport informix database. Dbimport runs fine up until it creates a unique index the dbimport process stop and this error is: *** execute sqlobj 212 - Cannot add index. 28 - No space left on device Please help give me solution thanks in advance

↪ replying to Wahyu Cahyadi

alias shaari — Thu, 23 Nov 2006 07:14:44 — source: IIUG Forums & Mailing Lists

your dbspace is full!!! check it out. --- Wahyu Cahyadi <wahyu@takaful.com> wrote: > > Hi, > > Now, I am trying to do dbimport informix database. > Dbimport runs fine up until it creates a unique > index the dbimport > process stop > and this error is: > > *** execute sqlobj > 212 - Cannot add index. > > 28 - No space left on device > > Please help give me solution > > thanks in advance > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > > ________________________________________________________________________________ ____ Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited

↪ replying to alias shaari

Wahyu Cahyadi — Thu, 23 Nov 2006 07:29:58 — source: IIUG Forums & Mailing Lists

I have checked my dbspace using onstat -d and onmonitor--> Dbspaces>Info my dbspace is not full any other suggestion? alias shaari wrote: > your dbspace is full!!! check it out. > > --- Wahyu Cahyadi <wahyu@takaful.com> wrote: > > >> Hi, >> >> Now, I am trying to do dbimport informix database. >> Dbimport runs fine up until it creates a unique >> index the dbimport >> process stop >> and this error is: >> >> *** execute sqlobj >> 212 - Cannot add index. >> >> 28 - No space left on device >> >> Please help give me solution >> >> thanks in advance >>

↪ replying to Wahyu Cahyadi

Nandkishor Singare — Thu, 23 Nov 2006 07:30:42 — source: IIUG Forums & Mailing Lists

Hi, I think the dbspace in which you are importing the database is full. If dbspace is not the issue then add space to your temp dbspace. Informix requires temp dbspace for the index creation. regards, nandkishor On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> wrote: > > > Hi, > > Now, I am trying to do dbimport informix database. > Dbimport runs fine up until it creates a unique index the dbimport > process stop > and this error is: > > *** execute sqlobj > 212 - Cannot add index. > > 28 - No space left on device > > Please help give me solution > > thanks in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Wahyu Cahyadi

alias shaari — Thu, 23 Nov 2006 07:36:10 — source: IIUG Forums & Mailing Lists

sent me your onstat -d --- Wahyu Cahyadi <wahyu@takaful.com> wrote: > > I have checked my dbspace using onstat -d and > onmonitor--> Dbspaces>Info > my dbspace is not full > any other suggestion? > > alias shaari wrote: > > your dbspace is full!!! check it out. > > > > --- Wahyu Cahyadi <wahyu@takaful.com> wrote: > > > > > >> Hi, > >> > >> Now, I am trying to do dbimport informix > database. > >> Dbimport runs fine up until it creates a unique > >> index the dbimport > >> process stop > >> and this error is: > >> > >> *** execute sqlobj > >> 212 - Cannot add index. > >> > >> 28 - No space left on device > >> > >> Please help give me solution > >> > >> thanks in advance > >> > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > > ________________________________________________________________________________ ____ Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited

↪ replying to Nandkishor Singare

alias shaari — Thu, 23 Nov 2006 07:43:10 — source: IIUG Forums & Mailing Lists

u r right, nandkishor..... the informix temp dbspace is needed for index recreation.... ;) --- Nandkishor Singare <ns.singare@gmail.com> wrote: > > Hi, > > I think the dbspace in which you are importing the > database is full. > If dbspace is not the issue then add space to your > temp dbspace. > Informix requires temp dbspace for the index > creation. > > regards, > nandkishor > > On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> > wrote: > > > > > > Hi, > > > > Now, I am trying to do dbimport informix database. > > > Dbimport runs fine up until it creates a unique > index the dbimport > > process stop > > and this error is: > > > > *** execute sqlobj > > 212 - Cannot add index. > > > > 28 - No space left on device > > > > Please help give me solution > > > > thanks in advance > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the > discussion forum. > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > > ________________________________________________________________________________ ____ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com

↪ replying to alias shaari

Wahyu Cahyadi — Thu, 23 Nov 2006 07:53:44 — source: IIUG Forums & Mailing Lists

this is my onstat -d : my temp dbspace (tempspace1 and tempspace2) still have free space $ onstat -d IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 04:44:15 -- 55824 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 700000020182e58 1 0x20001 1 1 N informix rootdbs 7000000501435c8 2 0x20001 2 6 N informix idsspace1 70000005017d688 3 0x20001 8 2 N informix idsspace2 70000005017e0c8 4 0x20001 10 2 N informix idsspace3 70000005017eb08 5 0x20011 12 1 N B informix blobspaces1 70000005017ee20 6 0x20001 13 2 N informix idxgts1 70000005017f860 7 0x20001 15 2 N informix idxgts2 7000000501a9370 8 0x2001 17 1 N T informix tempspace1 7000000501a9b88 9 0x2001 18 1 N T informix tempspace2 7000000501aa3f0 10 0x20001 19 1 N informix logspace1 7000000501aac98 11 0x20001 20 1 N informix physpace 11 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chunk/dbs offset size free bpages flags pathname 700000020183028 1 1 0 512000 359468 PO-- /informix/current/data/aturootdbs 700000050143748 2 2 0 512000 1 PO-- /informix/current/data/ratuidsspace11 700000050143e70 3 2 0 512000 1 PO-- /informix/current/data/ratuidsspace12 70000005017d028 4 2 0 512000 126183 PO-- /informix/current/data/ratuidsspace13 70000005017d1c0 5 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace14 70000005017d358 6 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace15 70000005017d4f0 7 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace16 70000005017d808 8 3 0 512000 9046 PO-- /informix/current/data/ratuidsspace21 70000005017df30 9 3 0 512000 454657 PO-- /informix/current/data/ratuidsspace22 70000005017e248 10 4 0 512000 203383 PO-- /informix/current/data/ratuidsspace31 70000005017e970 11 4 0 512000 511997 PO-- /informix/current/data/ratuidsspace32 70000005017ec88 12 5 0 512000 ~512000 512000 POB- /informix/current/data/ratublobspaces1 70000005017efa0 13 6 0 512000 492418 PO-- /informix/current/data/ratuidxgts11 70000005017f6c8 14 6 0 512000 511997 PO-- /informix/current/data/ratuidxgts12 70000005017f9e0 15 7 0 512000 510730 PO-- /informix/current/data/ratuidxgts21 70000005017fdc0 16 7 0 512000 511997 PO-- /informix/current/data/ratuidxgts22 7000000501a94f0 17 8 0 512000 511947 PO-- /informix/current/data/ratutempspace1 7000000501a9d08 18 9 0 512000 511947 PO-- /informix/current/data/ratutempspace2 7000000501aa570 19 10 0 512000 511947 PO-- /informix/current/data/ratulogspace1 7000000501aae18 20 11 0 128000 127947 PO-- /informix/current/data/ratuphyspace 20 active, 2047 maximum Expanded chunk capacity mode: disabled alias shaari wrote: > u r right, nandkishor..... > the informix temp dbspace is needed for index > recreation.... > > ;) > --- Nandkishor Singare <ns.singare@gmail.com> wrote: > > >> Hi, >> >> I think the dbspace in which you are importing the >> database is full. >> If dbspace is not the issue then add space to your >> temp dbspace. >> Informix requires temp dbspace for the index >> creation. >> >> regards, >> nandkishor >> >> On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> >> wrote: >> >>> Hi, >>> >>> Now, I am trying to do dbimport informix database. >>> >>> Dbimport runs fine up until it creates a unique >>> >> index the dbimport >> >>> process stop >>> and this error is: >>> >>> *** execute sqlobj >>> 212 - Cannot add index. >>> >>> 28 - No space left on device >>> >>> Please help give me solution >>> >>> thanks in advance >>> >>> >>>

↪ replying to Wahyu Cahyadi

Wahyu Cahyadi — Thu, 23 Nov 2006 08:05:49 — source: IIUG Forums & Mailing Lists

my DBSPACETEMP on my onconfig is default temp spaces (/tmp) You (shaari and nandkishor) are right, I don't have enough tempspace on my /tmp now, I change my onconfig DBSPACETEMP tempspace1,tempspace2I am trying dbimport now. I hope it will run sucessfully Wahyu Cahyadi wrote: > this is my onstat -d : > my temp dbspace (tempspace1 and tempspace2) still have free space > > $ onstat -d> > IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up > 04:44:15 -- 55824 Kbytes> > Dbspaces > address number flags fchunk nchunks flags owner > name > 700000020182e58 1 0x20001 1 1 N informix > rootdbs > 7000000501435c8 2 0x20001 2 6 N informix > idsspace1 > 70000005017d688 3 0x20001 8 2 N informix > idsspace2 > 70000005017e0c8 4 0x20001 10 2 N informix > idsspace3 > 70000005017eb08 5 0x20011 12 1 N B informix > blobspaces1 > 70000005017ee20 6 0x20001 13 2 N informix > idxgts1 > 70000005017f860 7 0x20001 15 2 N informix > idxgts2 > 7000000501a9370 8 0x2001 17 1 N T informix > tempspace1 > 7000000501a9b88 9 0x2001 18 1 N T informix > tempspace2 > 7000000501aa3f0 10 0x20001 19 1 N informix > logspace1 > 7000000501aac98 11 0x20001 20 1 N informix > physpace > 11 active, 2047 maximum > > Note: For BLOB chunks, the number of free pages shown is out of date. > > Run 'onstat -d update' for current stats. > > Chunks > address chunk/dbs offset size free > bpages flags pathname > 700000020183028 1 1 0 512000 359468 > PO-- /informix/current/data/aturootdbs > 700000050143748 2 2 0 512000 1 > PO-- /informix/current/data/ratuidsspace11 > 700000050143e70 3 2 0 512000 1 > PO-- /informix/current/data/ratuidsspace12 > 70000005017d028 4 2 0 512000 126183 > PO-- /informix/current/data/ratuidsspace13 > 70000005017d1c0 5 2 0 512000 511997 > PO-- /informix/current/data/ratuidsspace14 > 70000005017d358 6 2 0 512000 511997 > PO-- /informix/current/data/ratuidsspace15 > 70000005017d4f0 7 2 0 512000 511997 > PO-- /informix/current/data/ratuidsspace16 > 70000005017d808 8 3 0 512000 9046 > PO-- /informix/current/data/ratuidsspace21 > 70000005017df30 9 3 0 512000 454657 > PO-- /informix/current/data/ratuidsspace22 > 70000005017e248 10 4 0 512000 203383 > PO-- /informix/current/data/ratuidsspace31 > 70000005017e970 11 4 0 512000 511997 > PO-- /informix/current/data/ratuidsspace32 > 70000005017ec88 12 5 0 512000 ~512000 512000 > POB- /informix/current/data/ratublobspaces1 > 70000005017efa0 13 6 0 512000 492418 > PO-- /informix/current/data/ratuidxgts11 > 70000005017f6c8 14 6 0 512000 511997 > PO-- /informix/current/data/ratuidxgts12 > 70000005017f9e0 15 7 0 512000 510730 > PO-- /informix/current/data/ratuidxgts21 > 70000005017fdc0 16 7 0 512000 511997 > PO-- /informix/current/data/ratuidxgts22 > 7000000501a94f0 17 8 0 512000 511947 > PO-- /informix/current/data/ratutempspace1 > 7000000501a9d08 18 9 0 512000 511947 > PO-- /informix/current/data/ratutempspace2 > 7000000501aa570 19 10 0 512000 511947 > PO-- /informix/current/data/ratulogspace1 > 7000000501aae18 20 11 0 128000 127947 > PO-- /informix/current/data/ratuphyspace > 20 active, 2047 maximum > > Expanded chunk capacity mode: disabled > > alias shaari wrote: > >> u r right, nandkishor..... >> the informix temp dbspace is needed for index >> recreation.... >> >> ;) >> --- Nandkishor Singare <ns.singare@gmail.com> wrote: >> >> >> >>> Hi, >>> >>> I think the dbspace in which you are importing the >>> database is full. >>> If dbspace is not the issue then add space to your >>> temp dbspace. >>> Informix requires temp dbspace for the index >>> creation. >>> >>> regards, >>> nandkishor >>> >>> On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> >>> wrote: >>> >>> >>>> Hi, >>>> >>>> Now, I am trying to do dbimport informix database. >>>> >>>> Dbimport runs fine up until it creates a unique >>>> >>>> >>> index the dbimport >>> >>> >>>> process stop >>>> and this error is: >>>> >>>> *** execute sqlobj >>>> 212 - Cannot add index. >>>> >>>> 28 - No space left on device >>>> >>>> Please help give me solution >>>> >>>> thanks in advance >>>> >>>> >>>>

↪ replying to Wahyu Cahyadi

Marcus Haarmann — Thu, 23 Nov 2006 08:08:56 — source: IIUG Forums & Mailing Lists

Hi, In which DBSpace is the index created ? Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wahyu Cahyadi Sent: Thursday, November 23, 2006 8:54 AM To: ids@iiug.org Subject: Re: cannot add index - dbimport error [7879] this is my onstat -d : my temp dbspace (tempspace1 and tempspace2) still have free space $ onstat -d IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 04:44:15 -- 55824 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 700000020182e58 1 0x20001 1 1 N informix rootdbs 7000000501435c8 2 0x20001 2 6 N informix idsspace1 70000005017d688 3 0x20001 8 2 N informix idsspace2 70000005017e0c8 4 0x20001 10 2 N informix idsspace3 70000005017eb08 5 0x20011 12 1 N B informix blobspaces1 70000005017ee20 6 0x20001 13 2 N informix idxgts1 70000005017f860 7 0x20001 15 2 N informix idxgts2 7000000501a9370 8 0x2001 17 1 N T informix tempspace1 7000000501a9b88 9 0x2001 18 1 N T informix tempspace2 7000000501aa3f0 10 0x20001 19 1 N informix logspace1 7000000501aac98 11 0x20001 20 1 N informix physpace 11 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chunk/dbs offset size free bpages flags pathname 700000020183028 1 1 0 512000 359468 PO-- /informix/current/data/aturootdbs 700000050143748 2 2 0 512000 1 PO-- /informix/current/data/ratuidsspace11 700000050143e70 3 2 0 512000 1 PO-- /informix/current/data/ratuidsspace12 70000005017d028 4 2 0 512000 126183 PO-- /informix/current/data/ratuidsspace13 70000005017d1c0 5 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace14 70000005017d358 6 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace15 70000005017d4f0 7 2 0 512000 511997 PO-- /informix/current/data/ratuidsspace16 70000005017d808 8 3 0 512000 9046 PO-- /informix/current/data/ratuidsspace21 70000005017df30 9 3 0 512000 454657 PO-- /informix/current/data/ratuidsspace22 70000005017e248 10 4 0 512000 203383 PO-- /informix/current/data/ratuidsspace31 70000005017e970 11 4 0 512000 511997 PO-- /informix/current/data/ratuidsspace32 70000005017ec88 12 5 0 512000 ~512000 512000 POB- /informix/current/data/ratublobspaces1 70000005017efa0 13 6 0 512000 492418 PO-- /informix/current/data/ratuidxgts11 70000005017f6c8 14 6 0 512000 511997 PO-- /informix/current/data/ratuidxgts12 70000005017f9e0 15 7 0 512000 510730 PO-- /informix/current/data/ratuidxgts21 70000005017fdc0 16 7 0 512000 511997 PO-- /informix/current/data/ratuidxgts22 7000000501a94f0 17 8 0 512000 511947 PO-- /informix/current/data/ratutempspace1 7000000501a9d08 18 9 0 512000 511947 PO-- /informix/current/data/ratutempspace2 7000000501aa570 19 10 0 512000 511947 PO-- /informix/current/data/ratulogspace1 7000000501aae18 20 11 0 128000 127947 PO-- /informix/current/data/ratuphyspace 20 active, 2047 maximum Expanded chunk capacity mode: disabled alias shaari wrote: > u r right, nandkishor..... > the informix temp dbspace is needed for index recreation.... > > ;) > --- Nandkishor Singare <ns.singare@gmail.com> wrote: > > >> Hi, >> >> I think the dbspace in which you are importing the database is full. >> If dbspace is not the issue then add space to your temp dbspace. >> Informix requires temp dbspace for the index creation. >> >> regards, >> nandkishor >> >> On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> >> wrote: >> >>> Hi, >>> >>> Now, I am trying to do dbimport informix database. >>> >>> Dbimport runs fine up until it creates a unique >>> >> index the dbimport >> >>> process stop >>> and this error is: >>> >>> *** execute sqlobj >>> 212 - Cannot add index. >>> >>> 28 - No space left on device >>> >>> Please help give me solution >>> >>> thanks in advance >>> >>> >>> **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Wahyu Cahyadi

lupasa@sisa.com.bo — Thu, 23 Nov 2006 15:29:13 — source: IIUG Forums & Mailing Lists

I think is /tmp filesystem Luis Panozzo Saavedra La Paz - Bolivia "Wahyu Cahyadi" <wahyu@takaful.com> Enviado por: ids-bounces@iiug.org 23/11/2006 05:33 a.m. Por favor, responda a ids@iiug.org Para ids@iiug.org cc Asunto Re: cannot add index - dbimport error [7875] I have checked my dbspace using onstat -d and onmonitor--> Dbspaces>Info my dbspace is not full any other suggestion? alias shaari wrote: > your dbspace is full!!! check it out. > > --- Wahyu Cahyadi <wahyu@takaful.com> wrote: > > >> Hi, >> >> Now, I am trying to do dbimport informix database. >> Dbimport runs fine up until it creates a unique >> index the dbimport >> process stop >> and this error is: >> >> *** execute sqlobj >> 212 - Cannot add index. >> >> 28 - No space left on device >> >> Please help give me solution >> >> thanks in advance >> ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Wahyu Cahyadi

Wahyu Cahyadi — Fri, 24 Nov 2006 01:18:48 — source: IIUG Forums & Mailing Lists

thanks shaari, nandkishor, marcus haarmann, and Luis Panozzo Saavedra. the problem has found. /tmp directory doesn't have enough space, so I changed DBSPACETEMP to tempspace1 dan tempspace2 I run dbimport again and dbimport has completed Wahyu Cahyadi wrote: > my DBSPACETEMP on my onconfig is default temp spaces (/tmp) > You (shaari and nandkishor) are right, I don't have enough tempspace on > my /tmp > now, I change my onconfig > DBSPACETEMP tempspace1,tempspace2> I am trying dbimport now. I hope it will run sucessfully > > Wahyu Cahyadi wrote: > >> this is my onstat -d : >> my temp dbspace (tempspace1 and tempspace2) still have free space >> >> $ onstat -d>> >> IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up >> 04:44:15 -- 55824 Kbytes>> >> Dbspaces >> address number flags fchunk nchunks flags owner >> name >> 700000020182e58 1 0x20001 1 1 N informix >> rootdbs >> 7000000501435c8 2 0x20001 2 6 N informix >> idsspace1 >> 70000005017d688 3 0x20001 8 2 N informix >> idsspace2 >> 70000005017e0c8 4 0x20001 10 2 N informix >> idsspace3 >> 70000005017eb08 5 0x20011 12 1 N B informix >> blobspaces1 >> 70000005017ee20 6 0x20001 13 2 N informix >> idxgts1 >> 70000005017f860 7 0x20001 15 2 N informix >> idxgts2 >> 7000000501a9370 8 0x2001 17 1 N T informix >> tempspace1 >> 7000000501a9b88 9 0x2001 18 1 N T informix >> tempspace2 >> 7000000501aa3f0 10 0x20001 19 1 N informix >> logspace1 >> 7000000501aac98 11 0x20001 20 1 N informix >> physpace >> 11 active, 2047 maximum >> >> Note: For BLOB chunks, the number of free pages shown is out of date. >> >> Run 'onstat -d update' for current stats. >> >> Chunks >> address chunk/dbs offset size free >> bpages flags pathname >> 700000020183028 1 1 0 512000 359468 >> PO-- /informix/current/data/aturootdbs >> 700000050143748 2 2 0 512000 1 >> PO-- /informix/current/data/ratuidsspace11 >> 700000050143e70 3 2 0 512000 1 >> PO-- /informix/current/data/ratuidsspace12 >> 70000005017d028 4 2 0 512000 126183 >> PO-- /informix/current/data/ratuidsspace13 >> 70000005017d1c0 5 2 0 512000 511997 >> PO-- /informix/current/data/ratuidsspace14 >> 70000005017d358 6 2 0 512000 511997 >> PO-- /informix/current/data/ratuidsspace15 >> 70000005017d4f0 7 2 0 512000 511997 >> PO-- /informix/current/data/ratuidsspace16 >> 70000005017d808 8 3 0 512000 9046 >> PO-- /informix/current/data/ratuidsspace21 >> 70000005017df30 9 3 0 512000 454657 >> PO-- /informix/current/data/ratuidsspace22 >> 70000005017e248 10 4 0 512000 203383 >> PO-- /informix/current/data/ratuidsspace31 >> 70000005017e970 11 4 0 512000 511997 >> PO-- /informix/current/data/ratuidsspace32 >> 70000005017ec88 12 5 0 512000 ~512000 512000 >> POB- /informix/current/data/ratublobspaces1 >> 70000005017efa0 13 6 0 512000 492418 >> PO-- /informix/current/data/ratuidxgts11 >> 70000005017f6c8 14 6 0 512000 511997 >> PO-- /informix/current/data/ratuidxgts12 >> 70000005017f9e0 15 7 0 512000 510730 >> PO-- /informix/current/data/ratuidxgts21 >> 70000005017fdc0 16 7 0 512000 511997 >> PO-- /informix/current/data/ratuidxgts22 >> 7000000501a94f0 17 8 0 512000 511947 >> PO-- /informix/current/data/ratutempspace1 >> 7000000501a9d08 18 9 0 512000 511947 >> PO-- /informix/current/data/ratutempspace2 >> 7000000501aa570 19 10 0 512000 511947 >> PO-- /informix/current/data/ratulogspace1 >> 7000000501aae18 20 11 0 128000 127947 >> PO-- /informix/current/data/ratuphyspace >> 20 active, 2047 maximum >> >> Expanded chunk capacity mode: disabled >> >> alias shaari wrote: >> >> >>> u r right, nandkishor..... >>> the informix temp dbspace is needed for index >>> recreation.... >>> >>> ;) >>> --- Nandkishor Singare <ns.singare@gmail.com> wrote: >>> >>> >>> >>> >>>> Hi, >>>> >>>> I think the dbspace in which you are importing the >>>> database is full. >>>> If dbspace is not the issue then add space to your >>>> temp dbspace. >>>> Informix requires temp dbspace for the index >>>> creation. >>>> >>>> regards, >>>> nandkishor >>>> >>>> On 11/23/06, Wahyu Cahyadi <wahyu@takaful.com> >>>> wrote: >>>> >>>>

Related threads

Glossary

dbexport / dbimport