Re: IDS to DB2 conversion

Serge Rielau wrote: > Federation for example? Need in the middleware layer? Uhhh... federation? What's that? Sticking tons of big boxes together because your database server can't handle the load on a single instance? And I don't see why a database should have to compensate for badly designed middleware? > Also this is the principle of bang-for-the-buck. It is? > I can tell you first hand that sequences and serial/identity are nearly > identical under the hood. But one gives more options than the other. > Personally I'm a fan of RISC. Use the least number of features that > yield the most function. > Sequence + before trigger = serial/identity > How do you go from a serial/identity to a sequence? > A major ISV asked us this question a few years back. I couldn't come up > with a good answer. Best I could propose was to use a table with serial > and keep inserting into it. Then garbage collect on occassion. > Got a better idea? Stick with the serial? -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

OTC, No offense, but you look at this from an ivory-tower's perspective. Reality is not that you start from scratch. Let's assume a fictive company IBM buys a fictive company IFMX. Let's further assume IBM runs on DB2 and IFMX on IDS. Over night a few thousand customers and employees switch hands. Each company has specialized DBA's all of which would rather leave their company than betray there favorite DBMS *sound familiar?* So what will happen? Long term there may be some alignment, but short term nothing will change. The parent company is going to somehow try to integrate this heterogeneous system. But it doesn't ahev to be a merger. Just take any major bank. They run IMS (yes!!), and DB2 for z/Series for sure. Likely Sybase and Oracle are also in the mix. All this has nothing to do with what the company's preferred DBMS of the day is. They cannot move the apps. They are old, they are Cobol and the developers have long since retired or gone broke in .bomb. Welcome to reality Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab