Viewing logs outside of datastage director

[aartlett]

This is a simple tool I wrote a while ago to view a job log without director. As the remote access I have to use is dial up, going into director can be ... tiresome.

I call the file dslogs.ksh. Usage is
dslogs.ksh [jobname] [projectname] > [outputfile]

Redirection of output is not strictly necessary, just easier. This especially good when the jobs output a large log.

This is a UNIX app, should be fairly easy to rewrite as a dos cmd for windows users though.

Here's the code:

JOBNAME=$1
PROJECT=$2


integer startrec=`dsjob -logsum -type STARTED ${PROJECT} ${JOBNAME}|tail -4|grep STARTED|awk '{print $1}'|head -1`
integer endrec=`dsjob -logsum -type STARTED ${PROJECT} ${JOBNAME}|tail -4|grep STARTED|awk '{print $1}'|tail -1`

integer i=${startrec}

echo "logs for ${JOBNAME} of ${PROJECT} from record ${startrec} to ${endrec}"

while ((i <= ${endrec} ));
do
command="dsjob -logdetail ${PROJECT} ${JOBNAME} ${i}"
# echo ${command}
${command}
((i = i + 1 ))
done

[ray.wurlod]

Of course, if you have DataStage 7.5 or later, you can have Director on your PDA.

[aartlett]

Of course, if you have DataStage 7.5 or later, you can have Director on your PDA.

Still doesn't help if you have only dialup for remote access to your site. But PDA access could be fun:)