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
