Dear all,

Can anyone tell me how i can unload a table bigger than 16G of data to a file.
We tried already, dbexport, unload, onpladm ... and everytime we got next error message :
Cannot write file /dbexport/sde_blk_2.unl - aio error code 27
We use informix IDS 9.21 on a unix/solaris2.6 system.
Our filesize limits are set to unlimitted ...

Can anyone help ?

Kind regards,

Nadine Dieltjens

try this specific file to unload with a where condition so you have smaller pieces of unl files.It means for this table you should do some manual export&import or write a small script...


Murat

if it can't write the file ,you will try to unload them into tape device ,
your data is 16G may have some problem that limitation of solaris or your filesystem is full .... for dbexport/dbimport they arn't the right tool to move data but it use for reorganize data in database to improve performance

I found a solution with the tool onpladm (high performance loader).
You can find information about this tool on the Informix website.
With this tool you can easily unload databases with a big volume of data.

Thanks to all of you for the replied messages.

Kind regards,

Nadine