[ 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
