Re: tables in dbspace (Online

> Is there a simple way to find which tables are in a dbspace? > (Or, what dbspace a table is in?) > -Brian > ------ > brena@hcia.com Try this: select tabname TableName, hex(partnum) TableNum from systables order by TableNum TableName; The output will be in hex. The number will be the dbspace number the table resides in. (e.g., 0x0200003 means that this is the third table created in dbspace number 2). Use tbstat -d to find out the dbspace number. ############################################################## David Nguyen Internet: davidn@geis.geis.com GE Information Services UUCP: uunet!ge!davidn 401 North Washington Street Voice: 1-301-340-5461 Rockville, MD 20850 USA ##############################################################