|
Home > Archive > WebSphere Portal Server > August 2007 > Cloudscape to DB2 migration issue
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 issue
|
|
|
| Hi. I've installed Portal 6.0. On another computer I've installed Tivoli Directory Server 6.0,
it's also have been installed DB2 8.2. So I donn't know is there any fixpacks.
On computer with Portal I've installed
And I'm trying to use wizard for migration from Cloudscape to DB2.
I'm following instructions from Infocenter:
http://publib.boulder.ibm.com/infoc...f/setup_db2.htm
with some exceptions:
1.Instead
db2 "CREATE DB dbname using codeset UTF-8 territory us COLLATE USING UCA400_NO PAGESIZE 8192"
I'm typing
db2 "CREATE DB dbname using codeset UTF-8 territory us COLLATE USING UCA400_NO "
2.My databaes named: COMTY, CUSTOMIZ, FDBKDB, JCRDB, LMDB, RELEASE, WMM.
In wizard I'm filling fields this way:
DbName: comty
DbSchema: db2admin
DataSourceName: wpsdbDS
DbUser: db2admin
DbPassword: *****
DbUrl: jdbc:db2:wpsdb
For all other databases I've just changed DbName, and for some of them DataSourceName.
I'm running wizard and on 18 % occurs an error.
Operation finished with errors.
Log file is in attach.
What I'm doing wrong? Can anybody help me solve this problem.
| |
|
| Can u try by giving unique schema name and also make sure that you modifed the db2cli.ini file on DB2 with the value accoording the version .
| |
|
| can you provide the error message like the pop up what it is comming instead of some percentage the we can solve the error
| |
|
| > Hi. I've installed Portal 6.0. On another computer
> I've installed Tivoli Directory Server 6.0,
>
> it's also have been installed DB2 8.2. So I donn't
> know is there any fixpacks.
> On computer with Portal I've installed
> And I'm trying to use wizard for migration from
> Cloudscape to DB2.
> I'm following instructions from Infocenter:
> http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/to
> pic/com.ibm.wp.ent.doc/wpf/setup_db2.htm
> with some exceptions:
> 1.Instead
> DB2 "CREATE DB dbname using codeset UTF-8 territory
> y us COLLATE USING UCA400_NO PAGESIZE 8192"
> I'm typing
> DB2 "CREATE DB dbname using codeset UTF-8 territory
> y us COLLATE USING UCA400_NO "
> 2.My databaes named: COMTY, CUSTOMIZ, FDBKDB, JCRDB,
> LMDB, RELEASE, WMM.
>
> In wizard I'm filling fields this way:
> DbName: comty
> DbSchema: db2admin
> DataSourceName: wpsdbDS
> DbUser: db2admin
> DbPassword: *****
> DbUrl: jdbc:db2:wpsdb
>
> For all other databases I've just changed DbName, and
> for some of them DataSourceName.
>
> I'm running wizard and on 18 % occurs an error.
> Operation finished with errors.
> Log file is in attach.
>
> What I'm doing wrong? Can anybody help me solve this
> problem.
You need to change the DbUrl to reflect your database. For example, if you are using the DB2 CLI and not the Universal driver:
DbUrl: jdbc:db2:comty
|
|
|
|
|