hashtemp.th_overflow_ffffffffffffffff in openview

Posted in 2008

CHUAN LU — Sat, 26 Jul 2008 00:44:14 — source: IIUG Forums & Mailing Lists

Hello: One customer use openview to monitor informix 10 database, they find one table "hashtemp.th_overflow_ffffffffffffffff " use lots of extents,but this tables isn't a user table, Do anybody know what this table come from? thks...

↪ replying to CHUAN LU

Fernando — Sat, 26 Jul 2008 10:04:27 — source: IIUG Forums & Mailing Lists

Some user session is doing some HASH join. This is a temporary structure constructed to resolve some query. It will go away when the query finishes. You may find similar "tables" for SORTS and ORDER BY. Regards. On Sat, Jul 26, 2008 at 1:44 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Hello: > > One customer use openview to monitor informix 10 database, they find one > table > "hashtemp.th_overflow_ffffffffffffffff " use lots of extents,but this > tables > isn't a user table, Do anybody know what this table come from? thks... > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...