• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM i Access Turns Its Attention To Database

    July 13, 2015 Dan Burger

    It’s been just about two years since IBM i Access Client Solutions (ACS) was introduced. IBM didn’t make a lot of noise about it. Maybe that’s because IBM doesn’t market products. It markets ideas. On the other hand, it might be because ACS delivered system administration with navigation features that most people have been working with for 10 to 15 years–features such as the capabilities to drag and drop, scroll down a page, and use a mouse instead of F keys.

    IBM i Access Client Solutions is a replacement for the severely haggard iAccess for Windows, a product with thousands of users–all of them doing IBM i system admin work on Windows-based PCs. In case you haven’t heard, that product is no longer being enhanced and will not support Windows 10.

    Tim Rowe, who supervises the ACS development team, says companies that are preparing to roll out Windows 10 and those that deal with regulatory compliance issues (auditors do not like the use of unsupported software) are now coming to realize they need to investigate ACS.

    What IBM lacks in marketing prowess is made up for by circumstances that shine a light on the product. If you’ve read about ACS in previous issues of IT Jungle publications, you’re familiar with its attributes and capabilities. If not, you can catch up by reading articles noted in the Related Stories section at the bottom of this page.

    As a general statement, the ACS tools are used primarily for 5250 emulation, data transfer, and system management. But there is another task it performs that, Rowe says, is not to be overlooked: database management, and it is becoming increasingly important.

    “I have thousands of users who have database engineers or people on staff that pay attention to the database architecture,” Rowe says. “They are defining SQL scripts, doing plan caches, and doing the kinds of things to assure the database is working efficiently. There should be tens of thousands of people doing these things, but that’s a topic for another day.”

    Rowe says increasing database administration functionality is “the focus area” for the i Access development team.

    “To do an ACS product, it must have database admin tools in it. We are heads down cranking out some new things because that’s some of the stuff customers have asked us to provide. We have some proof of concepts up and running. There are working versions of a handful of database admin tools. We have internal users, but nothing ready for the Technology Preview stage yet,” he says.

    When a product gets to the Tech Preview stage it is ready to be tested by external users.

    Rowe says the Access Client Solutions team is 100 percent devoted to that product, but he also notes there are “multiple teams that play in this space and are looking at leveraging the infrastructure capabilities of ACS for other things.”

    Under the category of “other things” are tools and components that coordinate with and complement the systems management pieces–Web Navigator, IBM i Access Mobile, and the App Runtime Product with PTF distribution support for multiple systems are examples that Rowe specifically mentioned.

    To download the latest version of ACS, follow this link.

    That’s the easy part. Some of you can already guess what’s coming next.

    What you’ll find with that download is the Preview license. Rowe says the real license will replace the preview license “soon.” In this case, soon is defined as three to six months. To get a real license now is an adventure–like the worst scavenger hunt you’ve ever been on. Or, if you’re familiar with IBM product licensing, it’s just a different version of the worst scavenger hunt you’ve ever been on. If you are looking for a silver lining in this dark cloud, those that have licenses for the old iAccess for Windows product do not need to have a new license for ACS.

    I’d like to give you more help, but at least I’ve given you a warning.

    RELATED STORIES

    Mobile Access To IBM i Makes The Grade

    IBM Delivers Tech Preview for iAccess on Mobile Devices

    An IBM i Client for Every Administrative Occasion

    Migrate Your 5250 Emulator Settings to ACS 1.1.2

    Running IBM i Access 7.1 and Windows 8

    IBM Delivers Tech Preview of New Java-Based 5250 Emulator

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    DRV Tech

    Get More Out of Your IBM i

    With soaring costs, operational data is more critical than ever. IBM shops need faster, easier ways to distribute IBM applications-based data to users more efficiently, no matter where they are.

    The Problem:

    For Users, IBM Data Can Be Difficult to Get To

    IBM Applications generate reports as spooled files, originally designed to be printed. Often those reports are packed together with so much data it makes them difficult to read. Add to that hardcopy is a pain to distribute. User-friendly formats like Excel and PDF are better, offering sorting, searching, and easy portability but getting IBM reports into these formats can be tricky without the right tools.

    The Solution:

    IBM i Reports can easily be converted to easy to read and share formats like Excel and PDF and Delivered by Email

    Converting IBM i, iSeries, and AS400 reports into Excel and PDF is now a lot easier with SpoolFlex software by DRV Tech.  If you or your users are still doing this manually, think how much time is wasted dragging and reformatting to make a report readable. How much time would be saved if they were automatically formatted correctly and delivered to one or multiple recipients.

    SpoolFlex converts spooled files to Excel and PDF, automatically emailing them, and saving copies to network shared folders. SpoolFlex converts complex reports to Excel, removing unwanted headers, splitting large reports out for individual recipients, and delivering to users whether they are at the office or working from home.

    Watch our 2-minute video and see DRV’s powerful SpoolFlex software can solve your file conversion challenges.

    Watch Video

    DRV Tech

    www.drvtech.com

    866.378.3366

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    LaserVault:  FREE WEBINAR: IBM i Backups & Restores - Should Tapeless Be Your Next Move? July 15
    SystemObjects:  Send SMS, email & push messages from your IBM i applications!
    OpenLegacy:  Rapidly extend IBM i to web, mobile and cloud using REST APIs.

    Security Architecture For Business Applications IBM i 6.1 Upgrades: What’s In Your Box?

    Leave a Reply Cancel reply

Volume 25, Number 36 -- July 13, 2015
THIS ISSUE SPONSORED BY:

Profound Logic Software
OpenLegacy
LaserVault
Linoma Software
WorksRight Software

Table of Contents

  • Manufacturing Automation At A ‘Crossroads’ For IBM i Shops
  • IBM’s Migration Plan To PurePower Systems
  • LANSA Guides Mobile, Portal, Integration Project To Success
  • As I See It: The Improbable Conference
  • IBM i Access Turns Its Attention To Database

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The Turning Point For Power Systems Is Here, And Now
  • How IBM i Users Can Compete In The Digital Era With Composable Commerce
  • IBM Streamlines Data Migration With New Partition Mirror Tech
  • Profound Logic Adds MCP To IBM i AI Tool
  • IBM i PTF Guide, Volume 27, Number 29
  • Power11 Entry Machines: The Power S1124 And Power L1124
  • BRMS Isn’t The Only Backup Product With A Security Problem
  • Guru: A Faster Way To Sign A JWT
  • Maxis Adds IBM i Support To Database Modernization Tool
  • IBM i PTF Guide, Volume 27, Number 28

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle