Oracle JDE EnterpriseOne and MTXW HELL!
Read Time:32 Sec
Ok, so this has come up before, but it’s been awhile and I totally forgot about it.
After an update package deployment, when a user tried to login many of the iSeries jobs went in to a MTXW (mutex wait) state. So, we bounced services. Nothing. Then, we brought all services down and deleted all SQLPKGs (SQL Packages) that were owned by ONEWORLD. Nothing. Then, after much frustration I deleted the following files from the IFS system:
- dddict.ddb
- dddict.xdb
- ddtext.ddb
- ddtext.xdb
- glbltbl.ddb
- glbltbl.xdb
These files get re-generated on-the-fly.
What ever was corrupt was in these files.
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Hi Stewart.
Where do I find these files? Were they local to your system or are they a part of IBM package?
Thank you.
The files are in the IFS on the iSeries in the “specfile” directory in the “pathcode” directory.
/root/DV910/specfile
/root/PY910/specfile
/root/PD910/specfile
Hope that helps!
Any idea what causes the spec files to become corrupt? We just had this happen last week and after clearing the spec files, the issue was resolved.
Great question, John! And boy do I with I knew the answer. Sorry, your guess is as good as mine.