Re: Drop table from temp dbspace
On Feb 18, 6:11 pm, Superboer <superbo...@t-online.de> wrote:
> Ooops i was too trigger happy ignore the prev. posting please
>
> Superboer
>
> On 18 feb, 14:04, Superboer <superbo...@t-online.de> wrote:
>
>
>
> > Hello Jose,
>
> > are you sure that it is a temp table??
>
> > if you gointo dbaccess and choose the database xxx(if possible...)
> > is there a table present that is called _temptable???
> > if that is the case you can use sql to fix the issue.
>
> > also if that is the case then temp1dbs is not a real temp dbspace,
> > when it was created the t flag was forgotten.
>
> > Superboer
>
> > On 18 feb, 11:08, Jose <joseph...@gmail.com> wrote:
>
> > > Hello,
>
> > > Have a situation were one temporary table is not getting dropped
> > > automatically from the temp dbspace. Table name is start with _
> > > (underscore). Table name is _temptable.
>
> > > Number of extents for this table is above 500 and our monitoring tool
> > > is throwing alerts.
>
> > > Some application is doing this. Killing the session didn’t work. And
> > > also restarted the application didn’t solve the issue.
>
> > > I know bouncing the Informix server will solve the issue.
>
> > > Is there any other solution apart from bouncing? Or bouncing is the
> > > only solution.
>
> > > Informix version: Informix Dynamic Server 2000 Version 9.21.H
> > > OS: HP-UX 11.X
>
> > > Output from oncheck:
>
> > > Chunk Pathname Size
> > > Used Free
> > > 4 /tempchunk1 1000000
> > > 14545 985455
>
> > > Description
> > > Offset Size
> > > -------------------------------------------------------------
> > > -------- --------
> > > RESERVED PAGES
> > > 0 2
> > > CHUNK FREELIST PAGE
> > > 2 1
> > > (0x400001) temp1dbs:'informix'.TBLSpace
> > > 3 50
> > > (0x400042) xxx:'aa'._temptable
> > > 53 8
> > > (0x400003) xxx:'aa'._temptable
> > > 61 8
>
> > > …………
>
> > > Thanks & Regards,
> > > Jose- Hide quoted text -
>
> - Show quoted text -
Hi,
I can't query / choose the table through dbaccess.
Thanks.
Jose.