Re: sysptprof

Hi, Bill Ennis wrote: > I have a question on the sysptprof table in systables. The manual > says that profile information is available only when a table is > open. Does this mean that rows are deleted from this table when > no users are accessing OR does it mean that some information > within ome of the columns is not available when it is open. I think this means that only tables that have been used and are cached in shared memory (the Tblspace table structure) are in this SMI table. If you have a 1000 tables on disk, and only 400 have been accessed then this table will only contain 400 rows. Rows stay in this table until the shared memory space is required by another table. Even if no user has a table open, its information may still be cached in the tblspace structure and you can access it via this SMI table. Regards - Lester ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Grant group privileges for Informix databases with DB Privileges Visit our Web page: www.advancedatatools.com Washington Area Informix User Group: www.iiug.org/~waiug/ ______________________________________________________________________