Re: finding a databases dbspace

s_cawley@litle.net wrote: > > Hi, > > If I know a database name, how can I find the name of the dbspace it > lives in? I have been looking through the sysmaster tables looking for an > answer and cannot find one. > > I can find this information using onmonitor, but would like an SQL > based solution to this problem. > > Thanks, > > Steve > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet Steve, try something like select hex(partnum) from yourdatabase:systables where tabname = "systables" It will return something similar to: 0xNNN0008E where NNN is dbspace number. HTH Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+