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

        

Mime
View raw message