cancel
Showing results for 
Search instead for 
Did you mean: 

Tables & DBSpaces

fino11
Occasional Visitor

Tables & DBSpaces

Easy question but I am having one of those days and haven't used informix for ages ....

Running Informix version 7.23 - how can I find out what dbspaces my tables currently reside in
3 REPLIES
Pete Randall
Outstanding Contributor

Re: Tables & DBSpaces

Perhaps "onstat -t" or try "onstat --" to show all the available commands.


Pete

Pete
Peter Godron
Honored Contributor

Re: Tables & DBSpaces

Hi,
query the syscat.tables table?!
spex
Honored Contributor

Re: Tables & DBSpaces

fino11,

Try this:

# ls -l /opt/informix/dbspaces/

PCS