A Datastage Job creating an Issue to the entire Database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Tue Dec 27, 2005 12:13 am
A Datastage Job creating an Issue to the entire Database
Hi,
In my Job, I am using two datasets and then Funneling it by a Funnel stage (Funnel Type --- Continous Funnel) and then inserting it into a Db2 Table by using a User defined Update (Giving Insert Staement in User defined Update). Partioning type is Db2.
The Job is running on 4 nodes and one dataset is carrying around 5000 records and the other is carrying 0 records.
Row Commit Interval is 999999
Array Size 999999
The Job is Aborting and the entire database is geeting down because of this Job. Can a Single Job create an Issue to entire Database?
Plz help me to know whats the wrong thing in this Job.
In my Job, I am using two datasets and then Funneling it by a Funnel stage (Funnel Type --- Continous Funnel) and then inserting it into a Db2 Table by using a User defined Update (Giving Insert Staement in User defined Update). Partioning type is Db2.
The Job is running on 4 nodes and one dataset is carrying around 5000 records and the other is carrying 0 records.
Row Commit Interval is 999999
Array Size 999999
The Job is Aborting and the entire database is geeting down because of this Job. Can a Single Job create an Issue to entire Database?
Plz help me to know whats the wrong thing in this Job.
-
- Participant
- Posts: 34
- Joined: Tue Dec 27, 2005 12:13 am
-
- Participant
- Posts: 34
- Joined: Tue Dec 27, 2005 12:13 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Start with one row per transaction. This should work.
Increase it to 1000. This should work also, since DB2 can easily handle 1000 row transactions.
Ask your DBA whether the database can handle a transaction containing 1 crore records, and be prepared to run for cover!
Increase it to 1000. This should work also, since DB2 can easily handle 1000 row transactions.
Ask your DBA whether the database can handle a transaction containing 1 crore records, and be prepared to run for cover!
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.
-
- Participant
- Posts: 34
- Joined: Tue Dec 27, 2005 12:13 am
[Ask your DBA whether the database can handle a transaction containing 1 crore records, and be prepared to run for cover![/quote]
The Transaction handling depends on the table or the entire database?
If it depends on entire database, then some Jobs are running successfully with transaction containing more than 1 crore records.
The Transaction handling depends on the table or the entire database?
If it depends on entire database, then some Jobs are running successfully with transaction containing more than 1 crore records.
-
- Participant
- Posts: 34
- Joined: Tue Dec 27, 2005 12:13 am