Search found 90 matches

by theverma
Thu Jan 17, 2008 1:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get tne name of Aborted Job in a Sequence
Replies: 5
Views: 2880

Please note that i am using Windows Server Edition.

Can we get the name without modifying the Job?
I know to get solution we have to do changes but it would be really great if we can find out the solution without making any change to the Job.

Thanks
by theverma
Thu Jan 17, 2008 11:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get tne name of Aborted Job in a Sequence
Replies: 5
Views: 2880

How to get tne name of Aborted Job in a Sequence

Dear all, I have a Job Sequence which has two Jobs. I am invoking this Job Sequence using Command Line. I case of failure of this Job Sequence,I want the name of the Job which has made the sequence in aborted state.Means the Name of the Job which gets abort. I am using command line for all operation...
by theverma
Fri Nov 09, 2007 5:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run and Reset if Required
Replies: 13
Views: 16701

Hello Friends, I am closing this post as I have got the solution to my problem. Thanks a lot for all your support. And also one learning i want to share. If we want to use multiple parameters in dsjob comand we have to use it like this : dsjob -run -param P1=V1 -param P2=V2 -wait -Jobstatus Project_...
by theverma
Fri Nov 09, 2007 4:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run and Reset if Required
Replies: 13
Views: 16701

Hi Friends,

One more observation to add on is that when we execute dsjob command without parameter from TWS,it works fine.

Thanks and Regards,
Arun
by theverma
Thu Nov 08, 2007 11:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run and Reset if Required
Replies: 13
Views: 16701

Thank you Friends, I got your idea regarding RESET ing a job and then run. But I am still facing problems while running dsjob with parameters. I am running this command : D:\Ascential\DataStage\Engine\bin\dsjob -run -param ApplicationCode= Invocation ID -wait -jobstatus PPInterface Create_Files. Inv...
by theverma
Thu Nov 08, 2007 5:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run and Reset if Required
Replies: 13
Views: 16701

Run and Reset if Required

Hi everybody, I am using dsjob command to run Datastage Jobs. Online Manual doesnot refer anything regarding the parameter which should be used for running the job with 'Run and Reset if required' Option using dsjob. We have a '-mode' option but this has only three options : NORMAL,RESET,VALIDATE Bu...
by theverma
Thu May 10, 2007 9:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine for Job Sequence
Replies: 12
Views: 5192

I am Executing an OS command for TIVOLI to send the message. I am using an AterJob Subroutine,which gets the status of the current job from the Job Report and then executing an OS Command with the required parameters to send the Message. I am facing problem because we donot have After-Job Subroutine...
by theverma
Wed May 09, 2007 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine for Job Sequence
Replies: 12
Views: 5192

No..I wouldn't help...!!
by theverma
Wed May 09, 2007 8:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine for Job Sequence
Replies: 12
Views: 5192

I am using Director to Schedule my Job Sequence.I am not using any OS command to trigger the sequence. Inside Job Sequence we have 3 Jobs(Job1,Job2,Job3) In each Job i am using a After Job Subroutine.In that routine i am generating Job Report and then fetching out the Job Status of the current Job a...
by theverma
Wed May 09, 2007 8:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine for Job Sequence
Replies: 12
Views: 5192

'Send the Finished status' means that I want ot capture the Status of the Job Sequence once it geys completed.It can be Finished OK,Finished with warnings or Aborted.
I want the Job Status of the Job Sequence.

Hoping that I am Clear to you now
Thanks
by theverma
Wed May 09, 2007 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine for Job Sequence
Replies: 12
Views: 5192

After Job Routine for Job Sequence

Hello Friends, My Requirement is to send a Status message from a Job Sequence to TIVOLI(IBM Monitoring Tool).Right now i am sending the Finished Status message of the jobs(in the Job Sequence) by executing an OS command in an After-Job Subroutine. Please suggest how I can send the Finished status of...
by theverma
Tue May 08, 2007 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File Creation.
Replies: 4
Views: 2041

Hashed File Creation.

Hello Friends, I have two doubts regarding the creation of Hashed files : (1) Can we create Hashed Files on a Network drive and then access them from the Network drive only? (2) Which one option is better whether to use Clear File or to use Delete File before creation,while creating a Hashed File? I...
by theverma
Fri May 04, 2007 9:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verb not present in VOC
Replies: 3
Views: 1957

Problem resolved :P

Thanks a lot!!!
by theverma
Fri May 04, 2007 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verb not present in VOC
Replies: 3
Views: 1957

Verb not present in VOC

Hello Friends, I am trying to run a Job from Command Line Interface in Administrator. I am running following command : dsjob -run PPInterface GetEPMControlFile And getting the following Error Message : Verb "DSJOB" is not in your VOC I serached the forum and find many post on VOC but still...
by theverma
Fri Apr 20, 2007 7:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File created with encoding other than specified in NLS.
Replies: 5
Views: 9174

we can set NLS option at stage level also.In Sequential file stage properties,we can set it. I have set it as UTF-8 in my Input Sequential file stage and output Sequential file stage.Input file doesnot contain uncode characters means all the characters would contain 1 byte .There is no character whi...