Limit on number of statements exceeded

[Former Member]

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

[volker_gldenpfennig]

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

[Former Member]

Hi Volker,

COEP Table size is 462,983,304 KB,

Total Number of Rows: 256,773,460

Number of Deleted Rows: 121,280,610

See the below screenshots.

Thanks

Asad

[volker_gldenpfennig]

Hi Asad,

this will not work in the current situation 😞

do you other tables, that you can rgzpfm first ?

in your case, it looks like, that you are "nearly ok", but it not completely fits ... So a bit might help.

volker

[Former Member]

Hi Volker,

Is there any rule to reorganize the tables, that required free space for reorganization? And is it possible to reorganize it partially(means 50% deleted rows to be reorganized) ?

Asad

[volker_gldenpfennig]

Hi Asad,

at least 100% will be enough - in my eyes, the resulting size of the table as additional free space should be sufficient ... in your case, this is not fully ok ...

So, you should reorg a few other ones ...

volker

[former_member188883]

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