Getting Started with IBM Tivoli Workload Scheduler V8.3

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