Symptom:
During execution of the DBA Command Manager for DB2 module, the following messages are received in the OFS agent started task:
BPA0148E: #@XMSG SERVICE FAILED BPA0080I: BATCH PROCESSING EXECUTION: DATE=xxxx/xx/xx TIME=xx:xx. IEC030I B37-04,IFG0554A,agentjobname,OFSAGENT,SYS00036,5267,WRKxxx,userid.ETJ.$mmddyy.$hhmmss.SELECT BPA0148E: #@XMSG SERVICE FAILED:R15=00000004 R0=00000000
Solution:
These messages indicate that the result set of the query has exceeded the space allocated. The current limitation for the SELECT query result set is 1 MB.
Specify a WHERE class on your SELECT SQL statement to limit the number of rows being retrieved.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|