Get error on dbimport

I am trying to do a dbimport, but keep keeping this error. ) extent size 16 next size 16 lock mode row; *** put loadcur 271 - Could not insert new row into the table. 131 - ISAM error: no free disk space I have checked the disk and there is room, could this be within the dbspace? I'm not sure what to look for. This is an export of our production DB, that we are trying to import to a test DB. Libi

During the import of this particular table, you ran out of space within the dbspace. The 'onspaces -a <dbspace_name> ' command (see the manuals) will allow you to add a chunk of disk to <dbspace_name>. John Carlson Informix DBA WHSmith USA L Maniace wrote: > > I am trying to do a dbimport, but keep keeping this error. > > ) extent size 16 next size 16 lock mode row; > *** put loadcur > 271 - Could not insert new row into the table. > > 131 - ISAM error: no free disk space > > I have checked the disk and there is room, could this be within the dbspace? > I'm not sure what to look for. This is an export of our production DB, that > we > are trying to import to a test DB. > > Libi

Hello! Do you load all data in the rootdbs? If yes, I will be silence. If no, than put into the statement ) in otherdbs extent size 16 next size 16 lock mode row; Where otherdbs is the dbs, in which the data should be loaded. Look with onstat -d (tbstat -d) for other dbs than rootdbs. (not physdbs or logsdbs). Hope this help you. Andy L Maniace schrieb: > I am trying to do a dbimport, but keep keeping this error. > > ) extent size 16 next size 16 lock mode row; > *** put loadcur > 271 - Could not insert new row into the table. > > 131 - ISAM error: no free disk space > > I have checked the disk and there is room, could this be within the dbspace? > I'm not sure what to look for. This is an export of our production DB, that > we > are trying to import to a test DB. > > Libi