Re: How to list all database names in a dbspace?

rbaumann@amgen.com (Richard Lee Baumann) wrote: >My sysadmin tells me that the tbcheck -pe command should not be used >on our system -- it corrupts the databases if blobs are in them (this >is a UNIX (Sun OS) system). I therefore cannot parse the output of >the tbcheck command to get a list of all datbases on the host server. >Can anyone suggest an alternate method? Oh dear, my experience is that tbcheck -pe is the only way to do. There was an article in this group recently descibing a dbschema like command which dumped table, dbspace and extents for a particular database. This used ESQL if I remember correctly. Sorry about my vagueness here, but the article has been deleted from my system. (Does your sysadmin actually want you to see how the DB is layed out?)