JDE.ini tuning, IPC reccomended settings?

serenity_now

Active Member
Hi,

We are having issues where every few weeks our JDE will essentially crash. We are running on a iSeries and the logs seem to indicate IPC errors.

We shut down the system and clear IPC every Saturday night, and the few times this crash has happened it has been on a later on in the week usually a Friday. However, recently it happened as early as Monday.

Essentially what happens is when users try to submit a report they get the error that the UBE cant be submitted, and I see errors in the log like :

57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005240 queueapi.c597
QUEUE05300060-Failed 11 to ReceiveMsg 4524 from SERVER

57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005512 queueapi.c1276
QUEUE06000030-System failed to change 4524 job SERVER____143977

56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.550528 jtp_cm.c1004
JDB9909007 - Unable to obtain driver request handle

56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.623048 dbdrv_log.c196
OS400QL017 - PrepareAndOrDescribe:prepare failed. QSQLMSG *LIBL - SQL0204 - &1 in &2 type *&3 not found

The only way to fix it is to end services. I am unsure of what the exact culprit is, however most things I have found from Oracle point to IPC. Though I have read most of what Oracle has to offer for tuning, yet still have the issue.

The IPC portion of JDE.ini looks as follows;
[JDEIPC]
maxNumberOfResources=2000
maxNumberOfSemaphores=1000
startIPCKeyValue=2101
avgResourceNameLength=15
maxMsgqEntries=1024
maxMsgqBytes=65536
ipcTrace=0

We have less than 50 or 60 people that are ever on the system, frankly the iSeries we have is overkill for the amount of users.

Does anyone have experience with IPC issues like this in the past?
 
FWIW,

We tend to stay up for months at a time, we added 500 to the ipc value (making it 2500) because we too ran out. Some tools releases seem to have an IPC leak somewhere.

Tom Davidson
 
Have you checked if you are up to date with PTFs on your iSeries?

Following are Informational APARs for E1 on iSeries.
V5R4M0 - II14151
V6R1M0 - II14331
V7R1M0 - II14493
 
Is anyone able to share the IPC portion of their JDE.ini for comparison and how many users use the system? As I say, our system is used by less than 70 users at a time, I imagine there are people out with 3 or 4 times that load.

JDE support has provided me with the formula:
maxNumberOfResources = no. of Queues + no. of Semaphores + no. of Shared memory segments + no. of Mutexes

However, I am having some difficulty trying to figure it all out.
 
Late response, since I found this thread while looking for tuning info. The following Oracle doc has a more complete description of the previous equation:

E1: KER: JDE.INI Tuning & Recommended JDE.INI Settings (From Development) [ID 654975.1]
 
Back
Top