• IBM Ships ACS Version 1.1.9.0

  April 13, 2022 Alex Woodie

  IBM this week delivered an update to Access Client Solutions (ACS), the popular Java-based utility that many IBM i professionals use to interact with the platform. IBM is delivering several enhancements with ACS version 1.1.9.0, some of which came through the request for enhancement (RFE) process. It also defaults to opening IBM’s new Navigator for i, rather than the old one, which is susceptible to the Log4j security vulnerability.

  ACS is the universal Java-based utility that IBM unveiled 10 years ago this August to replace older Client Access products, including the ones for Windows, Linux, and Mac. The software, which …

  Read more

• Guru: Debugging SQL Stored Procedures With ACS

  April 11, 2022 Mike Larsen

  I use Access Client Solutions (ACS) daily to help with different tasks. I’m usually running SQL scripts or working with the IFS, but recently I was asked if there was a way to debug SQL stored procedures using ACS. More specifically, they were looking for a way that a “non-IBM i” person can debug SQL stored procedures on IBM i.

  After browsing the various menus in Run SQL Scripts in ACS, I found a system debugger. I had seen the system debugger before, but never took the time to explore it further. With this new request in mind, I decided …

  Read more

• Guru: Keeping Track Of IBM i System Limits

  January 17, 2022 Dawn May

  Every complex system has limits, and computer systems are no different. During my work with clients over the years I’ve seen many shops push their systems as far as they can go until performance breaks down. The limits I encounter are generally numbers of things: How many objects can exist in a library? How many rows can be inserted into a table? How large can a file in the IFS be?

  Typically, these limits are large and you may think you do not need to worry about them, especially after an upgrade. But as the workload on your system …

  Read more

• Guru: Content Assist Plus in Run SQL Scripts

  November 29, 2021 Paul Tuohy

  By now, you should be well aware that Run SQL Scripts provides content assist (promoting) for Select statements (see Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL! ). But did you know that you can also use content assist for stored procedures, table functions and parameters? Let’s see how it works, using some of the Integrated File System (IFS) procedures and functions provided by IBM i Services.

  Prompting a Stored Procedure

  Open Run SQL Scripts, type in:

  call qsys2.
  

  Then press F4 (or Ctrl+Space). You will be presented with a list of all the stored procedures in the schema …

  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

• 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

• 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: Getting Meaningful Audit Information from a Journal

  July 26, 2021 Paul Tuohy

  Journaling is an invaluable tool that is used for data recovery, data replication, commitment control and, of course, auditing. But getting at the audit information in an easy-to-use manner can be cumbersome. In this article I want to introduce you to a stored procedure that will create an audit table for any table/physical file and a corresponding view that can be used for easy auditing of changes.

  For example, if I am auditing the EMPLOYEE table (I will be using the EMPLOYEE table in the standard Db2 Sample Database) for a change to the SALARY column, I would use the …

  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: Generate SQL for Dependents

  May 24, 2021 Paul Tuohy

  Way back in October 2014, in the article Find A View Of A View Of A View. . ., I detailed a stored procedure that, given the name of a table or a view, provides the full list of dependent views and all of their dependents and all of their dependents, etc. This is a stored procedure that has served me well in the world of DDL, where it is common to have views of views of views.

  In this article I will describe a follow-on stored procedure that will generate the DDL for a given table/view and all …

  Read more

Previous Articles Next Articles