Journaling a Physical File on IBM iSeries Using STRJRNPF
Filed under: EnterpriseOne - General, IBM i/System i/iSeries/AS400, JDBC, JDBJ, Java, enterpriseone
We have a system that needs to interface directly with some EnterpriseOne Files. This system is written in Java and seems to be very difficult to change any JDBC settings to not use commitment control.
Anyway, to get around this issue, we started journaling the physical file that the JDBC command was trying to update using the following command:
STRJRNPF FILE(PRODDTA/F0911) JRN(OWJRNL/OW_JRNL)Tags: enterpriseone, enterpriseone, EnterpriseOne - General, ibm, IBM i/System i/iSeries/AS400, iseries, Java, JDBC, JDBC, JDBJ, system i
EnterpriseOne Tools Release Upgrade From 8.96 to 8.97 Rough Outline
Filed under: EnterpriseOne - General, EnterpriseOne - Install/Upgrade, EnterpriseOne - JAS (Java Application Server), IBM i/System i/iSeries/AS400, Oracle Server Manager, enterpriseone, oracle, websphere
- IBM iSeries/AS400/System i
- Backup libraries and IFS directories
- Register Pristine Environment in Server Manager
- Create Server Manager Server Group for Pristine
- Upgrade Pristine
- Web Server
- Create IBM WebSphere Application Server in Server Manager
- Create IBM HTTP Server in Server Manager
- General
- HTML landing page: update links and info
- Change DNS entries
- Copy the code used to restrict access to specified environment
- Copy images and code for custom backgrounds
- Modify the JAS.INI file to specify the correct logon logo
- Set web server to restart nightly and cleanup logs
- Verify that the server is being backed up and replicated to DR hot site
Clean Up Your Web-Only Versions
Filed under: EnterpriseOne - SQLs, IBM i/System i/iSeries/AS400, enterpriseone
We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed.
We have processes in place for them to submit new versions to our development teams, but sometimes things don’t happen the way they are designed.
Anyway, I was doing some checking and noticed that there were quite a few versions in the F983051 that were web-only versions and were older than the last full build.
So, I created an SQL that we are going to run immediately after the deployment of a new full package.
DELETE FROM <central objects>/F983051 WHERE VRVCC2='1'
***NOTE: the syntax used in the SQL statement is for the IBM System i (as400, iSeries)
The LINKBSFN Command Confusion
I don’t know about you, but I can never remember what the correct parameters are for the LINKBSFN command that is required when doing Tools Release updates on an IBM iSeries (i, System i, AS400).
So, just to make it easier on myself, here they are:
LINKBSFN PARENT(PACKAGELIB) PATHCODE(PATHCODE)
EnterpriseOne 8.97 Install Host Table Hic-Up
Filed under: EnterpriseOne - Install/Upgrade, IBM i/System i/iSeries/AS400, Microsoft
While installing EnterpriseOne 8.97 on one of our instances, we ran across an issue that was pretty puzzling to both us and Oracle’s Global Support Services group.
We had successfully installed both the Server Manager Console and the Enterprise Server (System i, iSeries, AS/400) Management Agent. When everything is working correctly, the Enterprise Server Management Agent is supposed to ping the Server Manager Console and magically show up in the Server Manager Console Dashboard.
Well, as you have probably guessed, our Enterprise Server Management Agent did not "magically" appear. After sending Oracle several sets of logs and screen shots, I noticed something in the Server Manager Console logs:
Oct 27, 2008 12:33:23 PM com.jdedwards.mgmt.agent.Server$ClientConnection register FINER: Received heartbeat from the remote management agent on DOMAIN.COM listening on port -1 of type 2 in managed home /JDEdwards/JDE_HOME
You’ll notice from the log excerpt above that the ping from the Enterprise Server Agent was successful, but the name of the device from which it is running is identified as "DOMAIN.COM". Obviously, I changed the name to protect the guilty, but I thought it was really strange to not have a MachineName specified.
So, we inspected the host table of the Enterprise Server using CFGTCP and found that there really was an entry with just "DOMAIN.COM". However, there were also 2 other entries for its IP address:
255.255.255.111 MACHINENAME DOMAIN.COM MACHINENAME.DOMAIN.COM
We weren’t really sure what we might screw-up if we removed the "DOMAIN.COM" entry so we just moved the "MACHINENAME.DOMAIN.COM" entry up in the list.
255.255.255.111 MACHINENAME MACHINENAME.DOMAIN.COM DOMAIN.COM
Before we even had a chance to logout of the Server Manager Console, the Enterprise Server magically appeared on the dashboard.
What should you learn from this? Clean up your host table!
Have you tried to install Oracle Server Manager? If so, how did it go? If not, what are you waiting for?
How To Throttle The Job Queue
NOTE: The following is intended for use on the IBM System i (iSeries,AS400, etc.)
CHGJOBQE SBSD(QBATCH) JOBQ(JDEOWPACK) MAXACT(2)
Explanation:
CHGJOBQE- Change Job Queue Entry
SBSD- Subsystem Description
JOBQ- Job Queue
MAXACT- Maximum Active Jobs
Tags: as/400, ibm, IBM i/System i/iSeries/AS400, iseries, jde, system iAdvertising
Would you like to advertise in a very focused niche market?
This site caters to the needs of System Administrators of Oracle’s JD Edwards EnterpriseOne (E1) ERP System. In our particular specialty of the Information Technology industry we are called CNC Admins. The “CNC” portion refers to the E1 infrastructure: Configurable Network Computing. As the name implies, the E1 infrastructure is very configurable. It can be set up using combinations of the following technologies and platforms:
- Microsoft Windows Server
- IBM i (AS/400, iSeries, System i)
- Linux
- Microsoft SQL Server
- Oracle Database
- IBM DB2
- etc.
The typical CNC Admin is efficient, innovative, detail oriented, hard working and takes strong ownership of the systems in which they are involved.
Marketing to this group of professionals is challenging, yet rewarding. There are few resources outside of the walls of Oracle that contain useful information. So, there are few opportunities to present helpful products to this group other than renting space at expensive conferences like Oracle Openworld or Quest Collaborate.
If you would like to discuss the possibility of marketing to this highly respected group of IT professionals, please fill out the form below.
Tags: as/400, cnc, e1, enterpriseone, ibm, iseries, jd edwards, linux, oracle, sql, system i, Uncategorized, worldCNC Certification and Consulting
If you pay attention to threads on JDEList, every once in a while someone will inquire about the availability of CNC Certification. Usually, these inquiries are met with the an answer generally like:
No, there are no "official" certifications.
The latest inquiry was from Spider006. Essentially, he just wanted to know what some good "supporting" certifications for a CNC Administrator. He got some good advice from CNC Monkey 5000 about looking at possible certifications in Oracle Application Server and supported databases. I would also add certifications in EnterpriseOne supported operating systems. The more you know about what EnterpriseOne runs on the better.
Then, along comes serious 09. He had only been a member of JDEList for 4 days when he posted about his eligibility to have the title "Technical Consultant" after taking the EnterpriseOne CNC Administrator classes available through Oracle University.
This was followed, very appropriately, by a comment by Gregg Larkin:
With all due respect, you will need more than just training to be a JDE technical consultant. This application also requires a great deal of experience to earn that title. As for certification, there is no formal program or certification process. Take the classes, get four or five years of experience under your belt, and then we will welcome you to the club. Good luck on your new career.
As you can see, Gregg took it a little further. Now, Gregg is a very respected, experienced & active CNC Administrator. He provides invaluable insight in both his articles for JDETips and in discussions on JDEList.
I think his comment was perfect. The work of a CNC Admin is primarily learned through experience. I don’t know about you, but when I went through the CNC Foundation class I was so confused by Pathcode, Environment, JDBNet & OCM that I didn’t know how I was ever going to figure this thing out. I also had zero experience with J.D. Edwards World or an IBM AS/400 (iSeries, System i, i). It wasn’t until we went through our implementation using consultants that I started to get a handle on things. I spent about 10 hours a day for 3 months working side by side with just the CNC side of things. Yeah, that’s one hell of long time to do an implementation but we didn’t know that at the time.
Unfortunately, I’m afraid that serious 09′s issue isn’t whether he has the motivation or ability to become a great CNC Admin. It’s that the organization that he works for thinks that after he has completed the classes they can call him a Technical Consultant and charge top dollar for your services. In doing so, it gives the consultant industry as a whole a tarnished image. There are many excellent consultants and consultant companies, but there are also many that take advantage of organizations with with the desire to "do things right and hire experts".
Good luck to both Spider006 and serious 09 and Gregg, keep up the good work!
Tags: as/400, cnc, e1, enterpriseone, EnterpriseOne - General, ibm, iseries, jde, OCM, oracle, oracle application server, system i, world
The IBM iSeries (System i) JDK Juggle
Filed under: EnterpriseOne - Install/Upgrade, IBM i/System i/iSeries/AS400
While installing the Oracle Server Manager agent, we learned some interesting little Java tricks on the IBM iSeries. They probably work on all platforms, but I don’t know for sure and I’m not going to take the time to test. Also, these tips are for OS400 V5R4.
- How do you know which version of JDK is your systems default?
-
runjva class(*VERSION)
-
- If you have more than one JDK installed, how can you force it to run a certain version?
-
runjva class(*VERSION) prop((java.version 1.5))
-
These couple little tricks may seem pretty simple to you. However, for someone without Java experience, especially on the iSeries, they can be very helpful.
E1 Admins Need To Know Everything About Everything
Filed under: EnterpriseOne - General, EnterpriseOne - Install/Upgrade, EnterpriseOne - JAS (Java Application Server)
I admit that I am a "Jack of all trades, master of none". Which can be a good thing as in the second paragraph of the Wikipedia entry.
A Jack of all trades may also be a master of integration, as the individual knows enough from many learned trades and skills to be able to bring their disciplines together in a practical manner.
Ok, I’m getting a little off track.
With that said, I don’t think that any EnterpriseOne CNC Admin can be a master at everything. That may be a little strong, but unless E1 is your only responsibility and you have very little changes to make, knowing everything about everything that touches your EnterpriseOne system is an extremely difficult pursuit.
In our staff of 30 or so, I feel that I am one of a few that have a pretty extensive background in a wide variety of information technology related subjects. However, yesterday, my "master of none" was exposed.
We are running tools release 8.96.1.5. This release uses IBM’s HTTP Server, which is IBM’s slightly modified Apache HTTP Server 2.0. Although I’ve worked on many different systems, I’ve never had the privilege of administering a mission critical Apache HTTP Server until we started using it for E1 and even then it always… just ran. I never really had to do anything with it besides the httpd.conf modifications required by E1, which are specified very simply in the EnterpriseOne documentation.
Well, yesterday, we had users calling saying that they "couldn’t view PDFs". We were receiving IBM Websphere logs that indicated that the system was unable to write to the /temp directory. Well, the reason for this message was found when one of my colleagues logged-on to the server and noticed the pop-up that said the "E:" drive was out of space.
Now, we know what was going on, but why? There is usually about 10GB of free space on that drive. What could have taken it all. Granted, I haven’t looked in quite a while, but nothing else runs on that box, but the E1 web client.
After a little bit of head-scratching, we found that the culprit was a log file. The Apache access log file. Unknown to me or my non-Apache admin colleagues, the Apache access logs are set to not truncate automatically. In other words, they build and build and build until you have no more disk left.
Fortunately, I was able to find a way to create a new log file after either an amount of time or when the a specified file size is reached. It uses the rotatelogs application that ships with Apache and is configured within the httpd.conf file.
Essentially, you send all Apache access logging through the rotatelogs application which then writes the log to your specified location. This is called "Piped Logging". Here is the basic syntax:
rotatelogs [ -l ] logfile [ rotationtime [ offset ]] | [ filesizeM ]
And this is what I am using:
CustomLog "|bin/rotatelogs.exe logs/access_%Y%m%d_%H%M%S.log 3600" common
This configuration forces a new log file to get created every hour (3600 seconds).
Another benefit to using piped logging is that the log files are not locked by the Apache.exe process. This allows the ability to delete the current log file.
Unfortunately, I have been unable to find a way to delete old files within Apache. I may have to resort to some bat file or VBScript for that.
Tags: cnc, e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - Install/Upgrade, EnterpriseOne - JAS (Java Application Server), ibm, oracle, system i, Tools Release, websphere, xe
