Hello, Thanks for all the help, by the way. We have been successful in addressing the 2033 errors and are now onto the next stage of our project. Actually, by trying to do this project, we found the aforementioned 2033 problem. Basically, this is what we are trying to do...
The applications people want to parse various Excel spreadsheets into text files on a server and pass those files to the mainframe utilizing MQ Series. This seems to suck up a HUGE amount of resources and is very slow. I don't know if it is a setting someplace, the way we are extracting the data, or what it is. The file gets translated into a .TXT file and every 'row' becomes a record on the ECL.DATA.REQUEST queue on the server. Once the LAST row has been PUT on the ECL.DATA.REQUEST queue, a record is written to the trigger queue (ECL.DATA.REQUEST). The proper program is kicked off on the mainframe side which will perform an MQGET on each ECL.DATA.REQUEST record and post that record to a file on the mainframe. That's it. We even tweaked this program to simply perform MQGETs and nothing else to try and achieve maximum throughput. BUT...the absolute best we can process these records is 35 records per second. This is EXTREMELY slow because the user will frequently have upwards of 10,000 rows on the spreadsheet. That comes out to almost five minutes--too long for something like this because the user will exit the web screen before that amount of time (we have very impatient users and most of them, by far, are outside distributors and we have little to no control over their habits. I say this is a BATCH process and should be treated like a BATCH process.. our current MQ process is set up to mimic on-line screens and we would abuse everything if we use it for this process, too. On the other hand, we have a person here who says she knows MQ Series and it works MUCH faster than 35-records-per-second. I agree it seems somewhat slow and it makes sense that we could improve upon it but this process, in general is batch-oriented (in my opinion). Is there anything we can do to increase the throughput? Or should we stick to FTPing the file to a GDG on the mainframe? Many thanks! Ray Kinzler Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
