Re: How to get free pages in a dbspace, backup info from within ESQL/C?

Rajesh N. Malhotra (malhotra@eos.ap.org) wrote: : : Informix Gurus, : How does one get the chunk info from within ESQL/C? The info that I : am looking for is How many pages are there in a dbspace, How many are : free etc. sysmaster:syschunks. : Also how would I get the last backup info from within ESQL/C? What I need : is the last backup date, and the level of backup. That's more difficult. If you use OnArchive it must be in sysmaster, but I don't know where. If you use ontape, I would imagine it is still there, but I don't know for certain. You could go and get it from the reserved page yourself, but that would require your program to have informix' permissions. You could grep `oncheck -pr`, but that's tacky from ESQL/C. : Is there a system table that contains all this info? No one table. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.