|
Home > Archive > WebSphere Portal Server > February 2004 > Cloudscape to DB2 migration problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cloudscape to DB2 migration problem
|
|
| Stephen Suen 2004-01-19, 3:00 pm |
| Hi all,
I installed Portal 5.0 (Quick Install) with the default options. I am trying
to migrate from Cloudscape to DB2 v7.1 with fixpack 8. I was able to export
the data from Cloudscape, and got a success report from the acions, altought
with some messages said some tables of WPCP sample did not exsist. Then I
created the databases for DB2 successfully using WPSconfig after made
necessary modifications to the wpconfig.properties. When I was trying to do
an import to DB2, I failed with error messages said could not find file
wpsdb2insert.sql. I checked the directory mentioned in the message, had not
any .sql!
Does anyone has ideas about my problem?
Here's the summary of my environment:
Windows 2000 Server Simplified Chinese
WPS 5.0.1
DB2 7.1 with fixpack 8
Thanks
Stephen Suen
| |
| vchavez4 2004-02-18, 1:33 pm |
| Hello,
Did you ever find a solution to your problem? I'm experiencing the same issue.
Thanks
> Hi,
>
> I installed Portal 5.0 with the default options. I am
> trying to migrate from Cloudscape to DB2. I installed
> DB2 Enterprise Server edition v8.1 and the
> Fixpack(FP1). I have created the remote databases.
> And I Configured portal machine to connect remote db2
> server. I am able to connect DB2 remote database
> using the command
>
> DB2 connect to wps50 user db2admin using db2admin
>
> when I am trying to export the data from Cloudscape
> using the configuration task
> "database-transfer-export". I am getting following
> error
>
> action-gather-utilities-wps:
> [java] prefix is: cswps.
> [java] Level.SEVERE, Error loading JDBC Driver :
> er : COM.ibm.db2.jdbc.app.DB2Driver
> [java] Level.SEVERE, Error Connecting db
> [java] java.sql.SQLException: No suitable
> able driver
>
> System classpath is set to db2java.zip file.
> . Please help me out from this issue.
>
> Thanks in advance
> viswanath.b
>
|
|
|
|
|