Running the create schema script automatically

If the schema was not created as part of the model installation, you can use the WebSphere® Application Server administrative console to run the create schema script automatically.

Before you begin

Before you begin this task, you must log in to the WebSphere Application Server administrative console.

About this task

To run the create schema script, complete the following steps:

Note:

If during the installation of the model, the check box to run the schema script was selected, there is no need to run the script again.
Running the create schema script automatically from the WebSphere Application Server administrative console is not supported for z/OS®. For z/OS, the script must be exported and run manually.
If you are using Oracle as your database, export and run manually the database script to create or to delete the schema. These scripts include commands that create and drop tables and views and are not transactional with Oracle. If the scripts fail to complete successfully, the database administrator must perform any required cleanup because rollback is not supported. DB2® is fully transactional and use of the automatic running of the script is recommended.

Procedure

In the WebSphere Application Server administrative console, click Applications > Monitor Models.
Click the version of the model you want to manage.
Click Manage Schema
Click Run Create Schema Script.