Thu, Jul
0 New Articles

IBM i Access Client Solutions (ACS) Adds More Features

  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

The new ACS update has a few major updates. System i Access is dead and buried. What are you waiting for?


As part of the announcements for IBM i 7.1 Technology Refresh 11 and IBM i 7.2 Technology Refresh 3, IBM i Access Client Solutions (ACS) has been enhanced with some new and exciting features. ACS is the lightweight Java-based successor to System i Access products.


I sat down with Tim Rowe, the Business Architect for Application Development and Systems Management for IBM i, last week for a quick discussion about the new features.


One of the biggest challenges about the delivery method for ACS was that you had to download it from the IBM Entitled Systems Support (ESS) website. It's not the easiest place to navigate, especially for client software. Very recently, ACS has been available to download via the IBM i Access website. There's no ESS required. Of course, you have to put in your IBM ID to download through the Access website.


Steve Pitcher: So, Tim, I hear that we'll get watermarking support in this release. That's all I needed to hear actually. Best feature ever. What else is coming in this release?


Tim Rowe: Major changes. In addition to the usual fixes and updates that come with the product, we've continued on our path to provide a full Windows 10 solution. Not just Windows, but it runs on Mac, Linux, or any platform that supports a full Java Virtual Machine. It's truly an OS-agnostic solution. We've provided the Run SQL Scripts interface. The cool thing is it looks, acts, and behaves very closely to what we've had with Access for Windows, which was very well loved, but there's been some long-running complaints that we were able to address. For instance, line numbers. Something very simple, but we fixed it. If you're dealing with very large scripts, it's easy to figure out where you are.


We've added some huge enhancements to the search capability. If you're running a single SQL statement, it's not that big a deal, but I've got customers with SQL scripts that could be pages and pages long. The searching capabilities allow you to do things like find and replace with very complex search strings. You've always been able to do a very simple find, but now our find is very, very robust.


The other thing, very simple again but expected in today's world: color coding. The editor that's in there is smart enough to detect certain SQL key words and color code it.


SP: What about SQL analyzation?


TR: Not yet. But we're working on it. Check out the SQL performance center. If you go to the client Navigator or the web Navigator and you drill down to the database, you've always been able to go and get your SQL metrics. The ability to look at performance metrics. They've been slow and cumbersome to work with because the data sets could be just massive. That's now part of the ACS solution. We've built in the technology to deal with massive data sets with ridiculous speed. In many respects, it's mind-blowing how fast we can deal with these data sets.


SP: Will we see this new tech in Navigator for i?


TR: No. It's part of ACS. Being able to deal with it with a web solution isn't practical based on the size of these things. It just made sense to have it in ACS. Now when you ask that question, my answer is no, it won't work in Navigator, but it will work very well with Navigator. The other cool enhancement that we've delivered is that we now have IBM Navigator for i and ACS tied together. We've just completed a couple of PTFs that will be available in the next HTTP PTF group at the end of December. You can get those PTFs individually now if you so desire, but they'll be bundled with the group. From ACS, I can create a connection to my web Navigator. If you start with ACS and you click on the Navigator, it will load it as normal, but it will also do the sign-on for you. You won't be prompted.


SP: That's sweet.


TR: Very sweet. If I'm in Navigator and I navigate on down to Database and I click Run SQL Scripts, it will launch my Run SQL Scripts in ACS. If I'm in Run SQL Scripts in ACS and I want to look at my job information, it's going to launch the web Navigator and display it there. There's a nice flow between the two and very tightly integrated.


SP: What's your adoption like for ACS? I know I've used it since it was a technology preview. What's your download numbers look like?


TR: There's a number of factors that come into adoption. It's certainly becoming adopted. If you read the forums, people are talking about it. A big reason for that is the Windows 10 issue. We do not have support for System i Access for Windows on Windows 10.


SP: Now people can try to run it on Windows 10 without being supported. Some have had some success.


TR: They can try to run some parts, but not everything is going to work. SSL support is certainly not going to work. There's a couple of things we can talk about when it comes to our customers' usage of the old Access products. Many of our customers are running very ancient versions of i Access for Windows. We put out the 7.1 version back in 2010, and there's still a lot of people using versions that are older than that. Do you care about security? If you do care and you're running the old i Access for Windows, then you're not compliant. There are security vulnerabilities in the software that you're running. Part of the reason that people aren't on the latest patched version of IBM i Access for Windows is that it's a real pain to upgrade it.


SP: Absolutely. If you've got 10 computers to upgrade, you've just blown a full day. What if you have 500?


TR: If I set up ACS right with a single distribution on a network drive, then I can upgrade IBM i ACS for 1000 users in 10 minutes. Far easier to be current and more secure with ACS than i Access for Windows.


For the average user, they just want 5250 and spooled file support. We actually created a little wizard for an “install” so your users don't get the SQL scripts or Console or Data Transfer links. Of course, there's no install; it's just a wizard that customizes ACS for your deployment. The wizard also helps do file association for you. If you have a .hod file, ACS will use it. You can even use the old i Access for Windows session manager with a .ws file, and ACS can use it. If you're transitioning, then that's fine, but you should really re-save those as proper .hod files for ACS. For practical purposes, we deal with the old .ws files just fine.


Steve Pitcher
Steve Pitcher works with iTech Solutions, an IBM Premier Business Partner. He is a specialist in IBM i and IBM Power Systems solutions since 2001. Feel free to contact him directly This email address is being protected from spambots. You need JavaScript enabled to view it..


Support MC Press Online


Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: