What is CPF427F in AS/400?

5 pts.
Tags:
AS/400
What does CPF427F mean in AS/400?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

DSPMSGD CPF427F

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     
  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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • philpl1jb

    if you have command line capability you can get that message yourself

    dspmsgd CPF427F

    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
    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

    54,090 pointsBadges:
    report
  • pdraebel
    Seems you will need to take action to speed up the query. When you receive the message use the F1 key whilst the cursor is positioned on the message text. The second level of the message text may hold information on how to correct the issue.
    7,545 pointsBadges:
    report
  • ToddN2000
    Is this message coming from a batch job, interactive job, WRKQRY? You may need to change the file keys or limit the number of returned data. If you provide some more details we can give you a few options to fix the problem.
    132,760 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: