SQL2000 WITH JAS keeps shutting down

canadiangirlinusa

Member
Hi all, we've just completed our 8.10 upgrade 8.94N1 and SQL2000. Last week during peak hours we started getting SYSERRS in SAW (BSFN FAILING ON ENTERPRISE) and by day two sql shut down during a query. We could not replicate but daily we have had the same issue we brought our build up to 8.0780 and are entertaining another hotfix 8.0788. Today the pdf's (first sign of trouble) could not be viewed on web (fine on fat). There are no issues with the jobs on the enterprise server. So good news is SQL is not shutting down but we're getting the syserrs .. we think it has something to do with the JAS thread setting or connection pool in the jas.ini or jdbj.ini settings, anyone have any suggestions
 
Back
Top