Identifying types of temporary tables

Hi gurus, I want to catch de application that is consuming a lot of space of temporary dbspaces. I know there is no direct way to associate sessionid with use of temporary space. Moreover, there are temporary tables that are created internally by the engine. Do you know when is created the following tables ? 1. when is created th_build_fffffffff ? 2. when is created th_probe_fffffffff ? 3. when is created th_tmprun_c000000d ? 4. When is created th_overflow_0xffff ? Thanks in advance. IDS = 11.70FC8 Roger

Original post: Hi gurus, I want to catch de application that is consuming a lot of space of temporary dbspaces. I know there is no direct way to associate sessionid with use of temporary space. Moreover, there are temporary tables that are created internally by the engine. Do you know when is created the following tables ? 1. when is created th_build_fffffffff ? 2. when is created th_probe_fffffffff ? 3. when is created th_tmprun_c000000d ? 4. When is created th_overflow_0xffff ? Thanks in advance. IDS = 11.70FC8 Response: So 1, 2, and 4 would possibly be created by queries doing hash joins that were large enough to not fit in memory allocated to the query (things like pdq and the pdq onconfig setting would affect that amount of memory). Then 3 would be a query doing a sort that had to go to disk (so again too much data to sort everything in memory). Jacques Renaut HCL Informix Advanced Support