× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2008

Re: FTP between LPARs doesn't produce the same row numbers in...

Does /tables/ mean to imply SQL TABLE? Has an interactive query report been performed and data paged through to get a visual if the transport seemed valid, or an automated compare for example by join against a saved\restored copy of the same data? Any DECIMAL or BINARY types? Are they both i5/OS for the /source/ and /target/ partitions? FTP using PUT or GET subcommand, on or to i5/OS? BINary or TEXT transport? TRIM setting?

Regards, Chuck

Dave Odom wrote:
source and target tables. Most target tables have more rows
than their source. There are a few tables where the numbers equal
but the majority of tables I'm FTPing have higher row counts on the
target side. Of course, I'm accounting for additions to the source
as it's in a production environment but the number of additional
rows in the target tables seems too high for any production
additions between the time I start the FTP and the time I compare
row counts. What am I missing in FTP's processing?

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.