Change and install a new EJB dbschema database name

This process must be performed if all of the following apply to the applications that you plan to migrate:

• You have container managed persistence (CMP) entity beans in your application.
• The deployed code for these enterprise beans was generated specifying a blank database schema.
• You are migrating the applications to WAS Version 5.0 or Version 5.0.1. This does not affect application migrated to Version 5.0.2 and later releases.

If your application does not meet all of these requirements, then you do not have to change and install a new EJB dbschema database name.

1. Generate a new enterprise application with your database name

   During migration the dbschema name is hard-coded to EJB. To change the dbschema name, map a network drive from your workstation to the iSeries where the WebSphere installation resides. Use the Application Assembly Tool to perform these steps:

   1. Click File --> Open.
   2. Locate the QIBM/UserData/WebAS5/Base/instance/installableApps/ directory on your mapped iSeries drive. Open your newly generated ear file.
   3. Click File --> Generate code for deployment....
   4. Specify these properties:
      • Deployed module location: Note the module location for future reference.
      • Database name: Specify the name of the datasource database.
      • Database type: Clear the name of the datasource database.

   5. Click Generate Now.
   6. Click Close.
   7. Click File --> Exit.

2. Remove the enterprise application with database name EJB, and install your newly deployed enterprise application

   Use the WAS Version 5 administrative console to delete the existing enterprise application and install the newly deployed enterprise application from the EAR file. For more information on how to install and uninstall applications, see Install and uninstall applications in the Administration topic.

   1. In the administrative console, expand Applications, and click Enterprise Applications.
   2. Select migrated enterprise application and click Stop.
   3. Select migrated enterprise application and click Uninstall.

   4. Save the configuration.

3. Install your newly generated enterprise application:

   1. In the administrative console, expand Install New Appplication.

   2. Click Browse.
   3. Specify the deployed module location from the first step.
   4. Navigate to /QIBM/UserData/WebAS5/Base/instance/installableApps/Deployed_yourApplication.ear on the mapped network drive. Select the EAR file and click Open.
   5. Click Next.
   6. On the Prepare for the application installation panel, click Next.
   7. On the Install New Application panel, click Step 10. Steps 1 through 10 may be adusted, to customize the application to your environment.
   8. Click Finish.

   9. Save the configuration.

4. Start the enterprise application

   1. Click Enterprise Applications.
   2. Select your enterprise application and click Start.