Customized SQL Status (KUD_Customized_SQL_Status) attributes

Use the Customized SQL status attribute group to obtain information about customized SQL statements, such as the SQL ID, the DB Alias, error code, SQL state, error message and last execution time.

Node Name The managed system name of the agent. For new installations of version 7.1, the format is instanceid:hostname:UD for all operating systems.

Timestamp The local time at the agent when the data was collected.

SQL ID The SQL ID that is defined in the definition file.

DB Alias The alias name of the database on which the SQL Statement associated with the SQL ID is executed, which is a key attribute.

SQL State The SQL STATE returned by DB2® for the last SQL execution, which has a length of 10 characters.

Last Execution Error Code The native error code returned by DB2 for the last SQL execution.

Last Execution Error Message The error message returned by DB2 for the last SQL execution, which has a maximum length of 256 characters.

Last Execution Time The last date and time when the SQL is executed.