• Db2 PTF Group Enhancements Target Web Services, Audit Journal

  October 4, 2021 Alex Woodie

  It is indisputable that the Db2 for i database is the beating heart of the IBM i platform. There were no earthshattering enhancements to this database in the latest batch of Technology Refreshes for IBM i 7.3 and 7.4 that IBM announced and shipped last month. But there were a few items worth mentioning that shipped in the Db2 PTF Group, including new HTTP commands for calling the database via REST and new SQL-based commands for querying the security audit journal.

  The top new Db2 for i feature arguably is the new set of functions for HTTP requests to consume …

  Read more

• IBM Improves Run SQL Scripts with ACS Update

  September 22, 2021 Alex Woodie

  In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving the IBM i. A good reason for that success is the adoption of Run SQL Scripts, which has been enhanced with the latest Technology Refresh for IBM i 7.3 and 7.4.

  ACS is a Java-based product that IBM first unveiled in 2012 and that has replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you’re using to work with the IBM i server, be it Windows, Linux, or Mac, you can access …

  Read more

• The IBM i Job Environment, It’s a Changin’

  September 15, 2021 Alex Woodie

  The IBM i job market ain’t what it used to be. Change is a constant in this world, but the rate of professional change during the current pandemic is of particular interest at the moment. From new technologies and enlarging salary requirements to work-from-home and pending retirements, you could say we’re experiencing a period of punctuated equilibrium when it comes to working in the IBM i ecosystem.

  Since the start of the COVID-19 pandemic, companies across many industries have adopted work-from-home mandates. IBM i shops, like all others who can, have moved strongly in that direction. Many have still not …

  Read more

• Surprise! It’s IBM i Technology Refresh Time

  September 13, 2021 Alex Woodie

  IBM surprised the midrange world last week by announcing Technology Refreshes (TRs) for IBM i 7.3 and 7.4, which became generally available on Friday. The fall TRs, which typically are announced in October, brought support for the new Power10-based Power E1080 server in addition to a slew of enhancements to the operating system and surrounding IBM i products.

  The big piece of news with the new TRs – IBM i TR 7.3 TR11 and 7.4 TR5 – is support for servers based on IBM’s speedy new Power10 processor, which is the first Power chip based on its 7 nanometer …

  Read more

• Thoroughly Modern: Making The Case For Code And Database Transformation

  September 13, 2021 Robert Arce

  The last 18 months, we have seen many companies shift their IT plans and prioritize digital transformation around internal and external access to their systems. Some had started their modernization efforts which made the transition easier while many others who thought they had plenty of time had a rude awakening. So many ways of doing business have changed – and they have changed forever. In the face of such rapid changes, companies have realized that IBM i modernization is inevitable.

  

  Simply put, it is about figuring out:

  • How to enhance an application by applying best practices, creating resilient code and

  …

  Read more

• One IBM i Shop’s Close Call With Ransomware

  July 28, 2021 Alex Woodie

  Think the ransomware epidemic won’t affect you, that it’s somebody else’s problem? After reading this story about one IBM i shop’s recent experience with cybercriminals, it may have you thinking twice about your approach to security.

  Greg is the IT manager at a midsize distribution company located in the South. IT Jungle is abiding by his request to keep his last name and the name of his company out of this article. But Greg was determined to share his story with the wider IBM i community, in the hopes that it will spur them to take the ransomware threat seriously, …

  Read more

• Guru: One-Shot Requests and Quoted Column Names

  July 19, 2021 Ted Holt

  If I had a dollar for every time someone has asked me to query data for them over the years, I could have retired already. (I did not say I would have, but that I could have.) It’s nice when the users can retrieve the information they need to do their jobs without help from IT, but when a request is too complex for them, I’m always glad to help.

  I’ve used many tools over the years for one-shot requests for raw data. These days my tool of choice is the Run SQL Scripts tool, which is part of IBM …

  Read more

• Guru: Understanding Database Performance Using The Performance Data Investigator, Part 2

  June 28, 2021 Dawn May

  This is the second in a two-part series on how you can use the Performance Data Investigator (PDI) to investigate performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is more commonly known than PDI, using both tools is a good way to analyze database performance.

  In Part 1, I reviewed the Database content package, focusing on the charts for I/O reads and writes, SQL CPU utilization, and database locks. In this tech tip, I continue by reviewing the charts related to SQL Cursor and Native DB Opens as well as the SQL Performance …

  Read more

• Guru: Understanding Database Performance Using The Performance Data Investigator, Part 1

  June 21, 2021 Dawn May

  This is a two-part series on how to use the Performance Data Investigator (PDI) for investigating performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is the tool of choice for Db2 performance analysis, there is valuable information that you can get from using PDI. PDI is often a useful starting point to help guide you in the correct direction when trying to identify performance issues. In my experience, PDI is under-utilized for Db2 investigation. For those not familiar with PDI, you may want to read the article, Getting Started with the Performance Data Investigator …

  Read more

• Guru: Use SQL To Replace Reports

  June 14, 2021 Ted Holt

  Does anybody write report programs anymore? If so, why? Reports are so twentieth-century. The people we serve want spreadsheets, Web pages, cell-phone apps and other modern conveniences. What we need is an easy way to make our report programs write the same information to modern interfaces without having to perform major surgery on them.

  Some 10 years or so ago, I built a scripting language to enable me to reformat spooled files into stream files in CSV format. I called my utility BASS. It was, and continues to be, a successful project.

  But BASS is not the only way …

  Read more

Previous Articles Next Articles