A message is displayed when the monitoring system tries to return data to a table

The monitoring agent tries to return data for the table specified by the product.table variable, and it fails.

The following message is displayed from IBM Tivoli Monitoring:

Cannot allocate nnnnnnnn bytes for sample data, <xxxxxxxxxxxxxxxxxx> on product.table

OMEGAMON AI for CICS issues this message in the RKLVLOG output, for some of the tables:

KCP0229W: ira AddData for cicjobn failed after n rows.

The most common cause of this error is a query that returns a large number of rows of data, causing an out-of-memory condition. IBM Tivoli Management Services: Engine (TMS:Engine) startup parameters are defined with appropriate defaults for many customer environments. The parameters are defined in the data set pointed to by the RKLVIN DD statement. TMS:Engine startup parameters specify the execution and resource management environment. The TMS:Engine component uses two of these parameters, the LIMIT and MINIMUM parameters, to determine how much data can be sent to the Tivoli® Enterprise Monitoring Server.

To address this issue, you can modify the query so that it returns fewer rows of data or change the LIMIT and MINIMUM values. Change the parameters in the RKLVIN file or the EXEC PARM field of the JCL.