Nope. Plenty of disk space, no ulimit.

-----Original Message-----
From: Smath Joseph
[mailto:db2udbdba-ezmlmshield-x58776038.[Email address protected]
Sent: Thursday, September 29, 2005 1:17 PM
To: LazyDBA Discussion
Subject: RE: Weird Export Behavior

Just a shot in the dark... How big does the export file get? Maybe you
are hitting some sort of file-size limit in your LINUX environment?

-----Original Message-----
From: Greig Wise
[mailto:db2udbdba-ezmlmshield-x46052071.[Email address protected]
Sent: Thursday, September 29, 2005 2:11 PM
To: LazyDBA Discussion
Subject: Weird Export Behavior

I'm running db2 udb v8, fixpak 9 on linux ia64. I've run into this
weird problem with export. I've got a table with about 13 million rows.
I'm issuing a simple "export to file.ixf of ixf select * from table".
I'm periodically monitoring the file size, just to keep apprised of the
progress of the export. After about 30 minutes, the file stops growing.
I look at a list applications - no lock wait. I do a snapshot for that
application. Says 4.8 million rows read. Continued snapshots say 4.8
millon rows read. Seems like the export is stuck for some reason. Db2
list applications continues to show UOW executing for that application.


The only different thing about the table I'm trying to export is that it
contains a "16K blob not logged compact" field. I've never had problems
before (on version 7 db2) trying to export tables with blobs like this.
Another weird thing is that if I try to do a force application on the
export, it takes about 30-60 minutes to actually clear the connection.

Anyone have any ideas on what's going on here?


Greig Wise


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page