IBM Tivoli Netcool/OMNIbus, Version 7.4

Creating, altering, and dropping ObjectServer objects

The ObjectServer stores, manages, and processes event data collected by external applications such as probes and gateways. The default storage structures (or objects) are created according to SQL definition files.

You can use Data Definition Language (DDL) commands to create, alter, and drop ObjectServer objects. The following table lists each object and the DDL commands that can be used.

Table 1. ObjectServer objects and associated DDL commands
ObjectServer object Allowed DDL commands
DATABASE CREATE DATABASE

DROP DATABASE
TABLE CREATE TABLE

ALTER TABLE

DROP TABLE
INDEX CREATE INDEX

DROP INDEX
VIEW CREATE VIEW

DROP VIEW
RESTRICTION FILTER CREATE RESTRICTION FILTER

DROP RESTRICTION FILTER
FILE CREATE FILE

ALTER FILE

DROP FILE
Parent topic: ObjectServer SQL