What is the name of the Job Logs file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

What is the name of the Job Logs file

Post by zulfi123786 »

I need to fetch entries from the Job Log where the Warnings matches a pattern for the latest run, can anyone share the name of the Job Log file (I tried using DS_JOBLOGS, it didnt work)

My plan is to fetch the records from the file using UV query with filter conditions on Event Number, Event Type and pattern matching on Event columns of the file

what would be the UV query to describe the UV tables for their columns.

Any help would be greatly appreciated.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Each job has its own log, which is a table in the Repository. The job has a unique number assigned when the job is created, and the name of the table that contains the job log is RT_LOGnnn where nnn is that job number.

Job names are mapped to job numbers in the DS_JOBS table.

Note that job logs are NOT files - they are database tables. To get a list of the column names, the command is:

Code: Select all

LIST.DICT RT_LOGnnn
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply