Location temp tables and their names

Hi All, I am one question: Where Informix Dynamic Server save information about how temp tables is created and what is their names? Thanks D.MALININ __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

In the memory of course ..:-) There are structures which point to the temporary tables ... U can run the following query to get the temp tables in the instance: SELECT hex(i.ti_partnum) partition, trim(n.dbsname) || ":" || trim(n.owner) || ":" || trim(n.tabname) table, i.ti_nptotal allocated_pages FROM systabnames n, systabinfo i WHERE ((bitval(i.ti_flags, "0x0020") = 1) OR (bitval(i.ti_flags, "0x0040") = 1) OR (bitval(i.ti_flags, "0x0080") = 1)) AND i.ti_partnum = n.partnum and if you want to identify which sessions are having the temp tables, either you can use onstat -g ses to get the information or I can provide with a script which does that for you. If you are interested let me know, and I'll send it across to you. Thanx much, Rajib Sarkar Advisory Support Engineer (Wells Fargo Bank) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "Mitko Malinin " <informix_bg@yaho To: ids@iiug.org o.com> cc: Sent by: Subject: Location temp tables and their names [402] forum.subscriber@ iiug.org 02/14/2003 06:38 AM Hi All, I am one question: Where Informix Dynamic Server save information about how temp tables is created and what is their names? Thanks D.MALININ __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com