Drop table from temp dbspace
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
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
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