How to get latest log info of a job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Jayesh_09
Participant
Posts: 21
Joined: Wed Apr 07, 2004 10:09 am
Contact:

How to get latest log info of a job

Post by Jayesh_09 »

Guys
Can any one help me.
I want to get latest logs for a job.Any routine.
Please help

Regards
Jay
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
You can see if the dsjob command line is enough for you.
If not look in the basic.pdf in your client installation directory under docs for the basic routines for working thru the logs.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi Jayesh,

Before you post a topic do a search with topic keywords. If you dont get results then post the topic.

Check if this link helps
viewtopic.php?t=88792

These are the functions that Roy is talking about

DSFindFirstLogEntry
DSFindNext LogEntry
DSGetLogEntry
DSGetNewestLogId

These function can be used in a routine to get the log information.

HTH
--Rich

Pride comes before a fall
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard! :D

In the Director client, log view (the "open book" tool), log entries are - by default - sorted in date/time order, so that the most recent are at the end. You can change the sorting order by double-clicking the the grid header.

At the right hand side is a hidden column (that you can expand) called Date Sorter. This is the numeric event number by which the log table is keyed. It's this, rather than timestamp, that is used to sort log entries for display (because sorting integers is quicker than sorting timestamps).

If you definitely want to use a routine, then the functions posted earlier are the ones to use. You did not, however, specify whether this was to be a DataStage routine or an external routine, nor what the expected result is. The term "latest logs" is meaningless; each job has exactly one log, which is a database table in the DataStage repository. It's not a case of multiple O/S files, which is what you may have been thinking.
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