Ansicht
Dokumentation

SQL0666 - SQL query exceeds specified time limit or storage limit. ( OS/400 )

SQL0666 - SQL query exceeds specified time limit or storage limit. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0666
SQL 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 amount of 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 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.
-- 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 estimates.
-- Change the output type of your query to produce the results on the display.
-- 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 job log and will provide additional information and suggestions.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   General Material Data  
This documentation is copyright by IBM.

Length: 3258 Date: 20240329 Time: 093518     sap01-206 ( 2 ms )