Re: Dbspace Question.

Posted in 1998

David Kosenko — Tue, 23 Jun 1998 16:05:22 GMT — source: Informix-list mailing list archive (1991-1998)

Stefan Weideneder <stefan@weideneder.de> offerred: +select dbsname, tabname from sysextents where +hex(start) matches "0x004*" + +The values "0x004*" means the chunk number three. No, they mean chunk number 4. The high-order 12 bits contain the chunk number, while the remaining bits (low order 20 bits) contain the page offset into the chunk. 0x004 refers to the high order 12 bits, meaning chunk number 4. Don't know where you got 3 from... Dave ** Dave Kosenk <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training