Hi All,
We are using basic transformer in our parallel job to call a server routine.
Our job flow is like this
Sequential file --->BasicTransformer----API db2 stage
The sequential file is having one reject link.
In Basic transformer the null check and special character check is done. The special character check in the last column is done using the server routine called in the transformer.
In DB2 API stage we have a before sql to delete the record from the table with a condition. in generic sql an insertion is happening.
The problem we are facing is, when we run the job sometimes it is inserting the records and sometimes not.
Whenever it is inserting the below log we are getting
"ABAJBAMZN_NODE_ITEM(Trns_Format).ABAJBAMZN_NODE_ITEM_BDA#0.Trns_Format: DSD.StageRun Active stage finishing.
1211786 rows read from Input_records
1211786 rows written to Output_records
127.830 CPU seconds used, 4937.000 seconds elapsed."
whenever it is not inserting the below log we are getting
"ABAJBAMZN_NODE_ITEM(Trns_Format).ABAJBAMZN_NODE_ITEM_BDA#0.Trns_Format: DSD.StageRun Active stage finishing.
1211786 rows read from Input_records
0 rows written to Output_records
127.840 CPU seconds used, 5162.000 seconds elapsed.
"
Thanks In advance
Basic transformer in Parallel Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is different (possibly in the data) between when the inserts are successful and when they are not? Are there any other warnings (for example database not available) also logged?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.