Re[2]: Question on the contents of tempdbs
Thanks Cosmo,
Yes, we do have a support contract. And we are using ODS 7.22 on IBM AIX
4.1.4
Do you have a bug number that I can quote ?? What would cause this problem,
since I have sucessfully dropped tempdbs on another m/c ?
Thanks
Sujata
____________________Reply Separator____________________
Subject: Re: Question on the contents of tempdbs
Author: Cosmo Lee <"* N O - S P A M * cosmo"@echonyc.com>
Date: 11/7/97 12:33 PM
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"
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *