DB2 10.5 for Linux, UNIX, and Windows

AM_BASE_RPT_RECOMS table function - Recommendations for activity reports

The AM_BASE_RPT_RECOMS table function returns recommendations for activity reports used by the activity event monitor.

Syntax

Important: The related activity monitor routines have been deprecated in Version 10.1 and might be removed in a future release. For more information, see Activity monitor routines have been deprecated.


>>-AM_BASE_RPT_RECOMS--(--report_id--,--client_locale--)-------><

The schema is SYSPROC.

Table function parameters

report_id: An input argument of type INTEGER that specifies a report ID. If the argument is null, recommendations for all available reports are returned.
client_locale: An input argument of type VARCHAR(33) that specifies a client language identifier. If the argument is null or an empty string, the default value is 'En_US' (English). If the message files for the specified locale are not available on the server, 'En_US' is used.

Authorization

One of the following authorities is required to execute the routine:

EXECUTE privilege on the routine
DATAACCESS authority
DBADM authority
SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.

Examples

Example 1: Request recommendations (in English) for the activity event monitor report with an ID of 1. Assume the default client language identifier 'En_US'.

SELECT * 
   FROM TABLE(SYSPROC.AM_BASE_RPT_RECOMS(1, CAST(NULL AS VARCHAR(33))))
   AS RECOMS

Example 2: Request recommendations (in French) for the activity event monitor report with an ID of 12.

SELECT *
   FROM TABLE(SYSPROC.AM_BASE_RPT_RECOMS(12, CAST('Fr_FR' AS VARCHAR(33))))
   AS RECOMS

Information returned

Table 1. Information returned by the AM_BASE_RPT_RECOMS table function
Column name	Data type	Description
REPORT_ID	INTEGER	The report ID.
RECOM_NAME	VARCHAR(256)	The name or short description of the recommendation.
RECOM_DESCRIPTION	CLOB(32K)	The detailed description of the recommendation.