dropping temp db space problem

hi all: I asked a question some days ago about temp db space not get cleaned up. The advice given were to drop it and recreate it. I used onmonitor trying to drop it, it says Cannot drop dbspace, ISAM error, dbspace is not empty. hmm, what do I do now? thanks. yan

Run an oncheck to see what is in the temp dbspaces (oncheck -pe > peoutput) and find out what sessions are writing to them. Alert the sessions (users) to suspend (exit) thier jobs to allow you to drop the Temp dbspaces, recreate them, and possible restart your engine. In article <77an6r$1l2$1@news.xmission.com>, "Yan Zhu" <yan.zhu@infinity-insurance.com> wrote: > > hi all: > I asked a question some days ago about temp db space not get cleaned > up. The advice given were to drop it and recreate it. I used onmonitor > trying to drop it, it says Cannot drop dbspace, ISAM error, dbspace is > not empty. hmm, what do I do now? > > thanks. > yan > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own