Exporting the create schema script

You can use the WebSphere® Application Server administrative console to export the create schema script to a data definition language (DDL) file to be run at a later time or to be run remotely.

Before you begin

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

About this task

You can set database properties for DB2 z/OS so that the exported database scripts automatically substitute the z/OS database variables for database name and storage group. See the "Monitor database considerations for DB2 for z/OS" related topic.

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

Procedure

  1. In the WebSphere Application Server administrative console, click Applications > Monitor Models.
  2. Click the version of the model from which you want to export the create schema.
  3. Click Manage Schema.
  4. Click Export Create Schema Script.
  5. Save the file.

Results

A script is produced that you can run later manually using a command prompt or from a remote location.