InfoCenter Home >
3: Migration overview >
3.5: Switching administrative databases >
3.5.2: Settings to change when switching administrative databases
3.5.2: Settings to change when switching administrative databases
The following steps describe the settings modified by the
database conversion assistant. It is highly recommended
that you use the database conversion assistant to switch database settings, rather than
editing the settings by hand.
Note, the following example steps pertain specifically to switching from an
Instant DB database to a DB2 database. Again, they are provided as a reference to
what the assistant is doing. Use the assistant to modify the settings.
Modify the administrative server configuration file ,
changing entries as follows:
From:
com.ibm.ejs.sm.adminServer.dbDriver=jdbc.idbDriver
To:
com.ibm.ejs.sm.adminServer.dbDriver=COM.ibm.db2.jdbc.app.DB2Driver
From:
com.ibm.ejs.sm.adminServer.dbUser=
To:
com.ibm.ejs.sm.adminServer.dbUser=db2admin
where db2admin is the appropriate database user name.
From:
com.ibm.ejs.sm.adminServer.dbPassword=
To:
com.ibm.ejs.sm.adminServer.dbPassword=db2admin
where db2admin is the appropriate database password.
From:
com.ibm.ejs.sm.adminServer.dbUrl=jdbc:idb:c:/WebSphere/AppServer/bin/was.prp
To:
com.ibm.ejs.sm.adminServer.dbUrl=jdbc:db2:was
Modify the entry that points to the database driver:
com.ibm.ejs.sm.adminserver.classpath
For example, change from:
c:/WebSphere/AppServer/lib/idb.jar
To:
c:/SQLLIB/java12/db2java.zip
Modify product_installation_root /bin/setupCmdLine
(setupCmdLine.sh on UNIX):
Modify the administrative server startup script :
Modify product_installation_root /properties/initial_setup.config:
Change from:
<config-file>product_installation_root /hosts/default_host/WSsamplesIDB_app/WSsamplesIDB_app_create.xml</config-file>
To:
<config-file>product_installation_root /hosts/default_host/WSsamples_app/WSsamples_app_create.xml</config-file>
Change from:
<value>jdbc:ibd</value>
To:
<value>jdbc:db2</value>
Change from:
<value>product_installation_root /lib/idb.jar</value>
To:
<value>home/db2inst1/sqllib/java/db2java.zip</value>
<value>product_installation_root /bin/myidb.prp</value>
To:
<value>WAS </value>
where WAS is the name of the DB2 database.