Re: Raw chunks names script

select * from syschunks, sysdbspaces wheresysdbspaces.dbsnum = syschunks.dbsnum and nxchknum =0 and dbsname = <insert dbsname here> That should get you everything you need ot know about the last chunk in a given dbspace ------------------------------------------------------------------------------------ Praise the Lord oh my soul, let my inmost being praise His holy name. -Psalm 103:1 ----- Original Message ---- From: Colin Dawson <cjd_1955@hotmail.com> To: informix-list@iiug.org Sent: Friday, December 15, 2006 9:13:33 AM Subject: Raw chunks names script Does anyone have a script that will give me the name of the last chunk for a dbspace, I had a look in the repository but didn't see anything obvious Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ It's Hotmail's 10th Birthday! Come and play Pass the Parcel http://www.msnpasstheparcel.com _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list