344 Getting Started with IBM Tivoli Workload Scheduler V8.3
5.7 Referential integrity
The Tivoli Workload Schedule V8.3 database includes foreign key constraints to
ensure that the referential integrity is maintained for each association between
This means that when deleting an object referenced by other objects, there are
only three possible options:
Deletes the object and any objects that have a reference to that object
Returns an error indicating that the object is referenced by other objects and
cannot be deleted
Deletes the object and removes all references to it from other objects
Typically, Tivoli Workload Scheduler V8.3 does not delete objects if they are
referenced by other objects, but exceptions to this general rule exist. These are
listed in Table 5-1 along with the alternative action taken.
Table 5-1 Rules applied when deleting an object referenced by another object
New filters have been added to the JSC and CLI queries to search for objects
that reference a specified target object.
Objects in the database can be renamed without losing any references from
other objects, including dependencies. A rename command has been added to
composer and is used to assign a new name to an object already existing in the
database. Example 5-5 shows the job stream EXAMPLE1, which includes two
jobs, JOB1 and JOB2. We rename the two jobs to provide them more descriptive
names. We display the job stream again to show that it now includes references
to the new job names DATALOAD and DATAREPT.
Note: A foreign key reference is an entry in one table that links to another
table. The field or fields that the foreign key links to must be unique and is
generally the primary key of the other table.
Object References Action to take when deleting the referenced object
Internetwork Dependency Workstation Remove the dependency from the job or job stream.
External Dependency Job stream Remove the dependency from the job or job stream.
External Dependency Job Remove the dependency from the job or job stream.
Internal Dependency Job Remove the dependency from the job or job stream.
Workstation Class Workstation Remove the workstation from the workstation class.