Report on Locks

This section describes how you can create the report definition for locks.

Follow these steps:

Edit the reports.xml file and include the report definition for the properties of the Lock table that you want to report on.
Edit the reports_schema.xml file and include the schema definition for the report. You can also generate the schema definition using a tool of your choice and include it in the reports_schema.xml file.

The following example shows the report definition to report on the Lock table:

 <report>

    <Name>Locks</Name>

        <Lock>

            <Report_Output>

               	<Property>

            		<Type>ID</Type>

             		<Type>Catalog_ID</Type>

             		<Type>Type</Type>

             		<Type>Time</Type>

             		<Type>User_ID</Type>

                </Property>

             </Report_Output>

        </Lock>

 </report>

Column Name	Description
Id	Unique identifier for the lock
Catalog_Id	Catalog identifier for which the lock is applicable
User_Id	User identifier that has acquired the lock
Cause	The identifier of the lock that has caused this lock
Type	Type of the current lock. The values: E: Existence S: Shared U: Update X: Exclusive
Isolation	Isolation level of the current lock. The values: C: This lock not only affects the current catalog but also all child entries of the catalog L: This lock only affects the current catalog
Time	Date and time when the lock was applied