Skip to Content
author's profile photo Former Member
Former Member

Limit on number of statements exceeded

Hi Experts,

He have done SAP Data archiving in a test server. The current ASP used is 88%. After delete job in DB12 it is showing 148 GB space. Now I want to reorganized the Table (COEP). But it is showing an error Limit on number of statements exceeded after sometime. How to resolve it?

Asad

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 10, 2014 at 08:20 AM

    Hi Asad,

    Please check whether solution in below SAP note is useful.

    Note 54028 - IBM i: SQL0 904 reason code 7, overflow in SQL package

    Additionally check your table in which you insert using command DSPFD <LIBNAME>/COEP

    OS/400 can limit a table to a max. specific content (eg. 10000 rows).

    Then change it with CHGPFM to no max.

    Hope this helps.

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2014 at 08:58 AM

    Hi Asad,

    how large is COEP ?

    How many rows do your have in COEP ?

    How many rows are deleted in COEP ?

    How large is your ASP

    The ASP usage is 88%, isn't it ?

    You should keep in mind, that COEP gets copied with the new size temporary twice ...

    Therefore, it might become an issue ...

    I do hope, that you do have more tables with deleted rows .... then you might want to start the smaller ones first in order to get more free ...

    I suggest, that you install the CONTOOL with investigation for this in order to get a good overview on youur DASD usage ... you can download it for free at:

    consolut - Monitoring and administration on iSeries

    Regards,

    Volker Gueldenpfennig, consolut international ag

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.