Collecting System Statistics

Enable TIBCO ComputeDB system statistics using a system procedure, member boot properties, or connection properties.

You can enable statistics collection per-member using the boot properties:

Note

You must include the statistic-archive-file and specify a valid file name in order to enable statistics collection.

These boot properties help you configure a member's statistic archive file location and size:

To collect statement-level statistics and time-based, statement-level statistics for a specific connection (rather than globally or per-member), use these connection properties with a peer client connection:

These properties can only be used with a peer client connect.

Note

  • Because of the overhead required for taking many timestamps, it is recommended that you enable time-based statistics only during testing and debugging.

  • Use statement-level statistics only when the number of individual statements is small, such as when using prepared statements. TIBCO ComputeDB creates a separate statistics instance for each individual statement.