Hi All, I realize this question has been posted before, but I have not seen much in the way of response, so I am reviving the question. I have a large data warehouse with controlled batch updates. Currently I am doing full weekly backups, however it is very expensive in terms of time and resources. Some data warehousing collogues have recommended using a series of db2looks in combination with table exports to backup up my data. Basically they are saying in a disaster situation, it would be faster to reload a table, or the whole database than to restore from tape. I also have restore concerns since we use archive logging, but non-recoverable loads. As a DBA I would prefer to have a regular full database backup, but see no reason to backup hundreds of GB's of indexes when they can be recreated. Remember we store all load file after loading. Does anyone use a similar unconventional backup strategy that they are willing to share? For those who feel that need more specifics to comment, here they are.
UBD-EEE 7.2 FP7 AIX 4.3.3 Tape backups Over a TB of data. I'm hoping to hear some thought on both sides of this argument. Thanks, Mike Patterson __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - ::: 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
