Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep
Home >> All >> org >> apache >> derby >> [ diag Javadoc ]

• org.apache.derby.diag: Javadoc index of package org.apache.derby.diag.


Package Samples:

• org.apache.derby.diag

Classes:

• SpaceTable: SpaceTable is a virtual table that shows the space usage of a particular table and its indexes. This virtual table can be invoked by calling it directly, and supplying the schema name and table name as arguments. select * from new org.apache.derby.diag.SpaceTable('MYSCHEMA','MYTABLE') t; If the schema name is not supplied, the default schema is used. select * from new org.apache.derby.diag.SpaceTable('MYTABLE') t; Alternatively, the table can be invoked through the system alias SpaceTable select * from new SPACETABLE('MYTABLE') t; NOTE: Both the schema name and the table name must be any expression ...
• TransactionTable: TransactionTable is a virtual table that shows all transactions currently in the database. This virtual table can be invoked by calling it directly select * from new org.apache.derby.diag.TransactionTable() t; or through the system alias TransactionTable select * from new TRANSACTIONTABLE() t; The TransactionTable virtual table takes a snap shot of the transaction table while the system is in flux, so it is possible that some transactions may be in transition state while the snap shot is taken. We choose to do this rather then impose extraneous timing restrictions so that the use of this tool will ...
• LockTable: LockTable is a virtual table that shows all locks currently held in the database. This virtual table can be invoked by calling it directly select * from new org.apache.derby.diag.LockTable() t; or through the system alias LOCKTABLE select * from new LOCKTABLE() t; The LockTable virtual table takes a snap shot of the lock table while the system is in flux, so it is possible that some locks may be in transition state while the snap shot is taken. We choose to do this rather then impose extranous timing restrictions so that the use of this tool will not alter the normal timing and flow of execution ...
• ErrorLogReader: ErrorLogReader is a virtual table interface (VTI) which contains all the statements of "interest" in db2j. log or a specified file when db2j. language. logStatementText=true. One use of this VTI is to determine the active transactions and the SQL statements in those transactions at a given point in time, say when a deadlock or lock timeout occurred. In order to do that, you must first find the timestamp (timestampConstant) of interest in the error log. The SQL to view the active transactions at a given in time is: SELECT vti.ts, threadid, cast(xid as int) as xid_int, cast(lccid as int) as lccid_int, ...
• StatementDuration: StatementDuration is a virtual table which can be used to analyze the execution duration of the statements of "interest" in db2j. log or a specified file when db2j. language. logStatementText=true. A limitation is that, for each transaction ID, a row will not be returned for the last statement with that transaction id. (Transaction IDs change within a connection after a commit or rollback, if the transaction that just ended modified data.) The execution duration is the time between the beginning of execution of two successive statements. There are a number of reasons why this time may not be accurate. ...
• StatementCache: StatementCache is a virtual table that shows the contents of the SQL statement cache. This virtual table can be invoked by calling it directly. select * from new org.apache.derby.diag.StatementCache() t The StatementCache virtual table has the following columns: ID CHAR(36) - not nullable. Internal identifier of the compiled statement. SCHEMANAME VARCHAR(128) - nullable. Schema the statement was compiled in. SQL_TEXT VARCHAR(32672) - not nullable. Text of the statement UNICODE BIT/BOOLEAN - not nullable. True if the statement is compiled as a pure unicode string, false if it handled unicode escapes. ...
• ErrorMessages: ErrorMessage shows all the SQLStates, locale-sensitive error messages, and exception severities for a database. To use it, query it as follows: SELECT* FROM NEW org.apache.derby.diag.ErrorMessages() AS EQ; The following columns will be returned: SQL_STATE--VARCHAR(5) - nullable. The SQLState of the SQLException. (The code returned by getSQLState() in SQLException.) MESSAGE--VARCHAR(32672) - nullable. The error message (The code returned by getMessage() in SQLException.) SEVERITY--INTEGER - nullable. The Cloudscape code for the severity. (The code returned by getErrorCode() in SQLException.)
• ConglomInfo

Home | Contact Us | Privacy Policy | Terms of Service