Re: Command to track the histroy of tablespace in informix

Meenakshi schrieb: > Hi All, > > Can u please tell me the idea of how to i reterive or track the > histoy of tablespce or dbspace which i have added from one particualr > date to other date. > > we need to show this info to our client. any ideas? > > Thanks, > Meenakshi sysmaster is your friend ($INFORMIXDIR/etc/sysmaster.sql). dbspace created: select name, dbinfo('utc_to_datetime',created) as created from sysmaster:sysdbstab;For chunks see sysmaster:syschktab (track history even). Regards, try_and_err