DSXchange

nekkalapudi wrote:Trying to create a paralles routine to call DSSetUserStatus function.
What header file need to use in .c file

used dsapi.h file, but it is not finding dsapi.h file.
How to include dsapi libraries, what command should I use

Trying to create a paralles routine to call DSSetUserStatus function.
What header file need to use in .c file

kris007 wrote:What is the warning message and what are you trying to do with those two stages? A small description would help.

I was using two key columns.
The message [ITEM=34,LOCATION=02] not in before...
Actually there is about 100000 log entries, which couldn't view. It's hanging.

Thanks,

Hi,

I am using change data capture and change data apply stages.
Change data apply stage is writing warning log for each new record.
Is there a way to prevent this..?

Any help is greatly appreciated.

Thanks,

That explains things. Since you have used a failure trigger, the Job sequence reads it as you are handling the failure activities. So, as per the Job sequence, when the job aborts it sends an email and its job is done and hence the successful message. If you want the sequence to abort when a job fa...

That explains things. Since you have used a failure trigger, the Job sequence reads it as you are handling the failure activities. So, as per the Job sequence, when the job aborts it sends an email and its job is done and hence the successful message. If you want the sequence to abort when a job fa...

Hi, Check the Mail properties like SMTP mail server and From & To mail addresses (some mailserver could not mail thru internet like to your yahoo id). And verify the triggers, you can use triggers for each link or you can use the custom trigger. If you use custom - check how many conditions you...

thumsup9 wrote:You seem to have used Expression Type as Custom - Conditional. Can you please post the Expression you used.

Custom trigger expression: -
Process_BILLOMAT.$JobStatus = 2 or Process_BILLOMAT.$JobStatus = 1

Thanks,

Hi, The Sequencer shows you that it is finished successfully even after a job abort because the sequencer is able to send the email notification.You have triggers for the job activity stage: one for success of the job as to go to next job and second if the job aborted then send a email notification...

Can you please post the sequence flow. I didn't get exactly what you are asking. Any way I have three jobs, in the job sequence added three job activity stages and added mail notifications to each job activity sends mail if the job aborts. As I stated earlier for trigger used custom conditional, va...

Krazykoolrohit wrote:Or you would have set the trigger in job property inside sequencer as "unconditional"

Tirgger used custom conditional. Checking job status.

Go to the job properties of the sequence job and check out the job properties. You must have checked the "Automatically handle jobs that fail". Thats why the job is finishing rather than aborting. I checked Add Checkpoint so sequence is restartable on failure and Log Warnings after activi...

Hi, Created a sequence to run couple of jobs. While running one of the job aborted, but Seq_BILLOMAT..JobControl (@Coordinator): Summary of sequence run 15:43:26: Sequence started (checkpointing on) 15:43:26: Setup_BILLOMAT (JOB Setup_BILLOMAT_Source_Extract) started 15:43:50: Setup_BILLOMAT (JOB Se...

Nothing is wrong, PX is probably behaving as documented. You should look into the PX Developer's Guide pages 12-16 ff. This has to do with PX running in Parallel or Sequential mode, your partitioning method(s) and your SQL statement. Hi ArndW, The doc is explaining about DB2 Enterprise stage. In th...

Hi,

I am using db2 api stage to extract data from db2 database using custom SQL. Just fetching all from the table.
Using 2 node configuration. Database has 89000 records, but the data set has double the records.

Does any one has any idea what is the wrong?

Thanks