If the schema was not created during installation of a
monitor model, you can use the WebSphere® Application
Server administrative
console to run the create schema script locally or export the create
schema script to a DDL file to be run at a later time or to be run
remotely.
For secure databases, you must export the create schema script.
See the related topic
"Securing the monitor model database create
schema" for more information.
Note: 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 these scripts is
recommended.
Note: If you are using DB2 for z/OS® as your database,
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.