Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    3

    Unanswered: Cannot write file /dbexport/xxx.unl - aio error code 27

    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

  2. #2
    Join Date
    Nov 2001
    Location
    Germany
    Posts
    14
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    112
    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
    Last edited by dananio; 06-06-02 at 15:28.

  4. #4
    Join Date
    May 2002
    Posts
    3

    Smile Solution found !!!

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •