December 2019 Newsletter
As 2019 comes to a close, we wish to thank you for allowing iTech Solutions to be part of your team. We hope that our IBM i newsletters, Webinars, Customer Slack Channel, and Podcasts have been educational and informative for you, and that you have learned from them. We encourage and like to get feedback on what other things we can add to make them more helpful to our customers, and others who read them. Look for even more to come this year in 2020.
We have continued our growth this year adding additional employees to improve our services as well as the breadth of our IBM i offerings. We hope that you have a happy holiday season, with good health, happiness, and prosperity in the New Year. All of us at iTech thank you for your business, and for the confidence you have placed with us over the years. We look forward to working together in the coming year, and we will continue to strive to exceed your expectations. Whenever we don’t please reach out directly to me.
Remember the Christmas jingle:
The weather outside is frightful,
but working together with iTech Solutions can be so delightful.
Let it be IBM i, IBM i, IBM i.
Let us help you with all your IBM i needs next year. Now, sit back and chuckle as you read about how iTech Solutions helped Santa this Christmas :). We will be back in January with our normal IBM i System Administrator Technical Tips and Techniques.
All the best to you, your family, and your organization.
From all of us at iTech Solutions.
Just a few more days to shop, to work, and to wait for Christmas. I thought I would share a little story about how iTech Solutions helped Santa prepare for Christmas this year.
As many of our readers remember, Santa Claus and his operations at the North Pole are one of our prized customer accounts. We have been helping St. Nick administer his Power Systems since he was running on an AS/400 and our business partner relationship has encompassed many projects and all aspects of his IT infrastructure.
When we started supporting SLED (Santa Logistics/Enterprises Department), we were addressing issues as they impact business. Now that we have been working together for years, we anticipate needs and address them before Christmas needs saving. Stress levels are far lower at the North Pole and in appreciation, Santa sent me a bottle of Patron Tequila for my hot chocolate this year.
Managed Service Provider
Last year Santa decided to become an MSP customer. This refers to Managed Service Provider – we handle all of the facets of his IBM i on Power needs. PTFs, OS upgrades, backup, monitoring, recovery, replication. It is all the IBM i System Administration and infrastructure, basically everything except programming.
We have been meeting with him twice a month all year and we keep him updated on all our efforts. His elves come to Yvonne with requests for projects, their primary and secondary technicians as they need support and we all function as a team together. All of us secured our places on the Nice List, even the salespeople!
Chris keeps an eye on things and responds as needed 7 days a week. Amy implemented MIMIX and now Santa has the peace of mind that comes from knowing his complete system is replicated to his DR site on the South Pole as well as our highly secured Tier III Datacenter in our iInTheCloud environment for HA. Nate responsibly set up our system monitoring so there is nothing happening we can’t resolve in real-time as we are notified immediately. Steve performed a security assessment and we have been diligently addressing all areas identified as needing remediation. Mike keeps an eye on all things during the third shift, so that if something happens he is there in a flash to resolve it. Bill upgraded all his clients to Access Client Solutions, along with updating all his certifications. Just like the elves we work together and make magic happen! We even had an Elf on the Shelf in our Danbury Computer room, keeping an eye on some servers.
One thing Santa found very handy this year was his VERIFi reports. He said it was like turning one of his Elfs into an IBM i System administrator who gave him a report each week on the status of his systems. VERIFi is an iTech Solutions offering that will give you a weekly status report for all your IBM i partitions. With a single pane of glass, VERIFi covers processor and user license compliance, important dates like IBM End of Service for your machine, your partitions’ last SAVSYS and IPL, your PTF and OS currency, as well as a detailed statistics section of a last 7 days running to help identify potential problems before they start. It is a report that lets you know what is happening on your machine. See the sample report below.
2019 sure has been a year for Santa’s naughty list! And it isn’t surprising that Santa is concerned about security so we made that our highest priority. What a year we had covering all the ways systems can be exploited!
We started with user profiles and making sure the advanced authority was only in the hands of the elves that need it. Not long after, we found an internal threat from a disgruntled employee, luckily his access had been restricted and we were monitoring for probes so we were able to determine the perpetrator. That led us to be concerned about the naughty and nice lists and we implemented Row and Column Access control to block out everyone except Santa and Mrs. Claus. Of course, the internal threat made us start thinking about monitoring for unauthorized modifications so we implemented reviewing journal receivers and for added oversight, the Chief ELFormation Officer audits as well.
Then there is Wi-Fi access! That needed to be locked down so we hardened that pipeline like old fashioned Christmas Candy. Any hacker trying to break in is going to break a tooth instead. iTech learned more than a thing or two from knowing when one is sleeping versus awake and we developed a new product in response to this inspiration. In that way, Santa has given our customers a gift in what we will offer them in 2020! IBM i Security Monitoring, that will allow us to keep your system safe, secure, and be immediately notified when a threat is detected.
iTech Solutions was at the North Pole in September doing a few OS upgrades. Since Santa is on our OS Subscription Service, which gives him 1 OS upgrade and 3 PTF applications over a 24-month period. He thought the price of only $295 a month per partition was quite reasonable. Finally, an old application that was running on 7.2 with Java 6 was updated. We had been keeping an eye on this closely as IBM i 7.2 goes out of support on April 30, 2021 and if we didn’t get it done, his software maintenance on that machine would have doubled. We upgraded Santa’s POWER6 520, from 7.1 to 7.2 Technology Refresh 9 and one partition on his POWER8 that we upgraded from IBM i 7.2 to 7.4 TR 1. Santa Claus called iTech Solutions because he wanted someone with knowledge, experience, and know-how to do the operating system upgrades and he wanted the upgrades done right.
A New POWER9
Santa decided he deserved a Christmas present as well. A new Power9 to replace the POWER7 was his choice. We brought in a new POWER9 S914 8-Core machine to give Santa more performance as he had hit the limit on that old machine. We worked closely with his team to design exactly what they needed including SSDs, more CPW per core, new PCIe adapter cards, extremely fast internal disk controllers, and more. Even better, he received a new machine with 20x the performance of his existing machine for the same price he was paying on three years of maintenance! This reduced his 10-hour jobs at night to just minutes. More time for him to spend with Mrs. Claus.
Santa said to me, “I can’t believe how smooth the migration went. Yesterday we were on the old POWER7 machine, and today we are on the new POWER9 machine. Everything is there and working, with the only difference being the speed. This has been the best migration ever, I am glad I chose iTech Solutions”.
iTech Solutions Upgrade Assurance
Of course, SLED at the North Pole can’t afford any downtime so Santa uses the iTech Solutions Upgrade Assurance program, which is where we bring one of our machines up to the North Pole. We restored the XMAS-01 partition running 7.2 to the iTech machine and upgraded that to 7.4. This way all the applications were tested and once we ensured all was proper then we performed the work on Santa’s machine getting XMAS-01 to 7.4. Santa knows that there is no need to worry when he has iTech keeping his systems in tip-top shape.
After one of our monthly MSP meetings over the summer, Santa had the elves bring us some hot chocolate, I asked if he could put a double shot of tequila in mine. He raised an eyebrow, and asked “If I wanted to be put back on the naughty list”. I replied back, “extra whip cream will be fine”. He smiled back, but then said he had another problem. He told me that he was always wishing he could go back in time, and run a query as if it was few months earlier. I looked at him with a smile and said, “Do you wish you could be querying the files as if it was the middle of June, even though today is Dec 19th”.
This was exactly what he needed as the elves are constantly doing restores of previous year’s gift and naughty/nice files to accomplish this task. Now, as we had implemented BRMS for Santa a few years ago doing the restores wasn’t too difficult, however, 7.3 makes it even easier to query the data! I explained Temporal Support, which at first he thought was the yummy fried coating we had on those shrimp at the Japanese restaurant. No, no, no, that is Tempura, this is Temporal, which means time. It’s like going back in history and seeing the data in the files, exactly how it existed on any particular day and time. Santa said that he could use this function to keep track of the many lists he has without having to constantly make copies of files to then be queried later. He sure has embraced the value of modernizing his IT!
It wouldn’t surprise anyone to know that it is a mighty big database residing in DB2. Keeping track of every child in the world is quite the task and without the reliability of IBM i Santa would be struggling. The Power infrastructure ensures that his database files interact seamlessly with a variety of applications. First, there is his ERP package for all the sourcing from vendors for materials to make the toys. Then there is the reverse packing distribution system that ensures all the gifts are put on the sleigh in the exact opposite order as they will be delivered. Another benefit of using 7.4 is running old queries using Query/400 & OPNQRYF under SQE vs CQE resulting in his queries to run in almost 1/2 the time. I love it when the fat guy has that jolly old belly laugh.
WebSphere Application Server
Of course, he takes good care of all his employees so his reindeer health application is important. This runs in WebSphere Application Server which Steve upgraded to WebSphere 22.214.171.124. His weather application lets him know where the sleigh might catch some air turbulence runs on JAVA so we updated that to Java 8. Most of the Elves love running green screen applications for the speed, we talked about enhancing some of those applications with a GUI interface using RPG Open Access. This is going to let him extend his RPG applications with accessibility for iPhone & iPad Air devices. Mobile applications are a must from the sleigh and Santa needs to keep in constant communications with the North Pole on Dec 24th. He was so happy when iTech used IBM i 7.4 to run iAccess Mobile to display directly to the mobile devices on the sleigh.
PHP, Ruby, Node.js, and Python
Another advantage of becoming an MSP customer is we meet monthly all year round, not just when there is a large-scale project needed. This allows us to take advantage of slower times to implement strategic initiatives. The younger elves are getting excited about website development with Ruby and using Python to take advantage of community-based software development model to reduce overhead. However, other elves want Node.js for developing server-side web applications. Santa was concerned about the cost of managing more machines to host all these languages. I was able to tell him he could relax and not to worry, iTech Solutions has your back. We can install all those languages on your IBM i. At first, he thought I had been nipping on the eggnog as this seemed too good to be true. However, true to my promise to stay off the naughty list that wasn’t the case. IBM i now runs all these open source languages like PHP, Ruby, Node.js, Python, Java, and PHP natively. He was amazed.
Leveraging Investment in IBM i
When Santa first engaged with us, we started with some performance tuning on the machines at the North Pole. He had purchased a used machine from another business partner to save money, who unfortunately didn’t understand logical partitions, and had the processors dedicated to the partitions. Santa told me in retrospect, that machine cost him more money in the long run and should have gone with our proposal in the first place. We fixed this machine to use shared processor pools. So, on Christmas Eve when the production partition XMAS-01 was running at 100%, the other partitions on the machine were completely idle. Now using shared processors and uncapped partitions on his machine, and the XMAS-01 partition was now running at 350%, and the work was flying through. Santa said he was able to save an upgrade and spend that money on additional toys for girls and boys throughout the world, all because in his words “iTech Solutions understands how to leverage my investment in IBM i to get the most out of the machine. No one else has the knowledge to get my machine running as iTech Solutions”. Thanks for the kind words, Santa.
I’m sure the elves still haven’t changed their code from a long time ago; even though iTech told Santa it’s time to modernize when we were there last year. Those Elves are slowing down one of the POWER8 S814 servers with all of those OPNQRYF’s on the toy list and nice list too. They never did want to change over and learn SQL. They are starting to after we gave them a demo of how easy it is to use SQL, and the speed of the queries. Next, with free-format RPG and new RDi version 9, even the elves, maybe Mrs. Claus, are making minor changes and efficient rewrites on the legacy RPG code with ease. I think right after Christmas, it will be time to relook at his overall machine strategy. We offer our customers our review and assessment to validate the resources and requirements on their machines. I remember it was just two years ago, we reviewed a machine that had spinning disks and easily changed those to SSDs and that made such a difference. If you need a review of your machines, contact us here.
IBM i Performance
Santa was telling me that we still needed better performance on his Power9 S914 that we installed two years ago. He was saying that as the population of the world increases, the sizes of his files were just getting huge. Some of his jobs were running all night. We looked at the performance of the machine and discovered the amount of I/O on that machine had grown extremely high. So, we installed some new PCIe 12GB Cache Raid SAS adapter Quad-port 6GB Disk Controllers with some solid state drives (SSDs). Wow, did that do the trick. Those same jobs which were so I/O intensive ran very quickly with the new large cache disk controllers and the solid state drives. This really made a difference in the performance of the machine and allowed the mapping software which determines the route that Santa is to take on Christmas Eve, stopping at every house to drop off the presents to run in just an hour compared to days. If your system seems to not be running how you want, why not have iTech Solutions come in and do a performance review?
Our next performance issue had to do with some ODBC jobs & Queries that the Elves had created out in the shop. The elves have created more queries than you can imagine. Every time they ran these ODBC jobs and Queries, the system would just grind to a halt. iTech Solutions ran the Index Advisor, and determined that a couple of indexes (logical files) needed to be created over the toy file. With a mouse click, we created the required logical files for Santa. Now those jobs the elves were running are done in a snap. Santa said “It was like a new machine, having iTech Solutions come in for the day and investigate the system”. We performed our standard Health Check. Perhaps this is something you might want to put on your list for Christmas or even next year?
During my visit, I was in the office next to the computer room at the North Pole, when out in the computer room there arose such a clatter,
I sprang from my desk to see what was the matter.
Away from my Windows10 laptop I flew like a flash,
Tore up the ramp and threw open the sash.
And what to my wondering eyes did appear,
but a miniature sleigh filled with hundreds of tapes, and eight tiny reindeer;
With a little old driver, so lively and quick,
I knew in a moment it must be Saint Nick.
Disaster Recovery and Backup
I said “Santa, what is going on?” Santa said “We are all going to do our DR test, and we had to get all the tapes for our IBM i restoration”. I said, “Santa we spoke about this during the summer, why not just replicate to one of our IBM i cloud (Power Systems) machines at iTech Solutions, and then not only would you have a Hot Site available all the time, if you had a real disaster your DR machine would be immediately available and you wouldn’t be stumbling with all these tapes. Remember we were talking about this whole Cloud Computing concept with the Easter Bunny, and you thought he had been drinking a little too much carrot juice.”
Cloud Computing is not computers in the clouds, it’s a service that iTech Solutions offers that allows you to host your IBM i machines at our locations or even just use one of our machines and carve out a virtual logical partition. Santa said, “he had a lot on his mind at the time as the elves had to do the systems management of his current machine as he couldn’t find any good system admins in the North Pole.” We agreed to look into hosting his replication with iTech Solutions in January. I said to Santa, you know while we are at it, you should really look at either our Cloud-based backup solution, where you back your data directly up to our cloud, fully encrypted and compressed. Your backup is immediately available off-site, and you can rest assured that the data is fully encrypted. In addition, we can always put a virtual backup appliance in the data center, and perform backups to the Virtual Tape Library so that you aren’t handing tapes. Santa was interested in further looking at both solutions. Are you still playing with tapes? Think about that for the New Year.
Next, I asked Santa if there was anything else on his list? He said, “there were three more things. First, he said, Mrs. Claus gets so annoyed at him every month when he has to go into the office to do a Full System Backup”. I looked at Santa, and said to him, “I have been asking you for years to get rid of that Twin-ax Console on the POWER6 and upgrade to Operations LAN Console. You kept telling me that you liked Twin-ax. I said last quarter when we were doing the iTech Solutions quarterly PTF maintenance to bring all your PTFs up to date, that I could hardly see that screen, as that twin-ax device is so old on that one Power6 machine. If you had Operations LAN console, you, iTech Solutions, or any of the elves could remotely connect from home via VPN right to the console, and do the backup without having to come into the office”. iTech Solutions installed and configured Operations LAN Console, so that Santa could spend a little more quality time with Mrs. Claus. Mrs. Claus was so happy she told Santa to put everyone at iTech Solutions on the Nice list, no matter what. Whew, that was certainly lucky for me.
Secondly, he said “from time to time the elves are developing new modules and programs and it would be nice if he could get them off the production XMAS01 machine”. I said, “well that isn’t a problem, let’s create a virtual partition on that new POWER9 S914 machine, and put the development environment on that partition”. He asked, how could we do that? I said, “remember when we brought that new POWER9 machine in, now that we are running IBM i 7.4 we can do more virtualization and create virtual partitions”. Santa said to me, “but I only have one pair of disk controllers on XMAS01”. I said, “No problem, we are going to virtualize the disks and DVD drive, and then share the SAS tape drive between partitions. Since we have an HMC, we won’t need any additional hardware on your machine”. I told him that iTech Solutions can do this in one day for him. Santa was like a little kid at Christmas, and said “well that is another thing I want from iTech Solutions”.
Thirdly, he asked if there was anything we could do, as IBM had assigned him fifteen different customer numbers for the North Pole, each reindeer had their own IBM customer number, and a few of the elves had IBM customer numbers as well. Santa said, “it was confusing when we have to call IBM, and they ask us for a customer number, I don’t know which one to give him.” I laughed, and said “sorry, even iTech Solutions can’t help untangle IBM customer numbers”. I think you could hear his belly laugh all the way down at the South Pole.
We were just about at the end of the day, and it was so quiet in the computer room, not a creature was stirring, not even a mouse. Santa whispered in my ear, that he was so happy to have iTech Solutions on his team, that he was making sure we were all on the Nice list. I in turn asked Santa, “What are the people on the Naughty List getting for Christmas besides Coal?”. He said, “because they have been so bad, I am giving them Windows Servers. After all the crashes, problems, and headaches they will have with those Windows Servers, they will think twice about being naughty again.” I nodded my head in agreement.
Then Santa said, “you know the last time you were here you told me that I should backup the system and move my tapes to the South Pole. Well, I am a little concerned that if we lost our tapes, then everyone would know who is on the Naughty and Nice list.” I said, not to worry, you have two options. We can do software encryption with BRMS, or we can do Hardware Encryption with that fancy new Fibre attached LTO-6 tape drive we installed last spring, or the SAS attached LTO-7 tape drive on the new S914. I could see Santa was very happy as there was a sparkle in his eye. We planned to do the hardware based Tape Encryption using SKLM (TKLM) in February. If your tapes are not encrypted what would happen if you lost a tape? Who would have your data? Let iTech Solutions Encrypt your tapes.
As we wrapped up our year with our last monthly MSP meeting we looked over all the projects we completed this year. Santa reported that his elves had so much more time to implement new applications in modern languages as iTech handles all the system administration needed for his IBM i OS and Power hardware. Further, he has the peace of mind that comes from partnering with a trusted team of highly competent specialists. We are excited to look to what we will accomplish together in 2020!
If Santa wants iTech Solutions for his support, then shouldn’t you?
So, I am glad to report that iTech Solutions is what Santa wants for Christmas.