I just converted a universe written for Oracle to a DB2 one. I found it easier to rewrite everything down, so that I could see what had been done for Oracle (I was not member of the group that defined the universe under Oracle).
The greatest problems I had were with a date field that our users use to make statistics, because BO generates a GROUP BY clause that is not supported by DB2 (there was a mail exchange last week concerning this problem).
Finally we modified the DB2 table to avoid this problem on a table with 4 mios records.
I still don’t know how we will do on the bigger table (65 mios records). I’m not a big specialist of Oracle, but it’s quite easy to understand the TO_CHAR, TO_NUMBER and other Oracle specific functions. Of course a good knowledge of the target system is necessary. Installing the DB2 Connect V5 was a real source of surprises, because of some curious limitations : if you install it with the ‘Administrator’ user-id, then you cannot use the software. DB2 Connect says that the user ‘Administ’ does not have the necessary authorization ! We do not have performance problems, since there is only one user testing the reports. We will check for performance in August (most people are on holidays in July).
HTH
Pierrot
I am trying to convert universes written for oracle to sql server, db2 and db2/mvs.
Has anybody experiences, which syntax i have to change with what ?
I’m getting ready to convert a DB2 universe to Oracle . Any tips or tricks. My plan is to change the connection info then just parse and see what falls out. I’m sure I’ll have trouble with some DB2 specific functions. I’m sure I’ll have to do some table renaming for Oracle schemas. The column names are supposedly the same. I could make a new universe and repoint but I figured this would be worth a shot. We have quite a few reports we’d have to switch from universe DB2 to universe Oracle and some of those are Webi native which are a bear to repoint.
thank you for pointing this out as it gives us one more option in our initiative to move data off very costly DB2 OS390 to other platforms for BO reporting. I did a search in ASK TOM for “COPY DB2” and got some good info. I will definitely be sharing this with the Oracle DBA.
. Any tips or tricks. My plan is to change the connection info then just parse and see what falls out. I’m sure I’ll have trouble with some DB2 specific functions. I’m sure I’ll have to do some table renaming for Oracle schemas. The column names are supposedly the same. I could make a new universe and repoint but I figured this would be worth a shot. We have quite a few reports we’d have to switch from universe DB2 to universe Oracle and some of those are Webi native which are a bear to repoint.
(BOB member since 2002-06-11)
(BOB member since 2002-08-15)