Monday, April 12, 2010

DB2 Frustration

During development of the Landfile application, I had the need to call a stored procedure in a DB2 (AS/400) environment based on multiple points selected in an ArcMap interface. If a single point was selected, the procedure would run fine. However, if multiple points were selected, the first execution would complete, but the process would hang thereafter.

In working with the AS/400 guru, we came to discover that the stored procedure was not exiting after the first call, which was causing the process to hang. It also attempted to modify the Library List that was loaded by the first iteration of the process. Once he killed that stored procedure after every call, it worked as expected. Not terribly performant, but at least working.

No comments:

Post a Comment