As of now, I am interested in Job Start time, End time and Job status.
Please elaborate how I can access DSODB database to get this information. If possible, in detail please.
Search found 20 matches
- Wed Nov 08, 2017 12:01 am
- Forum: General
- Topic: Datastage Job logs for Today's/Yesterday's run
- Replies: 5
- Views: 3791
- Mon Nov 06, 2017 11:59 pm
- Forum: General
- Topic: Datastage Job logs for Today's/Yesterday's run
- Replies: 5
- Views: 3791
But Datastage Director client will also give the jobs which didn't ran today. Basically I want to create a report in customized format and automate this process. We can do this using dsjob command with -linvocations but this gives all invocation ids irrespective of date. I am just interested for a p...
- Mon Nov 06, 2017 6:23 am
- Forum: General
- Topic: Datastage Job logs for Today's/Yesterday's run
- Replies: 5
- Views: 3791
Datastage Job logs for Today's/Yesterday's run
How I can get logs (Status alone will also work) for datastage jobs ran today/yesterday. Please note that jobs are running with invocation Id (Multiple instance jobs).
- Thu Mar 23, 2017 5:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to reject records having Extra Fields in Seq file stage
- Replies: 6
- Views: 6806
- Wed Mar 22, 2017 6:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to reject records having Extra Fields in Seq file stage
- Replies: 6
- Views: 6806
How to reject records having Extra Fields in Seq file stage
Hi, I am reading a Sample.txt file using Sequential File Stage. Below are the details for .txt file and metadata for Sequential File Stage- 1) 3 Fields are defined in Sequential file stage Schema. 2) Sample.txt is having below set of records- Field1|Field2|Field3 1|2|3 11|22 111|222|333|444 Output o...
- Fri Jan 06, 2017 1:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: User Defined SQL in Netezza Connector, Datastage 11.5
- Replies: 1
- Views: 2721
User Defined SQL in Netezza Connector, Datastage 11.5
Hi, How I can write User defined Update/Insert query in Netezza connector. I have a update query similar to the one mentioned below : Update Table1 Set Col1=Orchestrate.DatastageCol1,Col2=Orchestrate.DatastageCol2 DatastageCol1 is the Column coming from input link to Netezza connector. DatastageCol2...
- Wed Jan 04, 2017 11:25 pm
- Forum: General
- Topic: dsjob Command with "-wait" option
- Replies: 6
- Views: 4554
I would guess your script has a typo. Can you post the whole script? So,the guess is correct...Below is the script I was using- DSCMD=/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob If [[<expression>]]; then `$DSCMD -run -wait -param <Parameters> <ProjectName> <Jobname>` fi I just removed &quo...
- Wed Jan 04, 2017 1:32 am
- Forum: General
- Topic: dsjob Command with "-wait" option
- Replies: 6
- Views: 4554
- Tue Jan 03, 2017 11:29 pm
- Forum: General
- Topic: dsjob Command with "-wait" option
- Replies: 6
- Views: 4554
dsjob Command with "-wait" option
I am calling dsjob command with"-wait" option from a shell script but it seems, the dsjob command just triggers the job and does not wait for the Job to finish. Below is the Syntax I am using within the shell - DSCMD=/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob $DSCMD -run -wait -p...
- Mon Dec 26, 2016 1:29 am
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542
- Fri Dec 23, 2016 6:43 am
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542
Just to clear my understanding, If LOCKED clause is not mentioned , any other invocation will wait until the file lock is released. Please confirm. What if the LOCKED clause is mentioned? How other invocation will behave? Is there any chance of abort for other job invocation due to same files access...
- Fri Dec 23, 2016 12:04 am
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542
So, the code works in a simpler way. I just did a small change and here it is.... Changed line : SEEK FileVar, 0 ,2 Since, I am writing into same file using different jobs at the same time, Is there any possibility that file might get locked. I have tested this scenario but did not get this issue. J...
- Thu Dec 22, 2016 7:33 am
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542
Thanks Guys for the sharing the different approach to debug this. I have the working code now. Now adding few more question as I have added few more requirements :) 1) I am going to use this routine in multiple jobs, hence want to append the count instead of overwriting the file. Using SEEK command ...
- Fri Dec 16, 2016 11:54 pm
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542
- Fri Dec 16, 2016 12:50 pm
- Forum: General
- Topic: Server Routine
- Replies: 18
- Views: 8542