It’s not always easy to locate the official documentation for all features of DB2 for IBM i. Using Google Search is hit or miss, with full-text searches often bringing irrelevant results from other varieties of DB2 or from older versions. Many people don’t know that complete reference manuals are available for almost every aspect of DB2 on i.
IBM i computer, formerly named AS/400, iSeries, i5
It’s getting easier and easier to do. An IBM i Service using DB2 and SQL provides the TR level more cleanly than older approaches. I love that we can use the universal SQL to expose the innards of our beloved system!
The Seiden Group team is headed to Orlando May 6-10 to participate in COMMON 2017. In addition to teaching sessions and workshops on best practices for using PHP and other open source technologies on IBM i, we’re looking forward to meeting up with our clients and friends.
One of our favorite opportunities at COMMON is to meet professionals at all levels of the IT organization. Understanding the challenges faced by each member of the IT team — from admin to CIO — strengthens our ability to build effective solutions that are easy to use, easy to extend, easy to maintain.
In just two weeks I’ll have the pleasure of joining some of the top IBM i development experts in Orlando for the RPG & DB2 Summit. Run by Susan Gantner, Jon Paris and Paul Tuohy, this conference is full of big personalities who create a warm, friendly environment that’s perfect for learning.
I enjoy the community feeling and how excited everyone is to solve development problems and share tips and techniques.
The RPG & DB2 Summit is one of the few training events that focuses exclusively on topics of interest to IBM i developers. That includes PHP and SQL, of course!
Check out the session grid and pay special attention to the Hands-on PHP Workshop on Monday, March 20, followed by several PHP and open source sessions given by yours truly and Zend’s Mike Pavlak, plus a whole array of SQL sessions. And maybe a few on RPG.
I think they should change the name of the conference to the RPG, PHP, SQL & DB2 Summit, don’t you?
Come join us!
I was thrilled yesterday to see the familiar face of Seiden Group’s own Stephanie Rabbani smiling up at me from IBM i’s Home page, next to our friend and Club Seiden colleague Liam Allan.
Both are currently featured by IBM as “Fresh Faces of IBM i” along with Kody Robinson of Arkansas Electric Cooperative Corporation — just a few of the outstanding young professionals on our platform.
This honor calls attention to what I know of Stephanie first-hand from working side-by-side with her on Seiden Group consulting projects. With 14 years experience on the IBM i, she is versatile, resourceful, and personable, with skills in PHP, RPG, WebSmart, and more. And she strongly advocates the continued use of IBM i as the best business platform. Well done, Steph!
Liam Allan is another impressive young developer. At just 19 years old, he earned the 2016 COMMON Student Innovation Award and quickly found himself at home on the speaking circuit with audiences eager to learn his techniques. He could program in any language but has chosen primarily to advance the art of RPG. I’m looking forward to seeing him again in March, when we both travel to Orlando to speak at the RPG & DB2 Summit. Go Liam!
But these “Fresh Faces” represent something bigger than individual excellence. To all of us with valuable business assets on the IBM i, they are visible evidence that we are beginning to succeed in attracting young talent to the platform. I see other such evidence in my work as a consultant, in my sessions at conferences, in the classroom when I train.
So thank you, IBM! Your efforts to modernize the IBM i development environment are paying off.
And thank you to all of the seasoned developers who have moved to RSE and free format RPG, who have led their organizations to rewrite or extend their applications using ILE, SQL, new DB2 techniques…and, my favorite of course, PHP.
With efforts to make IBM i code more broadly accessible, coupled with talented young developers who are interested in working on the IBM i, the future of our data and business logic looks brighter than it has in years.
You can personally be a part of IBM i’s revitalization. Adopt modern development techniques. Mentor a younger developer. Continually learn new skills. Ask for help when you need it.
If you’d like to discuss what Steph and the whole Seiden Group can help you accomplish, send us a note.
Congratulations to Steph, Liam and Kody!
The support team at Zend has written a knowledge base of tips for configuring and administering Zend Server for IBM i. The tips, written chiefly by Rod Flohr, are accurate and thorough. Recommended is the site’s option to notify registered users when new articles are posted. URL: https://support.zend.com/hc/en-us/sections/200554323-Zend-Server-for-IBM-i
The 2015 COMMON annual meeting and expo, now in its first day, is helping speakers and attendees create innovation through IBM i integration: open source, closed source, IBM and vendor solutions. For example, of my six presentations during this conference, two are collaborations:
The Art of Performance Diagnostics, with IBM’s Dawn May, allows us to show, among other topics, how IBM i’s integrated performance tools complement green-screen tools and third-party tools (in this case, Zend Server) to pinpoint and solve performance issues (here, PHP-and DB2-based applications).
PHP Tricks for RPG Developers, a talk jointly created by RPG and SQL expert Birgitta Hauser and me, combines RPG, PHP, and DB2, allowing RPG to achieve graphical (charts and graphs, PDF and Excel files) and internet (json-based web services, flexible email) functionality using native functions.
Conferences such as COMMON serve a need that’s difficult to replicate back at the office—brainstorming and sharing possibilities among interdisciplinary peers, or sitting side-by-side with like-minded colleagues who work for different employers, to try something new. This week, for example, some of us plan to share knowledge on compiling binaries in PASE and to further the potential of open source on IBM i. I’m looking forward to presenting my talks (both joint and solo) and helping to realize new ideas with forward-looking colleagues during the conference.
Rational Developer for i (RDi), the modern editor for IBM i RPG, COBOL and other languages, runs on Windows and Linux, but not Mac.
IBM has shown some willingness to port the product to Mac. They have posted a poll to allow users to vote for this enhancement or to comment on the proposal: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=13454
Those wishing to vote will find a “vote” link near the bottom of the poll page.
By default, IBM i’s Secure Shell (SSH) rejects connection attempts from user profiles longer than eight (8) characters. When long user profiles are rejected, error messages will vary, but users of Zend Studio, for example, will see “Failed to connect sshd on “<some ip address>.”
Since IBM i release 6.1, IBM i has supported an SSH setting, ibmpaseforienv PASE_USRGRP_LIMITED=N, to permit user profiles longer than 8 characters. IBM i 7.2 brought improved support for this capability.
- IBM i 6.1 and 7.1 require a PTF and the new setting.
- IBM i 7.2 and higher require only the setting.
For details, see Zend Support specialist Rod Flohr’s article about how to remove the 8-character limit on user profiles when connecting via SSH.
(Dec. 3, 2017) Update for IBM i 7.3 and beyond: The path of sshd_config remains /QOpenSys/QIBM/UserData/SC1/OpenSSH/etc, unchanged from the IBM i 7.2 path in Rod’s article.
Starting January 27, 2015, I’ll be giving three free Tuesday webinars:
- January 27: Strategic Modernization with PHP
- February 17: Bring RPG/COBOL business logic to the web with the PHP Toolkit
- March 10: Speedy PHP on IBM i
All three one-hour webinars will be held at 14:00 Central European Time (CET). That’s 8 AM Eastern Standard Time (EST). The registration page includes a time zone converter.
Details and to register: http://www.data3.se/?p=5287
Thanks to Torbjörn Appehl of Data3 (COMMON Sweden) for organizing these.