Re: Using DBINFO

Marco, Thanks, I had forgotten we changed a table to fragmented for this new DB. Regards Colin >From: Marco Greco <marco@4glworks.com> >To: Colin Dawson <cjd_1955@hotmail.com> >CC: informix-list@iiug.org >Subject: Re: Using DBINFO >Date: Mon, 11 Jul 2005 15:47:45 +0100 > >Colin Dawson wrote: >>If I run the following >> >>select tabid, tabname, hex(partnum) >>from systables >>where tabtype = 'T' >>order by 1>> >>I get a nice list of all tables and their respective partnum ordered by >>tabid >> >>If I run the same query with , DBINFO('DBSPACE',partnum) added to the list >>of columns, >>I get 727: Invalid or NULL TBLspace number given to dbinfo(dbspace). >> >>If I do the same on a different DB on the same server it works perfectly >> >> >>Anybody got any clues? >> >> >> >>Regards >> >>Colin Dawson >> >> >>sending to informix-list >> > >you have fragmented tables, or tables with detached indexes > >-- >Ciao, >Marco >______________________________________________________________________________ >Marco Greco /UK /IBM Standard disclaimers apply! > >Informix faq >http://www.iiug.org/techinfo/faq/informix.htm >4glworks >http://www.4glworks.com >Informix on Linux >http://www.4glworks.com/ifmxlinux.htm > sending to informix-list