IDS Forum

Re: named pipes - external tables

Posted By: Andreas Breitfeld
Date: Thursday, 13 June 2013, at 10:54 a.m.

In Response To: Re: named pipes - external tables (Peter_Logan@spartanstores.com)

On Thursday, June 13, 2013 03:40:30 pm you wrote:
> Sorry ... different tables .. different pipes ...different sessions ...
>
> Also, I have tried single threading in a script, and it seems that I get
> this error for every other table. Almost seems as if it takes the pipe a
> little bit to really be empty ...
If not already done you could try to increase the number of FIFO VPs, see
http://pic.dhe.ibm.com/infocenter/informix/v121/topic/com.ibm.admin.doc/ids_admin_1308.htm

Thanks,
Andreas

>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From: "JACQUES RENAUT" <jrenaut@us.ibm.com>
> To: ids@iiug.org,
> Date: 06/13/2013 09:32 AM
> Subject: Re: named pipes - external tables [30525]
> Sent by: ids-bounces@iiug.org
>
> Original post:
>
> Aix 5.3
> IDS 11.50.fc5
>
> I'm working on moving some data from informix to a Netezzza N1001-05. One
> of the ways we are looking to do this is by using external tables in
> informix which are named pipes ... Then on the netezza side the nzload
> utility is used to insert the data. This seems to be working well if I
> single thread things. When I attempt to run this a couple of time
> concurrently I get the following informix error: 26167, all data files
> are either full or corrupted. I don't get any OS errors.
>
> So, does anyone know if this is a limit of informix, to be able to only
> use one named pipe at a time, or is it a limitation of Aix, or neither and
>
> I just have something else messed up?
>
> Thanks for any help ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> Response:
> Can you be more specific on "run this a couple of time concurrently"? Do
> you
> mean have a couple of informix sessions/threads attempting to unload into
> the
> same external table that you have defined as a pipe, or you have a couple
> of
> informix sessions/threads attempting to unload into different external
> tables
> each with their own named pipe but only 1 informix thread per named pipe?
>
> Jacques Renaut
> IBM Informix Advanced Support
> APD Team
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Andreas Breitfeld; Informix Development Munich
IBM Deutschland Research & Development GmbH; Vorsitzende des Aufsichtsrats:
Martina Koederitz; Geschaeftsfuehrung: Dirk Wittkopp; Sitz der Gesellschaft:
Boeblingen; Registergericht: Amtsgericht Stuttgart, HRB 243294

Messages In This Thread

• named pipes - external tables
  Peter_Logan@spartanstores.com -- Thursday, 13 June 2013, at 9:10 a.m.
  • Re: named pipes - external tables
    JACQUES RENAUT -- Thursday, 13 June 2013, at 9:31 a.m.
    • Re: named pipes - external tables
      Peter_Logan@spartanstores.com -- Thursday, 13 June 2013, at 9:40 a.m.
      • Re: named pipes - external tables
        Andreas Breitfeld -- Thursday, 13 June 2013, at 10:54 a.m.
  • Re: named pipes - external tables
    Art Kagel -- Thursday, 13 June 2013, at 9:56 a.m.
    • Re: named pipes - external tables
      Peter_Logan@spartanstores.com -- Thursday, 13 June 2013, at 10:05 a.m.
    • Re: named pipes - external tables
      Sandor Szabo -- Thursday, 13 June 2013, at 10:54 a.m.
  • Re: named pipes - external tables
    Clifton Bean -- Thursday, 13 June 2013, at 10:08 a.m.
    • Re: named pipes - external tables
      Peter_Logan@spartanstores.com -- Thursday, 13 June 2013, at 10:11 a.m.
    • Re: named pipes - external tables
      Art Kagel -- Thursday, 13 June 2013, at 10:32 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.