eastbay66
Member
I have a custom UBE that, when submitted to run on the AS/400, takes an extremely long time to end after it has finished processing. When I run it interactively from my Fat Client, it runs/finishes perfectly. In the XE sbmttd jobs window, it shows as complete, but it continues running on the AS/400 (trying to close, but not processing records anymore).
It's reading through a custom table (which I've deleted and recreated again). With 500 records or so in the table, it ends normally, but as the # of records in the table increases, it takes longer and longer for the UBE to close out on the 400 side after processing all records. With the normal 8k to 9k # of records, it's taking almost a full hour to end (using WRKACTJOB).
We have tons of custom UBEs, and this is the only one doing this. I've even rewritten the entire program, as well as the custom table it's based on.
Has anyone ever encountered this, or does anyone have any suggestions as to what's going on??? Of course, Oracle/JDE has been of no help!!!
Thanks,
Ray
It's reading through a custom table (which I've deleted and recreated again). With 500 records or so in the table, it ends normally, but as the # of records in the table increases, it takes longer and longer for the UBE to close out on the 400 side after processing all records. With the normal 8k to 9k # of records, it's taking almost a full hour to end (using WRKACTJOB).
We have tons of custom UBEs, and this is the only one doing this. I've even rewritten the entire program, as well as the custom table it's based on.
Has anyone ever encountered this, or does anyone have any suggestions as to what's going on??? Of course, Oracle/JDE has been of no help!!!
Thanks,
Ray