Hello Frank, We have in production a fairly large Warehouse (over 6 TB) on DB2 UDB EEE 7.2 FP4 for over 8 months, and we had it in UAT prior to that. It performs well and is stable. We did not have a chance to do the FP upgrade, as we first need to upgrade development and run it for some time. Every time we about to upgrade to the latest FP, this FP becomes "problematic" and introduces new severe bugs. However, we are still in business :)
Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 4:04 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Pendlebury-Bowe, Leslie; [EMAIL PROTECTED] Subject: [DB2EUG] DB2 EEE V7 FP8 Crashing We are about to implement a very large Data Warehouse in DB2 EEE on a Regatta machine. As we have been working with what I call little DB2 (as opposed to big DB2 Mainframe OS/390), I am seeing that we have many cases where we are forced to recover the entire Database because DB2 crashes for various reasons. The most recent example of what I am talking about is DB2 Tempspace filled up and caused DB2 to crash. This is a known bug according to IBM and they have a fix for V7 FP8. The thing I find very concerning is that we can't simply bring DB2 backup. Rather we are in a position to have to recover the entire Database. Our warehouse is planned to be about 60 TB with thousands of tables. I am concerned about the fact it seems many times when DB2 crashes we are in this forced recovery situation. As the database continue to grow this is going to become more and more time consuming and fraught with danger. It also puts us in a negative light with the user community and our management. It appears little DB2 has stability problems and I am becoming concerned about the answer we keep getting from IBM to do a full recovery, or that seems to be the only solution. Do other's using DB2 on AIX seem to be experiencing this problem or needing to recover the entire DB?? I am concerned we are taking a huge step backwards by taking our warehouse off the Mainframe as it seems little DB2 is where big DB2 was 15 years ago. Anyone have any thoughts they would like to share? I appreciate the opportunity to discuss this with others in the real world. Frank - ::: 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
