You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Christian d'Heureuse (JIRA)" <de...@db.apache.org> on 2004/11/24 18:30:30 UTC

[jira] Created: (DERBY-80) RFE: System Function for Diagnostic Info

RFE: System Function for Diagnostic Info
----------------------------------------

         Key: DERBY-80
         URL: http://nagoya.apache.org/jira/browse/DERBY-80
     Project: Derby
        Type: New Feature
    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://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[jira] Updated: (DERBY-80) RFE: System Function for Diagnostic Info

Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.

     [ http://issues.apache.org/jira/browse/DERBY-80?page=all ]

Mike Matrigali updated DERBY-80:
--------------------------------

      Component: Services
    Description: 
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".

  was:
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".

    Environment: 

> RFE: System Function for Diagnostic Info
> ----------------------------------------
>
>          Key: DERBY-80
>          URL: http://issues.apache.org/jira/browse/DERBY-80
>      Project: Derby
>         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

[jira] Commented: (DERBY-80) RFE: System Function for Diagnostic Info

Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.

    [ http://issues.apache.org/jira/browse/DERBY-80?page=comments#action_12433355 ] 
            
Andrew McIntyre commented on DERBY-80:
--------------------------------------

Christian, does the resolution for DERBY-571 and/or the information available via sysinfo fully resolve the enhancement request in this issue? If so, please link this issue to DERBY-571 and resolve/close this issue. If not, it may be more useful to open a new issue for the parts of this issue that have not been addressed.

> 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

[jira] Commented: (DERBY-80) RFE: System Function for Diagnostic Info

Posted by "Christian d'Heureuse (JIRA)" <de...@db.apache.org>.

    [ http://issues.apache.org/jira/browse/DERBY-80?page=comments#action_12432546 ] 
            
Christian d'Heureuse commented on DERBY-80:
-------------------------------------------

see http://issues.apache.org/jira/browse/DERBY-571
and http://db.apache.org/derby/javadoc/engine/org/apache/derby/diag/package-summary.html

> 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

[jira] Commented: (DERBY-80) RFE: System Function for Diagnostic Info

Posted by "Christian d'Heureuse (JIRA)" <de...@db.apache.org>.

    [ 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