Re: turbo extents used

Root@letterkenn-emh1.army.mil writes: >Is there a way in Informix-Turbo (not ON-Line) to determine how many extents >a table is currently using? I figure one of those handy figurest in tbstat >must indicate that.... >Thanks. >Ann Barnes If the table is active (and you can make it active by going into isql and issuing a LOCK TABLE statement), then tbstat -t will show the number of extents allocated for the table (nextns). There is a trick, however, in that tbstat shows the table with its tblspace number (partition number in Turbo parlance) not the table name. To get a list of table names and their respective (hex) partition/tblspace numbers, use the following query: select tabname, hex(partnum) from systables; Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney