PDA

View Full Version : Cannot write file /dbexport/xxx.unl - aio error code 27

dieltjna
05-29-02, 07:09
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
muratmy
06-05-02, 06:30
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
dananio
06-06-02, 15:25
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
dieltjna
06-10-02, 13:01
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

Originally posted by muratmy
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