Help with Progress Monitoring

[nealeb]

I am really new with Progress DB and needs some help with basic monitoring. I am creating a VBscript to use the Progess ODBC connection to query the database to make sure it is up. The query I was going to use is...
select * from sysprogress.systblstat
but it returned 0 rows from the database. Is there a basic query I can run that can return some kind of version number or statistic?

Thanks

 

[gabriel.flores]

Hi!

The fields _Connect-id and _Connect-Usr from table _Connect give you a list of all users connected to the database. Useful for a query like yours. For db monitoring, the "promon" utility can give you too many statistics about the database and your execution status.

Regards
Gabriel Flores

 

[Casper]

I am creating a VBscript to use the Progess ODBC connection to query the database to make sure it is up.

If the database isn't up you can't connect to it, so therefore it would be imposible to query the database.

For statistics of the databse you first have to run update statistics to generate the required statistics.

After runnning this you can acces the statistics with:

select* from systblstat

for table statistics or

select * from sysidxstat

for index statistics.

HTH,

Casper.