tbcheck -pt stats

netters (informix employees), TBLSpace Report for quality:informix.test_note Physical Address 300008 Creation date 05/07/93 13:54:20 TBLSpace Flags 1 Page Locking Maximum row size 94 Number of special columns 0 Number of keys 1 Number of extents 4 Current serial value 1 First extent size 4000 Next extent size 500 Number of pages allocated 8500 Number of pages used 8139 Number of data pages 6818 Number of data bytes 9651450 Number of rows 102675 Extents Logical Page Physical Page Size 0 308ce2 6500 6500 30fe2a 1000 7500 303ada 500 8000 306bae 500 is there a way to get this information without locking the table and waiting for it to examine all the extent information? basically, i want a quick way to grab the number of pages allocated and the number of pages used (both data and index pages). the sql tutorial goes through estimating the space requirements for a table, but i just want to see what the actuals are. the other requirements are that it has to run in the backgroup without locking the table. ideally, it should be a 4gl callable function given a database:table. regards, ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------ Sun 690-MP Informix Versions: Online - 5.00.UC2 ISQL - 4.10.UD1 4GL-RDS- 4.10.UC1 ------------------------------------------------------------------------------