You can use the WebSphere® Application
Server administrative
console to export the delete schema script to a DDL file, which can
be run at a later time or remotely.
Before you begin
Before you begin this task, you must log on to the
WebSphere Application
Server administrative
console.
About this task
Note: For secure databases with multiple models deployed,
when you remove a monitor model version and delete the schema, a database
view is dropped and then recreated. To grant the MONITOR database
user access to the new view, refer to "Securing the monitor model
database delete schema." A related link is provided.
To
export the delete schema script, complete the following.
Procedure
- In the WebSphere Application
Server administrative
console, click .
- Click the version of the model.
- Click Manage Schema.
- Click Export Delete Schema Script.
- Save the file.
Results
A script is produced that you can run later manually using
a command prompt or from a remote location.
What to do next
For secure databases with multiple models deployed, follow
the instructions for "Securing the monitor model database delete schema"
to implement a higher level of security.