Where to find DB2 for IBM i documentation

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.

Here are my favorite references for DB2 on IBM i:

  • The first place to look for many, but not all, manuals: DB2 for i Manuals by Release.
  • The grandma of all DB2 for i manuals is the DB2 for i SQL Reference. IBM’s description: “It contains reference information for the tasks of system administration, database administration, application programming, and operation. This manual includes syntax, usage notes, keywords, and examples for each of the SQL statements used on the system.”
  • Ever need to find a stored procedure or user-defined function on your IBM i, or get a list of tables or columns? Look no further than the IBM i catalog: IBM i Catalog Tables and Views
    • For example: Find all table functions using this SQL:
      select * from qsys2.sysfuncs where FUNCTION_TYPE = ‘T’;
  • IBM has begun an ambitious effort to provide an SQL interface for many system services, in “IBM i Services.” These services are documented here: IBM i Services
  • Still have questions? Try IBM’s forum for DB2 on i

What are your favorite DB2 for IBM i references? Let me know and I’ll add them to this list.

Speaking tip

An IBM i colleague today asked me for tips to make his presentations at COMMON and other conferences more effective and helpful.

I told him that I like to arrive a day early, talk to people, gauge the audience’s level of experience with PHP, IBM i, DB2, performance, whatever topics I plan to cover. I ask people what they hope to learn at the conference and from my talks specifically. With that information in mind, I adjust the content, emphasis, and pacing of my talks for that specific group. Such pre-conference socializing also helps attendees become comfortable talking to me, such that they may be more likely to ask questions and participate fully in my talks, which brings them alive for everyone.

Conferences and user events where I’ll be speaking in Fall 2016

Video promo for COMMON conference May 15-18, 2016

Join me for the 2016 COMMON Annual Meeting and Exposition, May 15-18, with pre-conference workshops May 14. Don’t miss New Orleans!

Learn about IBM i 7.3, open source languages, security, and more.

Alan will speak about PHP, SQL, performance, and how to relax your neck, back, and shoulders at the keyboard. Also looking forward to spending time with the gang from “Club Seiden.”
https://www.common.org

ZendCon 2015 starts October 19

This year’s ZendCon has a new location—Las Vegas—and more IBM i speakers than ever, including:

  • Tony Cairns (IBM)
  • Massimiliano Cavicchioli (Zend)
  • Jim Oberholtzer (Agile Technology Architects)
  • Mike Pavlak (Zend)
  • Stephanie Rabbani (BCD)
  • Chuk Shirley (Sabel Steel)
  • Shlomo Vanunu (Zend)
  • and myself, Alan Seiden (Alan Seiden Consulting)

Tutorial day, Oct. 19, is recommended at this premier PHP conference. I’ll present “Db2 and PHP in Depth,” a three-hour tutorial of techniques for using IBM i’s native database, which can help make PHP applications more secure, easier to write, and faster. I’ll also present new features of Db2 and PHP’s Db2 interface that were inspired largely by comments and requests of past ZendCon attendees. Special guest Tony Cairns from IBM is expected, too, for a lively discussion about practical PHP development on IBM i. Bring your questions.

Later in the week I’ll present “Create a welcoming development environment on IBM i,” based on my experience leading PHP projects for IBM i, and “Strategic Modernization with PHP,” which shows the possibilities on the IBM i platform and the strengths of various approaches. Expect to hear valuable advice from your colleagues, too.

I’m looking forward to attending talks, talking to sponsors, chatting with many of my blog and newsletter readers, meeting clients, and getting to know Rogue Wave, the company that recently acquired Zend.

Information about ZendCon: http://zendcon.com

iTalk with Tuohy interview

I recently joined speaker and consultant Paul Touhy for a spontaneous, personal ‘iTalk with Tuohy’ recorded chat, described thus: “Paul Tuohy talks to development guru Alan Seiden about developing in PHP, the PHP for IBM i Toolkit, performance for developers and getting your work-work balance right.”

The free recording is available here: http://www.ibmsystemsmag.com/ibmi/trends/iTALK-WITH-TUOHY/seiden-development-balance

Vote for a Mac edition of RDi

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.

Video promo for WMCPA IBM i conference: March 10-12, 2015

Join me and 20 other speakers at the Wisconsin Midrange Computer Professional Association (WMCPA) spring technical conference, March 10-12, 2015, at the Lake Lawn Resort on the shores of Delavan Lake.

Speakers: Aaron Bartell, Rob Bestgen, Larry Bolhuis, Tom Cremieux, Floyd Del Muro, Raymond Everhart, Margaret Fenlon, Susan Gantner, Charles Guarino, Scott Klement, Chris Koppe, Jon Paris, Mike Pavlak, Jim Ritchhart, Debbie Saugen, Alan Seiden, Dr. Frank Soltis, Robert Swanson, Robin Tatam, Jeff Tickner, Steve Will

Details: http://wmcpa.org/index.php/conference-2015/ibmi-conference-2015

Before you remove Zend Core from your IBM i

If you’ve installed Zend Server for IBM i and are planning to remove the older Zend Core for i5/OS, first check that Zend Core’s version is at least 2.6.1.

Zend Core must be at 2.6.1+ because if you uninstall version 2.6.0 or lower,  portions of Zend Server will be uninstalled as well. Therefore, update your old Zend Core to 2.6.1+ before uninstalling.

Resources

Zend Framework webinar this Wednesday

On March 9, 2011, I’ll present a free webinar about how to create a Zend Framework project on IBM i. The webinar is at 9am PST, 12pm EST. Sign up here: http://www.zend.com/en/company/news/event/790_webinar-your-first-zend-framework-project-on-ibm-i

Here’s the complete list of my upcoming talks.