• Guru: How To Override Query Options

  May 21, 2018 Ted Holt

  QAQQINI is a physical file with which you can control certain behaviors of the DB2 for i query engine. For a list of the query options that you can change, visit the IBM Knowledge Center. Normally you don’t have to use it, as the engineers of IBM have done a great job designing an optimizer that does a great job.

  At times you may want to change a query attribute for a certain job. There is no need to build many QAQQINI files to handle all possibilities. Instead, you can temporarily override query attributes within a job. DB2 for …

  Read more

• 30 Years And Just Getting Started: IBM i Celebration Looks Ahead

  April 4, 2018 Dan Burger

  It’s been said many times that you can’t move forward if you keep looking back. What you’ve accomplished is not the end point. It’s the foundation for building toward the future. You can look back to see what you’ve missed, but it takes forward thinking to make up for it.

  This week is the beginning of a lengthy celebration spotlighting “30 years of innovation and we’re just getting started.” The IBM i team launched a website yesterday with a focus on the future, an emphasis on innovation and a reliance on social media (and IT Jungle) to spread the …

  Read more

• The Road Ahead For Power Is Paved With Bandwidth

  March 26, 2018 Timothy Prickett Morgan

  The gap between what most IBM i customers need from Power Systems hardware – particularly when it comes to compute capacity – and what Big Blue can deliver has been widening since about the Power7 generation back in 2010. But, thanks in large measure to the slow down in Moore’s Law advances in chip manufacturing processes, the gap is going to start closing. Not so much because IBM wants it to, but rather because of the limits of physics.

  And, given that the IBM i platform is a database platform that mainly does transaction processing and analytics, IBM’s shift away …

  Read more

• Insurer Chooses IBM i Database Re-Engineering Over Migration

  March 26, 2018 Dan Burger

  How do you want your database designed for the future and what problems have you created in the past that need to be fixed before you can think about the future? Old databases, originally designed for a business environment that has changed and continues to change, are not compatible. You may not be feeling any pain today and you may have no plans to change your business/IT alignment in the future, but much of the technology-driven business world is changing, which at some point will leave you alone on an island with a boat but no motor and no paddle. …

  Read more

• Tooling Around With IBM i Access Client Solutions Announcements

  February 21, 2018 Dan Burger

  Access Client Solutions (ACS) received several feature/function enhancements when the Technology Refreshes were announced last week with a little something for end users, system administrators, and database engineers. Although nothing stands out as a major item, this is an incremental release fulfilling user-requested features.

  The 5250 emulator is a good example. It’s a key technology that is likely the most used component in ACS, but it’s been around for so long it’s easy to think there’s nothing new in emulation. But users never seem to cease to ask for something new: support for Chinese CCSID 1371 is one of those …

  Read more

• NGS And LightEdge Provide New Entry To The Cloud

  February 12, 2018 Dan Burger

  When does the time come to consider moving your IBM i on Power off premise? Many IBM i shops remain unmoved. An uneasy feeling about losing control or applications and data remains a top concern. Fears of production server accessibility on someone else’s watch persist. After years of successfully running your core business apps on a reliable server, why change what’s working great?

  Well, there are IBM i shops discovering compelling reasons and making the move. Gradually is the word that describes it. It’s not unobservable or insignificant. The reasonableness is not universal, and moderation seems to be the mindset. …

  Read more

• Rimini Street Finally Finds Its Way to Wall Street

  January 15, 2018 Alex Woodie

  As 2017 was coming to a close, Rimini Street quietly completed its quest to become a publicly traded company. But the firm, which provides third party support for DB2 for i and JD Edwards customers, didn’t go public through an initial public offering. Instead, it landed a listing on the Nasdaq by acquiring a company that already had one.

  In October, Rimini Street completed the merger with GP Investments Acquisition Corp, a so-called “blank check” company that was formed in 2015 specifically for the purpose of effecting a merger or acquisition in the United States or Europe. The company had …

  Read more

• VAI Experiments With Watson

  November 15, 2017 Alex Woodie

  It’s hard not to hear about Watson these days, especially since IBM changed the name of its Power Systems division to Cognitive Systems. But what can the cognitive service bring to pragmatic IBM i shops who are wary of change? The ERP software company VAI is at the forefront of experimentation.

  According to VAI CIO Kevin Beasley, VAI started working with Watson in 2016. A lot of the early work that year involved manually uploading a bunch of ERP data into Watson, mixing it with data supplied by IBM, and then seeing what Watson came up with.

  One of …

  Read more

• HVR Data Integration Has A Place For IBM i

  November 8, 2017 Dan Burger

  Data integration is powering changes in enterprise computing. And although it doesn’t get talked about a lot, relational databases are major factors in the enterprise business analytics. Transactional processing systems that are the workhorses of enterprise applications such as ERP are rock solid and critical to data analytics regardless of the hoopla and hyperbole that “modern” databases create.

  Fitting a relational database into a heterogeneous environment that is pumped full of continuous data integration from a variety of sources can be a problem, but lessons are being learned as data integration becomes more platform inclusive at more companies.

  HVR Software …

  Read more

• Database Modernization: Methodology To Solve Problems

  November 6, 2017 Dan Burger

  Innovation is a combination of tools and processes. Big mistakes get made when there is too much emphasis on the tools and too little on the processes. Innovation in a can, a bottle or a box isn’t reality-based strategy, although it’s often thought of that way, particularly at the executive level where the goal of competitive advantage is sometimes tied to specific products and technologies.

  Tools and processes support innovation. They aren’t the innovation. Not at the individual business level where competitive advantage is differentiated and honed with years of experience. Too often experience is discounted or even disregarded when …

  Read more

Previous Articles Next Articles