(DI-2211) Collector for user defined SQL
- SNP
The collector for user-defined SQL is a default collector with the technical name /DVD/MON_CL_COL_SQL. This collector allows you to create a custom KPI, which you specify based on a SQL statement.
According to this SQL statement, the collector collects information and calculates the KPI value.
For information on how to create a custom KPI defined through a SQL statement, see the chapter (DI-2211) How to Create a KPI Through Defining a SQL SELECT Statement
Additionally, this collector enables you to display further KPI details in a Detail table. You can find instructions, on how to create a Detail table in this collector in the chapter (DI-2211) Create a Detail Table for a Custom KPI Assigned to the Collector for a User Defined SQL.
Parameters
Following parameters are available for this collector:
| Parameter name | Description |
|---|---|
| USE_BIND_VARIABLES | Should the SQL collector use bind variables when executing defined SQL statements? You might enable the bind variables by setting this value to 'X'. Default: empty (bind variables are not used by default) |
Bind variables
Collector for user-defined SQL supports also the usage of bind variables in SQL statements. To enable the usage of bind variables, the parameter 'USE_BIND_VARIABLES' needs to be set for this collector.
- When enabled, all placeholders defined in the SQL statement are replaced by "?" and relevant variable values are transmitted.
- When no bind variables are enabled, all placeholders are replaced by the corresponding values directly in the SQL statement.
Support for bind variables
Before enablement of bind variables, always make sure that your primary database supports these binding variables "?" on the system, where a defined SQL statement is executed.