I do a similar data dump on up to 2.5M records and don't have this
problem. The database is about 5G on a linux server, the extract
program uses IBO. Have you backed up and restored the database to see
if this may be the result of some kind of database corruption? Just a
thought.

>Right after the query is opened there is a while loop that just scans each
>record, puts the fields together into a string, then writes the record to
>the file. Everything finishes, the file is created, but then on exiting it
>just stalls at the db.close. The close has no problem on smaller databases.
>Just those over approximately 600 MB.
>
>