Jobs do not appear in DS Manager, Designer or Director

[ewartpm]

The problem we are experiencing is that every now and then the jobs disappear from the client tools.

I can still export them, but they are not visible in DS Manager, Designer or Director.

One of the ways to fix this is to do a Rebuild Repository Indices using DS.TOOLS or to recreate the project.

Can someone please explaining why this is happening?

[ray.wurlod]

Repository indexes can become corrupted (out of date) if any updating process is abnormally terminated.

It is possible to verify whether the indexes need rebuilding without actually doing it, using the LIST.INDEX command. It would be useful to have this on the DS.TOOLS menu.

Code: Select all

LIST.INDEX DS_DATATYPES ALL
LIST.INDEX DS_JOBS ALL
LIST.INDEX DS_JOBOBJECTS ALL
LIST.INDEX DS_CONTAINERS ALL
LIST.INDEX DS_ROUTINES ALL
LIST.INDEX DS_STAGETYPES ALL
LIST.INDEX DS_METADATA ALL
LIST.INDEX DS_TRANSFORMS ALL

If you have DS/390 the following additional commands.

Code: Select all

LIST.INDEX DS_JCLTEMPLATES ALL
LIST.INDEX DS_IMSDATABASES ALL
LIST.INDEX DS_IMSVIEWSETS ALL
LIST.INDEX DS_IMSDBOBJECTS ALL
LIST.INDEX DS_IMSVSOBJECTS ALL
LIST.INDEX DS_DSMFPROFILES ALL

The report in each case is the same as the one produced within the command to re-index. It shows, among other things, whether each index needs to be rebuilt.

The DS.REINDEX command (or the option from DS.TOOLS) drops each index and rebuilds each index afresh, whether it needs it or not. This is the safest approach, but requires exclusive access.

[ewartpm]

Thanks Ray, much appreciated.