Re: Redbrick Migration to DB2

asheesh rastogi said: > Hi there folks, > > I apologize for cross posting this, however given the dearth of activity > on > Redbrick list, I have no option. Now the question, > > I am ina scenario where we are looking to migrate a near 1 TB warehouse > from > Redbrick to DB2 8.2.4 (nope don't ask why). Has anybody carried out this > kind of an exercise or XPS to DB2? Was it succesfull, what challenges did > you face? Can you please share your expereieces. I haven't done one of these (yet) but the sort of things you need to consider are: 1. Loading -- Whorehouse Mangler isn't as good as TMU, or as flexible. 2. Reconciling floating point numbers could be a real bitch. 3. DB2's system catalogues aren't nearly as handy as RBW's... 4. ...and you're going to have rewrite all your sysadmin stuff 5. You may have to screw around with the schema and "tune" your SQL a bit, which means you will have to retest some / much / most / all of your application again. Don't f*ck with it if it's not broken. -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1933 and Section 21B of the S E C Act of 1934. Statements that involve discussions with respect to projections of future events are not statements of historical fact and may be forward looking statements. Don't rely on them to make a decision. The poster is not a reporting company registered under the Exchange Act of 1934. I have received a life peerage from Her Majesty, who is not an officer, minister or affiliate Labour party member. I intend to recover my loan now, which could cause the parliamentary majority to go down, resulting in losses for you. Today's Labour party has: an accumulated deficit and a reliance on loans from officers and affiliates to pay expenses. It is not an operating political party. The party is going to need financing to continue as a going concern. A failure to finance could cause the party to go out of business. This report shall not be construed as any kind of investment advice or solicitation. You can lose all your money by investing in this party.