WebSphere Commerce suite - changing type to db2

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Commerce suite > April 2006 > changing type to db2





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 changing type to db2

2005-05-11, 5:57 pm

I want to tracsfer my store from cloudspace to db2. When i run command
setdbtype DB2 D:\PROGRA~1\IBM\SQLLIB mall56 db2admin cyber2003 administrator cyber2003
it shows an error
"The WebSphere Application Server 5.02 Integrated Test Environment in your WebSph
ere Studio Application Developer installation is not available or does not have
the required fix pack installed. Consult the installation guide for details."
I reinstall wcs with 5.0.2 App Server and run again. It showed same error.
Then I run comand
createdb.db2 mall56 db2admin cyber2003 db2admin
there are no error is log file. After that when i run Test Server in WCS. It is giving following error.

com.ibm.ejs.cm.portability.TableDoesNotExistException: [IBM][CLI Driver][DB2/NT] SQL0204N "ADMINISTRATOR.LANGPAIR" is an undefined name. SQLSTATE=42704
db2 level is as follow

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012" with
level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and FixPak
"2".

D. Portier

2006-04-27, 8:08 am

Hello,

The script does seem to check the version file of the websphere runtime.
For me it is located at:

C:\Program Files\IBM\WebSphere Studio\Application
Developer\v5.1. 2\runtimes\base_v5\properties\version\Ba
se.product

If you manually edit the version to '5.0.2.3' the script will be executed
properly, Afterwards you can
revert the version to wathever it was...

D. Portier


<azizkhan78@yahoo.com> wrote in message
news:1713505622.1115818335918.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
>I want to tracsfer my store from cloudspace to db2. When i run command
> setdbtype DB2 D:\PROGRA~1\IBM\SQLLIB mall56 db2admin cyber2003
> administrator cyber2003
> it shows an error
> "The WebSphere Application Server 5.02 Integrated Test Environment in your
> WebSph
> ere Studio Application Developer installation is not available or does not
> have
> the required fix pack installed. Consult the installation guide for
> details."
> I reinstall wcs with 5.0.2 App Server and run again. It showed same error.
> Then I run comand
> createdb.db2 mall56 db2admin cyber2003 db2admin
> there are no error is log file. After that when i run Test Server in WCS.
> It is giving following error.
>
> com.ibm.ejs.cm.portability.TableDoesNotExistException: [IBM][CLI
> Driver][DB2/NT] SQL0204N "ADMINISTRATOR.LANGPAIR" is an undefined name.
> SQLSTATE=42704
> DB2 level is as follow
>
> DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
> with
> level identifier "02030106".
> Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
> FixPak
> "2".
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com