When certain Host Encyclopedia functions (generating, copying, deleting or uploading a model) are unsuccessful, “orphan” objects may be left in the Encyclopedia tables. An orphan object is one that references a model whose ID is not in the DMDL table.
You can use the CEUCLEN job to delete, or “clean” orphan objects from the Encyclopedia. Before executing CEUCLEN, you must set its parameters as shown in the following table:
|
CEUCLEN Parameter |
Required Setting |
|---|---|
|
MODELID |
Zero This setting must be zero. If you enter a valid MODELID, the model and all its contents are deleted. |
|
SUBSETID |
Zero |
|
MODLNAME |
Blank |
|
SUBSET |
All |
|
TONAME |
Blank |
|
SDFCPFLG |
Blank |
|
LOCKTBLS |
This parameter is not specified, and defaults to N. If you are an Encyclopedia administrator, you can specify the LOCKTBLS parameter and set it to Y to lock users out while the clean-up routine is running. This improves the routine's performance. |
|
MIGRFLAG |
Blank |
|
FDELFLAG |
N |
If you run CEUCLEN in batch mode with the parameters set as defined above, it deletes all rows in the DOBJ table belonging to an orphan object as well as any associated rows in the DASC, DPRP, DSUBID, DSUBDF, DSUBUS, DSUBEX, and DTXT tables.
If extensive Encyclopedia cleanup is required, CEUCLEN may run for a long time. Periodic COMMITS allow the job to be restarted. The job starts from the last COMMIT point.
You may find it useful to run the CEUCLEN job nightly, using a small time parameter (for example, 60 minutes). CEUCLEN performs frequent DB2 commits and checkpoints. If the job times out, the following day's run is restarted from the last checkpoint.
|
Copyright © 2013 CA.
All rights reserved.
|
|