Re: Free DBSpace/tbstat
Well, if you were running version 7 you could query the sysmaster
database tables sysdbspaces and syschunks to get the answer but my guess
is your not if your runing tbstat and not onstat.
I guess you could remsh a script on the server and read the output
with awk (the are scripts available to do this in the archives).
-Bill
}
} Hi all,
}
} Is there any way in Informix to find out the current dbspace usage ? i.e.
} free space left on the DBspace being used. One way is to use tbstat command but
} this command works only from the m/c running Informix server and not from the
} client m/c.
}
} Is there any API call available to find this out ?
}
} Any help would be appreciated.
}
} Thanks
}
}
} anurag
}
} ---------------------------------------------------------------------------
} Anurag Garg Telephone : +1-408-975-2649 (W)
} TCSI Corporation
} 150 Almaden Blvd., Ste 900 +1-408-975-2535 (Fax)
} San Jose CA 95113 USA email : anurag@tcsi.com
} ---------------------------------------------------------------------------
}
}
}
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com