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
- 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.
Do You Know i?
IBM… what’s with all the name changes?
I am relatively new to the IBM AS/400. Yes, I’ve been working with it for the last 7 years or so, but IBM first introduced them in 1988 …20 years ago!
Anyway, it seems that in the last few years IBM has been trying to shed the original "AS/400" name. They’ve tried things like "iSeries", "System i" and now IBM has combined two of their offerings into a single server line called "Power Systems".
Ok, so the name has changed again. It really doesn’t matter. Every user of the system that I know still calls it the "AS/400" or simply the "400".
Andrews Consulting Group has a great rundown on what this all means for Oracle EnterpiseOne ERP customers on their blog.
BTW, here is a neat little quiz about the history of the AS/400 on Search400.com (caution it is dated 2003).
Tags: as/400, e1, ibm, IBM i/System i/iSeries/AS400, iseries, jd edwards, oracle, system i
