Message ID . . . . . . . . . : CPF427F
Message file . . . . . . . . : QCPFMSG
Library . . . . . . . . . : QSYS
Message . . . . : Query exceeds specified time limit or storage limit.
Cause . . . . . : A database query was about to be started whose estimated
run time of &1 exceeds the specified limit of &2 or whose estimated
temporary storage usage of &3 exceeds the specified limit of &4. The query
time limit and temporary storage limit are specified on the CHGQRYA CL
Recovery . . . : The following changes to the query could reduce the
estimated elapsed time or estimated temporary storage usage.
— Change the query so that fewer records are returned by adding more
restrictive record selection specifications.
— Change the record selection of the query so that an existing access
path can be used to process the records more quickly.
— Create an access path with keys that match the record selection of the