cancel
Showing results for 
Search instead for 
Did you mean: 

Big number of files (physical + logical) opened by a SAP -related job

Former Member
0 Kudos

Hello,

We are implementing SAP ECC 6.0 on IBM System i (iSeries) 9406-550, i5/OS V5R4.

SAP is implemented on sub-system R3_00, and the different SAP processes are served by OS/400 jobs : WP00, WP01, WP02,…etc.

The noticeable thing is that since the very beginning of the working day, the number of open files (Physical + Logical) opened by one job (e.g. WP00) is extremely big (900 – 1000 files), and it remains big during the whole day; i.e. it varies by a small extent.

The question is : is this a natural behavior of SAP, or is there something that we are missing that causes the un-necessary files to be closed after the relevant requirements are fulfilled.

The problem with the huge number of files opened by a job is that the big number of file ODPs exhausts the memory extensively, the thing which causes the memory faults to be high, thus impacting negatively the system performance.

Thank you in advance for your cooperation.

Best regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Reda,

that is exactly working as designed ....

Yes, the memory utilization is not too low because of that but on the other hand, it would be very expensive to close and open over and over again ...

So, you have to deal with this somehow.

The following is the default setting, that is active on your site as well: (You should be able to see these values in the dev_w0 etc ...)

ODP Threshold:

dbs/db4/odp_threshold = 800

ODP Commit Threshold:

dbs/db4/odp_commit_threshold = 810

ODP Open Threshold:

dbs/db4/odp_open_threshold = 850

(This is true even when you experience 900-1200 - this is just a "mis-adding" more or less ...)

If you are really interested in: Try to change these parameters - but that is on your own risk, I do not have good experience with that ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

Answers (0)