TechTip: An Easier Way to Search Through Massive Job Logs

Cilasoft offers its new Job Log Explorer tool to the IBM i community at no cost.

guy marmoratWritten by Guy Marmorat

Anyone who has searched through mountains of pages in job logs to find specific program messages during the process of troubleshooting knows all too well how time-consuming and tedious this task can be. In fact, as my team and I have worked with customers and partners over the years, we’ve commonly heard complaints about this very thing. But what’s surprising is there hasn’t been a useful tool available (at least that we could find) to help quickly isolate critical job information in these ungainly job logs. It’s basically a process of repeatedly pressing the F16 (Shift+F4) search key while trying various search terms.

Data-Centric Magic

Everybody is talking about data-centric programming these days. But what is it, and what can it do for, and to, you?

david shireyWritten by Dave Shirey  

Every once in a while, we see a flurry of articles about one particular topic. It blazes forth like a flaming Molotov cocktail, gets tossed up in the air for everyone to see, and then seems to explode in a cloud of smoke. It’s 15 minutes over, the topic quietly goes about the rest of its life, sometimes fading into insignificance and other times taking its place in the hallowed pantheon of IBM i concepts.

SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date Tricks

After last time’s functions for extracting information from a date, I’ll look into some real date math, with functions that perform some neat tricks.

rafael victoria preiraWritten by Rafael Victória-Pereira

It’s now time to let the system do the so-called “date math” for you. This is an easy task in SQL because there are several intuitive functions to help. Let’s start with ADD_MONTHS. This function has two parameters: a valid date representation and the number of months to add. Here’s an example:

Domino Short and a Fix Pack Late

Domino is dying. But there is hope.

steve pitcherWritten by Steve Pitcher

Last month, I wrote a piece about the future of IBM Notes/Domino called “The Domino 9.0.2 Waiting Game” in which I lamented at the lack of, well, Domino 9.0.2.


Lo and behold, just last week IBM put out an announcement for an update: Notes and Domino 9.0.1 Fix Pack 7. With a whopping 81 fixes combined between client and server since the last update in May 2016, the collective sigh from the IBM Domino user and ISV community certainly wasn’t heard ‘round the world.

Eye on the i World: HA/DR Specialist Company Sees the Cloud as the IBM i's Salvation

Paying attention to the best uses of cloud computing, the business benefits of the IBM i, and shrewd use of the platform can keep the i relevant into the future.

john gristWritten by John Ghrist

While there are possibly many people who think the IBM i has already seen its best days as a platform, there are also others who don't agree with that assessment. While there are some negative-sounding statistics, there are also hopeful signs that developing technology and services, particularly cloud-related, can revive the platform's outlook.

Popular Security Terms and How They Relate to IBM i

Carol describes terminology prevalent in the security world, explains what it means, and identifies how it applies to IBM i.

carol woodburyWritten by Carol Woodbury

I subscribe to several security-related newsletters. I was reading an article the other day, and it used the phrase “good security hygiene.” I thought I knew what that meant but did a bit of research to make sure. That experience made me think that it might be helpful to explain some security terminology and describe how it relates to IBM i. Let me start with the phrase that inspired this article.



mrc’s e-Learning Portal Helps Users Get More Value out of m-Power

Software developer mrc announces the release of an e-Learning Portal for m-Power users.

“Fractional” CISO Service Now Available for IBM i Environments

Botz & Associates brings ongoing security guidance to small and mid-sized companies.

Benelux Power 2016

Europe’s Smartest IBM Power Expo and Conference

The Weather Company Data Packages Delivers a Set of Cloud-Based Weather Data Services

The Weather Company Data Packages delivers a set of cloud-based weather data services that enable companies across multiple industries to utilize key weather insights to make critical business decisions and improve performance.

IBM Rational Solution for Test Automation V9.0.1

IBM Rational Solution for Test Automation V9.0.1 delivers new capabilities for continuous testing and service virtualization.

IBM Watson Virtual Agent Delivers a Cognitive, Conversational Self-Service Engine for Business

IBM Watson Virtual Agent, a cognitive assistant for business, delivers the following capabilities:

IBM Kenexa Learning Content Management System Premier V10.2

IBM Kenexa Learning Content Management System Premier V10.2 now includes a new authoring interface that combines the ease of use of desktop tools with the collaboration, reusability, and maintainability of a Learning Content Management System.

IBM App Connect Professional on Cloud

IBM App Connect Professional on Cloud can help you connect your SaaS, ERP, and custom applications rapidly and automate your workflows by using an intuitive, configuration-based approach.

IBM Notes and Domino V9.0.1

IBM Notes and Domino V9.0.1 extends support and enhances its collaboration toolset with social capabilities from IBM Connections V5.5.

IBM Maximo Anywhere V7.6.1

IBM Maximo Anywhere V7.6.1 delivers new platform capabilities and updates to mobile applications to increase the productivity and efficiency of the field technician.



Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here

Events Calendar

September 2016
28 29 30 31 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 1




See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


Latest Offer from the MC Press Bookstore >>

The MC Press Bookstore runs promotions throughout the week.

Make sure to stop by and check out these Special Deals:
Weekly Collection Sale - Every week an entire Subject is on sale between 15% to 25% off the Sale Price.
9/26 to 9/30 - 25% OFF all RPG books
Monday's Blowout Book - Every Monday check out this DEEPLY discounted book - 50% or more off Sale Price.
9/26 to 9/30 - 50% OFF DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration
Tuesday's 2-Day Sale - Every Tuesday come check out a very special offer on one of our top selling books.
9/27 to 9/28 - 35% OFF IBM Cloud Platform Primer
Thursday's 2-Day Sale - Every Thursday come check out a very special offer on one or more of our books.
9/29 to 9/30 - 35% OFF Data Governance Tools


Check out these New MC Press Books

DB2 11 for z/OS Database Administration: Certification Study Guide (Exam 312) IBM i Security Administration and Compliance: Second Edition Evolve Your RPG Coding: Move from OPM to ILE ... and Beyond DB2 10.5 Fundamentals for LUW (Exam 615)


eBook Special >>

Save 20% Off the Hard Copy Sale Price