DSXchange

Hi us1aslam1us Thanks for the reply... I haven't used Routines on PX. The Parallel Routines when i tried to create one seems to be allwoing me to point to only external Rutines. Could you please tell me where exactly do i create this external routine and the thread says it need to be compiled do i ...

Hi, I have to get a workaround for one of my problem and I'm thinking of Invoking a Mainframe Program[Routine] that does some date calculation based on some Input criteria. How do I go about it? [1] How do I make use of the existing COBOL routine and invoke it from Mainframe ? [2] Create a Routine i...

I have two jobs. I am running the first job in four nodes and loading the intermediate results to dataset. Now i am using this dataset in my second job for loading the data to DB2. As per performance consideration, my team lead asked to run the job in 2 nodes, but the dataset which i am using has r...

[1] Did you export both the Job Design/Executable together or
[2] Did you export the Job Design first followed by Job Executable into the same .dsx and forgot to say 'append to the ....' option.
This would result in you losing the job design.
Just another thought

We are currently having difficulty in using the Stored Procedure Stage to properly insert into a DB2 Mainframe table. We have a decimal 15,2 field passing to Mainframe Stored Proc PIC S9(13)V9(2) USAGE COMP-3. All of the values get inserted except before the decimal place, this gets inserted as .00...

Sorry to post in this resolved topic, but I would appreciate if the Owner of the topic could post on how this was resolved. I'm encountering the same issue, because of which the logs are huge, and jobs runnning longer..!
Thanks,
Vijay

Yes, that is an easy solution. Within the loop perform any innocuous task that requires connection to DB2 - even a command the connects then quits. When the exit status is zero, it's time to progres ... Thanks Ray So I can have a dummy step to check DB2 connectivity before Job1, and if it's UP, I c...

Hi, I have this job sequence in which Job1 accesses DB2 database via Stored Procedure, followed by stream of jobs...Job2,3,4,5,6...[This job sequence is run for multiple instance at different point in time] I have this scenario in production, wherein the DB2 downtime is between midnight for about 30...

ray.wurlod wrote:[2] ...

[2] Too good..Thanks

Resolving this topic

Look in the Director manual or the on-line help while in Director. Choose Clear Log from Director's Job menu. Choose Immediate purge. ... Ray, Question on doing an Immediate Purge in the Director? [1] Does this only does a Purge from Director's Perspective, in not showing any previous logs for that...

I think you can use the message handler to not only demote a warning to information but to suppress the message altogether. As Ray says this is a high risk approach. Each warning message may be telling you of a row of data being dropped from your job or an insert statement that hasn't work. You wan...

Hi, We have an Issue in our Production, wherein it writes out millions of warnings [which we haven't figured it out, yet though], but to keep it going, Is there a way to turn OFF warning messages being written out of any job [@ project level] and get this going to get us some statistics. Sorry our a...

Friends,
Just wondering on how to get this one done.
When a job fails, is there a way to just capture the 'Fatal' log entry in the job log and send it out as an email ?

-Vijay

If you need to capture all the rejected rows, you need to run the job fully with out aborting it in between. Else "Else abort after n Row" should be the simple approach. ... Kumar, I don't need to capture all the rejected rows, but a sample of the rows for further investigation.., and hen...

Hi, We have a Transformer and a Peek/Dataset to write out the erroneous records from any Stages that can reject [Lookup,Transformer etc] and basically the reason we have the Transformer in the path is the ability of it to Abort after certain rows....!! Otherwise it's just an over-head. I'm trying to...