Ansicht
Dokumentation

CPF427F - Query exceeds specified time limit or storage limit. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : CPF427F
Query exceeds specified time limit or storage limit.

Message Long Text :

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 command.
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 query using the CRTLF CL command or the SQL CREATE INDEX statement.
-- Change the ordering specification so neither a temporary access path needs to be built nor a sort needs to be performed.
-- Change the grouping field specification to match the left-most key fields of an existing access path. This allows an existing access path to be used.
-- If using the OPNQRYF CL command, specify the OPTIMIZE parameter with value *FIRSTIO. This parameter will cause the query optimizer to assume that the query will not be run to completion and consequently reduce the time estimate.
-- If using a query defined by SQL, specify the OPTIMIZE FOR NN ROWS clause where NN represents the actual number of records which are to be retrieved before the query is ended. This clause will cause the query optimizer to assume that the query will not be run to completion and consequently reduce the time estimate.
-- Change the output type of your query to produce the results on the display. For example, for the RUNQRY CL command specify *DISPLAY value for the OUTTYPE parameter.
-- Specify a new value for the query time limit with the QRYTIMLMT parameter of the CHGQRYA CL command.
-- Specify a new value for the query temporary storage limit with the QRYSTGLMT parameter of the CHGQRYA CL command.
-- Examine the query debug messages contained in the job log for performance information and suggestions. These messages will precede this message in the joblog and will provide additional information and suggestions.

Message File : QCPFMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3256 Date: 20240420 Time: 115119     sap01-206 ( 2 ms )