Something I don't understand currently is happening during an insert to AS400.
- DRS Stage over ODBC (AS400 client not installed on DS Server)
- AS400 table is journalized
- Field datatypes - all character except one numeric. Data verified for Numeric field to be numeric (eg. :010) for all records
Job flow is as follows:
1. Calls procedure to create table by company site (list derived from source file)
2. Inserts records to table.
The job seems to insert a single line, then hangs. AS400 guys think this is a DS problem, because the table is created and accepts one line...I think it may be an AS400 problem for the same reason...
the truth is somewhere in the middle...
any ideas what might be causing this?
Insert to AS400 hangs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Mar 30, 2006 6:30 am
- Location: Near Geneva, Switzerland
- Contact:
Insert to AS400 hangs
Wade Walker
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 40
- Joined: Thu Mar 30, 2006 6:30 am
- Location: Near Geneva, Switzerland
- Contact:
Found the solution...
Due to large data volumes received during development, and performance issues, I had set the commit interval quite high. Now, however, I am only receiving under 100 records, which is under the commit interval. DataStage seems to be waiting for additional lines (which really does not seem to make sense....)
I reset the commit interval to 0...and it is working...
Due to large data volumes received during development, and performance issues, I had set the commit interval quite high. Now, however, I am only receiving under 100 records, which is under the commit interval. DataStage seems to be waiting for additional lines (which really does not seem to make sense....)
![Embarassed :oops:](./images/smilies/icon_redface.gif)
I reset the commit interval to 0...and it is working...
Wade Walker