| MHenke on Jan 3, 2006 at 1:55:25 AM (# 5) No idea. But since DB2 is an IBM product, I'd reckon that their migration tool will do a quite proper job.
Why don't you simply try it? The worst thing that could be happen is that the new created DB2 database is FUBAR. Then trash it and do another attempt, who cares?
pashah72 on Jan 4, 2006 at 11:33:40 PM (# 6)Hi MHenke
I tried IBM toolkit but looks like it doesn't support db2 ver 7.1 because can't get oracle connection mssg is displayed. When I tried AdventNet SwisSQL Oracle to Db2 Edition 2.0, it passed thru all stages but in final stages displayed messg that cannot transfer data from source(oracle ver 8i) because can't find table in target database but table already exists in target database (db2 ver 7.1). So what's the problem?
Looking forward for an early reply.
MHenke on Jan 5, 2006 at 1:11:09 AM (# 7)
This message has been edited.Well, I'd still bet on the IBM migratio toolkit and update your DB2 to (at least) version 7.2 (which is a good idea anyway).
According to IBM's Redbook Oracle to DB2 UDB Conversion Guide that version is supported by the MTK.
Apart from that, you can
- Contact IBM's MTK support for advice
- Use another (commercial) migration tool (there are several outthere, just STFW...)
And a look into the above mentioned Redbook won't hurt at all.
BTW, all the information I give herein don't issue from my decades of Oracle to DB2 migration experience, they are quite simple to find, searching the web for the obvious keywords. Think about it...
Looking forward for an early insight... 8)
pashah72 on Jan 5, 2006 at 3:15:54 AM (# 8)Well, I surf the IBM site & to my best of my knowledge this toolkit supports db2 ver 8.0 & above, also MTK Support said the same thing but there R not saying which other toolkit for db2 ver 7.1 so I tried AdventNet SwisSQL Oracle to Db2 Edition 2.0, in final stage it says migration completed but status failure that is cannot transfer data from source(oracle ver 8i) because can't find table in target database but table already exists in target database (db2 ver 7.1).
May be I have to download other toolkit besides these two.
MHenke on Jan 5, 2006 at 4:40:55 AM (# 9)What detains you from updating to DB2 v7.2?
pashah72 on Jan 6, 2006 at 2:52:48 AM (# 10)Hello
while migrating I got this exception.
class com.ibm.db2.jcc.b.SqlException while getting the table names : DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200
What does it means?
MHenke on Jan 6, 2006 at 3:57:45 AM (# 11)
This message has been edited.
SQL0805N Package "<package-name>" was not found.
Explanation: Possible causes for this message (SQLCODE) are:
o The specified package or program is not defined in the
database.
o The program was not bound or it was dropped.
o The application being run is not bound to the database.
o If attempting to run a DB2 utility or CLI application, the
DB2 utilities may need to be rebound to the database.
The statement cannot be processed.
User Response: Specify the correct package name or bind the
program. If the application being run is not bound to the
database, contact the database administrator to do the necessary
binding.
If the DB2 utility programs need to be rebound to the database,
the database administrator can accomplish this by issuing one of
the following CLP command from the bnd subdirectory of the
instance, while connected to the database:
o "DB2 bind @db2ubind.lst blocking all grant public" for the
DB2 utilities.
o "DB2 bind @db2cli.lst blocking all grant public" for CLI.
Federated system users: ensure that the packages required for the
federated server are bound at the applicable data sources. Refer
to the Installation and Configuration Supplement Guide for more
information about binding packages to data sources.
sqlcode: -805
sqlstate: 51002
I'm still not a DB2 admin, but AFAICS from above (took me 1 minute to google it up) and some additional resources (took me 10 more minutes) I'd say that you've to (re-) bind a missing package to the DB.
The package is identified by NULLID.SYSSH200, which apparently refers to a bindfile db2clipk.bnd, included in a DB2 CLI package db2cli.lst (again 15 minutes to google).
How to bind a package to DB2 you ask? Am I to know? Nope, but nevertheless now I do, since there're people outthere how can tell you (e.g. at IBM).
Feel free to be inspired by http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0007866.htm (it's also mentioned in the quote above).
It's not the first time that I spend a disproportional ammount of time (trying to) solve your problems, which partially could be my fault because I won't stop if my ambition is awaked.
That won't be problem (after all I'm doing it on voluntary basis) if I would've the impression that you're able and willing to take all efforts that are possible and reasonable to take on your part in the process of problem solution. The crux is, I simply havn't that impression.
And that's not the foundation SiteExpert is working on (in the long term).
I'd seriously suggest to revise your part in that "game", nevertheless I hope the above informations will you help on...
| 
migration from oracle to db2?