Re: Informix Online - which dbspace

Tim, The easiest way that I can think of is to run the "tbcheck -pe" command. This will list the table extent usage by dbspace. You can also tell which database is in which dbspace from this output. Have fun, Tracy W. Nedd National Weather Service - DBA vball@skipper.ssmc.noaa.gov } } Hi, } } I've got to write some end of day routines that need to drop some } tables and then recreate those tables. } } My question is - Under 'on-line' how do I find out the name } of the dbspace that a table is in ? } } There doesn't seem to be any documented method of achieving this. } } I'd be grateful for any help at all here. } } [This application is under versions 5.*, 6.* and 7.* of on-line] } } } } Tim McCrea } (tim@mccltd.demon.co.uk) } }