List of uv tables

SandhyaShetty21 · Post by **SandhyaShetty21** » Tue Oct 01, 2013 5:12 am

Hi Team,

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

eg. DSJOB, DS_ROUTINES, DS_METADATA

ArndW · Post by **ArndW** » Tue Oct 01, 2013 5:53 am

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.

priyadarshikunal · Post by **priyadarshikunal** » Tue Oct 01, 2013 7:48 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Oct 01, 2013 4:25 pm

May we know why you think you need this list?

SandhyaShetty21 · Post by **SandhyaShetty21** » Wed Oct 02, 2013 4:40 am

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?

ArndW · Post by **ArndW** » Wed Oct 02, 2013 5:11 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 02, 2013 6:05 am

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.

chulett · Post by **chulett** » Wed Oct 02, 2013 7:36 am

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.