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
objects.
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.
Chapter 5. DB2, WebSphere, and Lightweight Directory Access Protocol: Considerations 345
Example 5-5 Renaming database objects using composer rename
-display sched=example1
Workstation Job Stream Name Valid From Updated On Locked By
---------------- ---------------- ---------- ---------- ----------------
MASTER EXAMPLE1 - 04/10/2006 -
SCHEDULE MASTER#EXAMPLE1
ON REQUEST
CARRYFORWARD
:
MASTER#JOB1
MASTER#JOB2
FOLLOWS JOB1
END
AWSBIA291I Total objects: 1
-
-rename jd=job1 dataload
AWSJCL003I The command “rename” relating to object “jd=MASTER#JOB1” has completed
successfully.
AWSBIA288I Total objects updated: 1
-
-rename jd=job1 datarept
AWSJCL003I The command “rename” relating to object “jd=MASTER#JOB2” has completed
successfully.
AWSBIA288I Total objects updated: 1
-
-display sched=example1
Workstation Job Stream Name Valid From Updated On Locked By
---------------- ---------------- ---------- ---------- ----------------
MASTER EXAMPLE1 - 04/10/2006 -
SCHEDULE MASTER#EXAMPLE1
ON REQUEST

Get Getting Started with IBM Tivoli Workload Scheduler V8.3 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.