Hi Cliff, I'm not an AS400 expert, but one of the problems that I faced while getting POI up and running on OS390 was that of time shares. If I ran a POI batch job similar to your own through my TSO RACF ID it took hours to complete. Was this the fault of POI (or even JDBC?) No; the time slices that my job received were that of the console I ran it from (i.e. not very many.) Once it was run as a proper batch job it completed in record time.
Try running your POI job on a desktop machine connecting to the database remotely (if you're using DB2, you might need to install DB2 Connect on your local machine.) If you notice it runs significantly faster (despite the remote JDBC connection) you can be certain that your problem stems from your job is not getting enough CPU. Regards, -Jeff > > It's still running! Also note that my program is basically creating a > JDBC result set from a SQL statement and writing this data column by > column row by row to the spreadsheet. Nothing fancy. It's still running! > > Cliff > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> For additional > commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
