Job running continously

[sourabhverma]

Hi All,

I am having one parallel multi instance job with the following job design :

Netezza DB Table (N1) -> Lookup -> Xfmr -> Netezza DB table (N3)

Netezza table (N2)

Here i am selecting data from one netezza table N1 & doing lookup on another netezza table N2. In the lookup if both the tables records match, the record from N1 will be propogating to further stages say Xfmr & N3 and when there is no match record from N1 will be dropped.

When i am executing this job it is getting completed for few invocations but the same job is running continously for other invocation ids.
When i try to stop the job, following message are coming in the log:

1. " main_program: ORCHESTRATE step execution terminating due to SIGINT "
2. Parallel job was aborted

Can any one guide me regarding this issue, Any help is appreciated .

[ray.wurlod]

SIGINT is you, issuing a stop command, which raises an interrupt signal.

[chulett]

'Running continuously' when a database is involved generally means locking issues. Has your DBA monitored these sessions for you?

[Kryt0n]

Are they generally long running jobs? In particular, can the query from the database take some time before it feeds data to DataStage? If so, and you have firewalls between DataStage and the DB, you may want to check in to your keepalive options

[sourabhverma]

Thanks for all of your replies,

Yes i have checked with my DBA , none of the table is getting locked. I want to let you know one more thing that this is not long running job, as the data is very less generally 10000-11000 records and sometimes even 1 or 2 records.

[sourabhverma]

One more info. i want to share, when i use ODBC stage instead of netezza stage as a lookup , then it runs fine.