External table monitoring

IDS 11.50.fc7 Aix 6.1 Got an external table that I'm using to load an internal table ... Is there a quick way to figure out the progress ... Thanks in advance ... Peter Logan Senior Database Administrator Phone: 616/878-8309

If you have table stats enabled, you can use onstat to monitor the writes to the target table and reads from the source table. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Nov 5, 2010 at 11:19 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > IDS 11.50.fc7 > Aix 6.1 > > Got an external table that I'm using to load an internal table ... Is > there a quick way to figure out the progress ... > > Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e640d5069777d904944fffc2

The two quick things that I look at: onstat -g tpf < thread id of loader> This will show you the number of row inserted if you are using deluxe mode onstat -g ppf < partnum of target table > This will show you the current number of rows and pages in this table John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 11/05/2010 08:19:31 AM: > From: > > "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> > > To: > > ids@iiug.org > > Date: > > 11/05/2010 08:20 AM > > Subject: > > External table monitoring [21872] > > Sent by: > > ids-bounces@iiug.org > > IDS 11.50.fc7 > Aix 6.1 > > Got an external table that I'm using to load an internal table ... Is > there a quick way to figure out the progress ... > > Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

What if the target table is fragmented ... at that point can I only check things at the partition level? Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "John Miller iii" <miller3@us.ibm.com> To: ids@iiug.org Date: 11/07/2010 12:49 PM Subject: Re: External table monitoring [21891] Sent by: ids-bounces@iiug.org The two quick things that I look at: onstat -g tpf < thread id of loader> This will show you the number of row inserted if you are using deluxe mode onstat -g ppf < partnum of target table > This will show you the current number of rows and pages in this table John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 11/05/2010 08:19:31 AM: > From: > > "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> > > To: > > ids@iiug.org > > Date: > > 11/05/2010 08:20 AM > > Subject: > > External table monitoring [21872] > > Sent by: > > ids-bounces@iiug.org > > IDS 11.50.fc7 > Aix 6.1 > > Got an external table that I'm using to load an internal table ... Is > there a quick way to figure out the progress ... > > Thanks in advance ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.