db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-80) RFE: System Function for Diagnostic Info
Date Fri, 08 Sep 2006 10:03:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-80?page=comments#action_12433371 ] 
Christian d'Heureuse commented on DERBY-80:

The last item of my list (info about the active sessions and transactions) is partly resolved.
SYSCS_DIAG.TRANSACTION_TABLE lists the current transactions.
But for the other items in my list, I didn't find a system table or any other source of information.

The sysinfo tool does not list information about the database(s).

> RFE: System Function for Diagnostic Info
> ----------------------------------------
>                 Key: DERBY-80
>                 URL: http://issues.apache.org/jira/browse/DERBY-80
>             Project: Derby
>          Issue Type: New Feature
>          Components: Services
>            Reporter: Christian d'Heureuse
> Feature Request:
> A system function that lists internal diagnostic information:
> - A list of all Derby properties with their actual values.
> - The size and usage of the page cache.
> - Location of the system directory, temp directories, log file, ....
> - The names and state of all open databases.
> - A list of the active sessions, transactions, etc.
> etc.
> Reason: I find it difficult to control the effect of setting Derby properties, e.g. "derby.storage.pageCacheSize".

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message