serenity_now
member
Reged: 05/05/08
Last on: 08/27/10
Posts: 34
|
|
Hi All,
What does everyone do (if anything) to clear IPC Values on the iSeries server? We hadnt restarted or ended JDE services for quite a few months and one users were unable to submit jobs to the iSeries server. They were getting IPC values like the one below:
IPC2100009 - Krnl33466RspQ not created, unable to add resource name to hash table. Please increase the avgResourceNameLength parameter (current value 15) in the JDE.INI file.
I opened a case with Oracle, but they werent a lot of help, pretty much pointing me to a article that says not to change your JDE.ini file.
In this case ending JDE services and clearing IPC did the job. My question is, do people automate this somehow? Do you normally end JDE services once or twice a week and clear IPC? Also, is it true that JDE Services must be ended in order to clear the IPC?
Thanks for any input
--------------------
Oracle JD Edwards EnterpriseOne,
E8.12 8.97.2.5
Websphere 6 Win2K3.
Forms: Create!form Server 3/Server 6
|
CMDR_Dave
member
Reged: 05/12/08
Last on: 07/08/10
Posts: 21
Loc: Montana, USA
|
|
For me it's as simple as signing on to the iSeries as account ONEWORLD, then menu option 7 after services are stopped.
--------------------
David Chenault
CNC Administrator
E1 8.12 - TR 8.98.1.3 - OAS 10.1.3.4
AS400 V5R3 & V5R4
|
LennyM
member
Reged: 07/31/09
Last on: 03/11/10
Posts: 1
Loc: Woodside, NY
|
|
My question is, do people automate this somehow? Do you normally end JDE services once or twice a week and clear IPC?
We run a simple CL program every evening that ends services, clears the IPC, and restarts services.
|
nrferrie
member
Reged: 12/24/03
Last on: 08/11/10
Posts: 45
Loc: Richmond BC, Canada
|
|
On our iSeries we restart the JDE subsystems every night after End of Day processes. In our CL we clear IPC and delete all JDE related SQL packages.
--------------------
Nestor Ferrier
CNC Admin
EnterpriseOne 8.12
Tools 8.98.2.4
AS/400 V5R4
WAS 6.1 iSeries
|
serenity_now
member
Reged: 05/05/08
Last on: 08/27/10
Posts: 34
|
|
Quote:
For me it's as simple as signing on to the iSeries as account ONEWORLD, then menu option 7 after services are stopped.
Yea, I know I can do this. But how often do you stop services and do this?
--------------------
Oracle JD Edwards EnterpriseOne,
E8.12 8.97.2.5
Websphere 6 Win2K3.
Forms: Create!form Server 3/Server 6
|
serenity_now
member
Reged: 05/05/08
Last on: 08/27/10
Posts: 34
|
|
Does anyone have a sample CL Script that stops services, clears temp packages, clears IPC and starts services? Been looking around and kind find a lot.
Thanks
--------------------
Oracle JD Edwards EnterpriseOne,
E8.12 8.97.2.5
Websphere 6 Win2K3.
Forms: Create!form Server 3/Server 6
|
CMDR_Dave
member
Reged: 05/12/08
Last on: 07/08/10
Posts: 21
Loc: Montana, USA
|
|
Not often...so it's not that big a deal here. If you're looking for a more frequent occurance, you may consider scripting something...but it sounds like you may have to craft it yourself.
--------------------
David Chenault
CNC Administrator
E1 8.12 - TR 8.98.1.3 - OAS 10.1.3.4
AS400 V5R3 & V5R4
|
RandyMc
member
Reged: 01/27/10
Last on: 03/23/10
Posts: 3
|
|
Every night before our production backup we end our JDE subsystem and delete all JDE related SQL packages. Once the backup is complete we restart our JDE services. We use 3 different CL commands.
Here is what we use on our iSeries
PGM
CHGLIBL LIBL(B7334SYS QTEMP QGPL)
ENDNET
DLYJOB DLY(180)
CLRIPC
MONMSG MSGID(CPA0701 CPF9999) EXEC(GOTO END)
DLYJOB DLY(60)
END: RETURN
ENDPGM
PGM
GRTOBJAUT OBJ(B7334SYS/R*) OBJTYPE(*SQLPKG) USER(*PUBLIC) AUT(*ALL)
DLTSQLPKG SQLPKG(B7334SYS/R*)
END: RETURN
ENDPGM
PGM
STRNET
DLYJOB DLY(180)
END: RETURN
ENDPGM
|
ondeh
member
Reged: 12/22/05
Last on: 09/02/10
Posts: 24
|
|
Hi Randy,
Thank's for the script, my problem was the *SQLPKG was growing very fast (we're running under 8.12, V5R4, TR8.96) lately it was hit my 700G DASD very fast, 5% every three days. I did clean everything according to JDE standard (WRKOBJ *ALL/*ALL *SQLPKG) but the speed of growing was very fast. Any idea was it coming from?
Thank you.
|
SQLGAL
member
Reged: 03/23/04
Last on: 07/26/10
Posts: 84
Loc: Rochester, Minnesota USA
|
|
My best guess… you have some kind of leak in the query engine. Are you current on all of your database fixpacks?
A couple of expert webinars you should register for:
DB2 for i Autonomic Index Advice - Garbage or Gospel? – IBM’s Mike Cain
https://www1.gotomeeting.com/register/449917945
Accessing Non-Relational Data Using SQL – IBM’s Dan Cruikshank
https://www1.gotomeeting.com/register/379277369
And then there's the DASD issue. The easy way would be with a product...
http://www.s4isystems.com/products/s4idasdplus.html
More cowbell!!
|
Previous
Index
Next
Threaded
Clearing IPC on iSeries
Edit
Reply
Quote
Re: Clearing IPC on iSeries
