Insert to AS400 hangs

wwalker · Post by **wwalker** » Mon May 19, 2008 5:53 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 4:41 pm

No idea. Can you use another client (maybe MS Access) to insert rows via an ODBC connection?

wwalker · Post by **wwalker** » Tue May 20, 2008 12:58 am

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...

chulett · Post by **chulett** » Tue May 20, 2008 6:18 am

That... smells like a bug. You may want to report it.