Re: Question on the contents of tempdbs

There is a bug in Online, which does not release tempdbs space, when it empties. You'll need to get a dialup engineer to fix it. Hopefully, you have a support contract? The same thing can also happen with non-temp dbspaces as well. What OS platform are you using? Cosmo sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > Hi everybody, > I have a very funny situation here. I am unable to drop my > temporary dbspace because accoding to ODS "7.22", " the dbspace is not > empty ". Now, what on earth could exist in the tempdbs in Quiescent > mode, or when nothing is going on ??!! I did an oncheck pe and this is > what it looks like > DBspace Usage Report: tmpdbs Owner: informix > Created: 08/07/96 > > Chunk: 3 /dev/tmpdbs Size Used Free > 125000 101259 23741 > > Disk usage for Chunk 3 Start Length > ---------------------------------------- --------- --------- > OTHER RESERVED Pages 0 2 > CHUNK FREE LIST PAGE 2 1 > TBLSPACE TBLSPACE 3 50 > TBLSPACE TBLSPACE 821 50 > TBLSPACE TBLSPACE 1671 50 > TBLSPACE TBLSPACE 2521 50 > TBLSPACE TBLSPACE 3371 50 > ...... > ..... ( no actual table names specified ) > > The only thing that I ought to mention here is that I have two > chunks in this dbspace. ( tmpdbs and tmp2dbs ). All I am trying to do > is drop the second chunk and re-create it as another dbspace. The disk > usage for the other chunk is pretty much the same, except that it has > a "FREE" space alternating with every TBLSPACE > > Any ideas ?? I need that second chunk, since it is rarely getting > used in this setup. > > Speaking of which, is there a way to tell how much tempspace a > process would require / or how much it used ?? Also, is there a way to > reduce it without changing the code ?? One of my processess is taking > up all temp space and then it aborts since it cannot find any more. > > > Thanks > Sujata -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *