unused tables
John Smith asked how to find unused tables. Art Kagel suggested saving sysptprof activity daily before any onstat -z reset, though Paul Watson noted sysptprof already holds names so the join is unnecessary. Snorri Bergmann said oncheck in 14.10 reports a 'Last Lookup/Scan' timestamp.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Is there a way to identify unused tables on a database , not accessed for a while ? thanks :) ------------------------------ John Smith ------------------------------ #Informix
Monitor the contents of the sysptprof pseudotable in sysmaster, join to systabnames on partnum to get the database and table name. Select and save that data say daily before any daily stats reset (onstat -z) if you run them. Then you can track activity over time. Note that update statistics will add to the reads against tables it processes.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog:
http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thanks a lot :) ------------------------------ John Smith ------------------------------
Just for instance, sysptprof aleady contains dbsname and tabname :) ------------------------------ John Smith ------------------------------
Arg. Serves me right for not checking. Art
Meaningless join ? Cheers Paul
Hi John.
In version 14.10 oncheck reports "Last Lookup/Scan" with a timestamp when it was last accessed.
Best regards,
-Snorri
------------------------------
Snorri Bergmann
------------------------------