BMC has UNLOAD utility for UDB. Breaking EXPORT into multiple file streams may help. Also, in EEE IMPORT has an option of specifying BUFFERED INSERTS. There is a caveat with error reporting when using this option. Please refer to the Data Movement Utility Guide.
Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: Amir Sadeghi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 11:07 PM To: [EMAIL PROTECTED] Subject: [DB2EUG] Improving EXPORT Performance & DB2 High Performance Unload Hi, I am looking into ways to improve the unloading of data in our EEE database as our table sizes have grown considerably. Does anyone have a tip to share? Would breaking up the EXPORT by nodenumber help share the load and utilize various CPUs? I am also looking into the new 'High Performance Unload' tool from IBM and am wondering if anyone has had experience with it. Any input is appreciated. Thanks _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
