DSXchange

Hi Team,

How can I find out the list of tables in uv.

eg. DSJOB, DS_ROUTINES, DS_METADATA

The command in TCL is "LISTF" or "LISTFL" (list files or list local files), which is the same same "LIST VOC WITH F1 LIKE F...". Since every job creates a couple of files, this list is rather long.

Or you can select from the VOC.. where TYPE like F and NAME not like RT_%

May we know why you think you need this list?

Thanks All for the responses.

I am looking for a table which would give me monitor information about the previous runs of a job.

I can see the job monitor for the latest run. But I wanted to compare the latest set of monitor records with the previous runs.

Is there any way I can achieve this?

While the xmeta database has that information (somewhere in its undocumented depths), you will not find a UV table/hashed file with just that information. The data you see in the monitor is computed from the entries in each job's logging information - you would need to read the job's log (not difficult), then parse the various bits of data from the log and elsewhere to re-create the monitor information.

In version 7.x the only table that contains information about previous runs - unless you preserve it in your own tables - is the log for the job, RT_LOGnnn where nnn is the job number.

SandhyaShetty21 wrote:I am looking for a table which would give me monitor information about the previous runs of a job.

Always best to lead with your actual problem / question.