Subject | [Firebird-Java] Using Service API to retrieve database statistical info |
---|---|
Author | Davinir F Campos Jr |
Post date | 2006-02-09T13:16:05Z |
Hi all,
I'd like to use Jaybird to substitute the command that follows (that
runs on a script):
gstat -a -i -r 127.0.0.1:dbalias -u sysdba -p masterkey
First, is there any "step-by-step" example out there, showing the
correct sequence on attaching, querying, adn detaching.
Second, how do I implement the functionality of "-r" option of gstat?
I mean, gstat's "-r" stands for "analyze average record and version
length" (from gstat -h).
In org.firebirdsql.management.FBStatisticsManager.java, the options
are restricted to DATA_TABLE_STATISTICS and/or SYSTEM_TABLE_STATISTICS
and/or INDEX_STATISTICS, and in org.firebirdsql.gds.ISCConstants.java
doesn't exist the isc_spb_sts_record_versions constant (of value 0x20
as stated in ibase.h, line 2367, from FireBird 1.5.2.4731).
Thanks for your attention,
J
I'd like to use Jaybird to substitute the command that follows (that
runs on a script):
gstat -a -i -r 127.0.0.1:dbalias -u sysdba -p masterkey
First, is there any "step-by-step" example out there, showing the
correct sequence on attaching, querying, adn detaching.
Second, how do I implement the functionality of "-r" option of gstat?
I mean, gstat's "-r" stands for "analyze average record and version
length" (from gstat -h).
In org.firebirdsql.management.FBStatisticsManager.java, the options
are restricted to DATA_TABLE_STATISTICS and/or SYSTEM_TABLE_STATISTICS
and/or INDEX_STATISTICS, and in org.firebirdsql.gds.ISCConstants.java
doesn't exist the isc_spb_sts_record_versions constant (of value 0x20
as stated in ibase.h, line 2367, from FireBird 1.5.2.4731).
Thanks for your attention,
J