Re: Find names of all databases in a DBSPACE

clough@hyster.rain.com (David Clough) writes: >Is there a way to get a list of all of the databases in a dbspace? >My dbspace is very dynamic and I need a way to get this list. >Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c >David Clough I don't have the output from a tbcheck -pe handy, but I think you can run a command like this: tbcheck -pe | sed "/dbspacename/,/nextdbspace/!d" | grep systables | sort -u | awk -F':' '{print $1}' You should be able to determine what patterns to use for sed by checking the output from tbcheck -pe. Hope this helps