Re: Mysterious sql problem

> > >-----Original Message----- >From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] >Sent: Friday, November 05, 2004 10:50 AM >To: Dirk Moolman; Dave Griffen; Simmons, Keith; informix-list@iiug.org >Subject: RE: Mysterious sql problem > > > >Expanding the term "environment" even further..... >What's your server doing during this time? It's a mix, you could see half a dozen dss style queries running which take 30minutes or longer each to complete, you could have 40 users doing oltp data entry, you could have 5 other batch jobs processing data behind the scenes, and then there are times on Saturday morning when this has the system completely to itself. We are accustomed to seeing some degradation of performance when the engine is actively working on a dozen or more threads, but this statement of this app is having issues long before that and even occurs when it is the only thing running. >How long has it been up? Perhaps a reboot has activated something at >the server level (which may have been a recent change or something done >a long time ago/needed a reboot/never got one/now the server boots/chg >activates).... This server gets rebooted once a week, including once since this surfaced last week. As for configuration changes on the reboot previous to the problem occuring, the DUMPDIR was changed away from /tmp to a file system with more space, and the DBSTEMP was dropped recreated specifying the -t option of onspaces. Our server administrator has told me that no changes were made to the operating system. > >What's your network doing?.... Is this a app running/connecting on the >same server as the DB or coming across a net as a client?... This app is running locally on the database server. It is connecting via tcp. > >You said you were IDS 9.3.... >I heard 9.4 has dynamic set explain... You could turn that on for that >session (without putting it in code)...but you're not there... We've gotten an sqexplain.out from the app by bracketing the statement with SET EXPLAIN ON and SET EXPLAIN OFF. The sqexplain.out looks the same as theone from dbaccess. > >Good luck, >NJ Thanks, let me know if you think of anything else. Dave Griffen