• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Halcyon Overcomes IBM i Spool File Limits

    March 13, 2012 Alex Woodie

    The IBM i platform excels at handling big data. Its integrated database allows customers to handle large amounts of data with relative ease. Just the same, there are some limits in the OS when it comes to spool files that some IBM i shops have managed to meet. With the latest release of its Spooled File Manager, Halcyon Software has enabled these customers to overcome these limits and continue to process and store an ever-growing collection of spool files.

    Spooled File Manager is an IBM i product designed to streamline the distribution and long-term storage of spool files generated by applications. Examples of the green screen utility’s repertoire include: automatically creating indices of spool files to enable quick retrieval at a later time; emailing reports as PDF attachments based on variable data in the report; and purging old spool files to clear disk space and boost performance, among other features.

    With version 9.0, Halcyon has focused on improving Spooled File Manager’s performance in big-data environments. Some customers of the U.K. software company are required by law to retain reports and other documents for many years after they’re generated. Over the years, the data builds and builds. In some cases, where customers generate and store these reports in a single IBM i spool file, they bump up against intrinsic limitations in the IBM i architecture.

    Martin Norman, Halcyon’s technical support manager, explains to IT Jungle the spool file limit and its ramifications to Halcyon customers.

    “There’s an IBM limitation that you can’t have 32,763 members in a single file,” he says. “I hate to call it a limitation because IBM has made a fairly high level scope available, but it’s just that people keep reaching it. Whoever thought we’d need 32,764?”

    Because of legal requirements that customers keep reports accessible for so long, Norman says, that limitation gets reached fairly easily by Halcyon customers. “So we put some background processing in place so that we roll over when we reach that limitation. We just roll over and automatically start processing into a different location, into a different file,” he says.

    Spooled File Manager 9.0 also features a new compression capability that enables customers to store massive numbers of pages in their spool files. Some of Halcyon’s customers have individual spool files that contain more than 1 million pages.

    For example, one of Halcyon’s customers in the energy business must keep track of royalty payments for natural gas drilling. They had to keep a seven-year trail of it to keep the auditors happy, says Halcyon vice president of marketing John Dominic. “It had become a massive amount of information to keep in their archive and keep generating these spool files that were insanely large,” he says.

    Halcyon’s approach to storing spool files with more than 1 million pages is to remove all the blank spaces in the report, Norman says. “Quite often in a large report like that, most of the space in the report is white noise. There’s nothing there,” he says. “So we can take that and compress it down by getting rid of all the spaces.”

    The new version also features user interface enhancements, including new templates that define what reports a person can see, and new “smart caching” techniques to help speed the presentation of the list of reports a particular user can access.

    The new templates will make it easier for multiple users to share their reports in a secure manner. The templates give security administrators the capability to define which groups of reports (i.e., which author’s reports) they can access and which they can’t. “Normally when you work with spool files, it shows you what you generated,” Dominic says. “But we’ve added some new criteria so that you can see … what multiple people have done, if you have the proper amount of authorization.”

    The smart caching technique, meanwhile, will give satisfaction to hurried users. “Everybody’s impatient these days. They want to see something happening straight away,” Norman says. “So with smart caching, it now shows me my first screen of information when I first start looking at reports, and the process continues to run in the background, collecting the spool files you might want to see as you’re paging through the system.”

    Halcyon also divulged a new product that will likely debut around the COMMON timeframe (early May). The product, tentatively called the Spooled File Management Suite, will combine the spool file collection and distribution capabilities of Spooled File Manager with more advanced document management capabilities, such as a screen overlay tool, a GUI interface, and more advanced document distribution parameters.

    Spooled File Manager 9.0 is available now as a standalone tool or as part of Halcyon’s level three Advanced Automation Suite and level four Operations Center Suite. For more information see the vendor’s website at www.halcyonsoftware.com.

    RELATED STORIES

    Halcyon Bolsters IBM i Security Tool

    Halcyon Completes Upgrade Cycle with Operations Center 3.0

    Halcyon Delivers ERP-Specific Monitoring in Systems Operations Suite 3.0

    Halcyon Revs Up U.S. Channel Effort

    Halcyon Boosts Spool File Manager, Company



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Focal Point Solutions Group

    A CloudSAFE Company

    The Power of Services:
    IBM Cloud and Managed Solutions

    Upgrade your business processes, and save time and resources with specialized, best-in-class IT solutions.

    Managed, Cloud, and Custom Solutions

    Managed Services

    • Infrastructure Monitoring & Management
    • Server Patching
    • Application Patching
    • Managed Backup
    • High Availability/Disaster Recovery Monitoring
    • Cloud Environment Monitoring
    • Office 365 Management
    • Endpoint Management
    • Managed Colocation

    Cloud Infrastructure

    • IBM i Private Cloud
    • IBM AIX Private Cloud
    • VMware Private Cloud
    • VMware Cloud Director
    • Multi-Tenant Cloud
    • Desktop as a Service

    Data Protection & High Availability

    • Disaster Recovery as a Service
    • Backup as a Service
    • IBM i Vaulting

    Security

    • Security Consulting
    • Remote Security Awareness Training & Education
    • Onsite Security Awareness Training & Education
    • Phishing Tests
    • Penetration Tests
    • Mail Security
    • Managed Detection & Response
    • Managed Firewall
    • Endpoint Protection
    • Vulnerability Management
    • Vendor Risk Assessments
    • Security Risk Assessments

    Professional Services

    • Server Virtualization
    • Data & Infrastructure Migrations
    • Hardware & Software Installation
    • Microsoft Office 365 Implementation & Migration
    • Infrastructure Assessments
    • IBM i Consulting
    • IBM AIX Consulting

    Focal Point provides all the tools you need to protect your data, ensure the integrity of your IT infrastructure, and keep your business running.

    Contact Focal Point to Learn More About Our IBM Solutions and Partnerships

    Follow us on LinkedIn

    focalpointsg.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Northeast User Groups Conference:  22nd Annual Conference, April 2 - 4, Framingham, MA
    COMMON:  Join us at the 2012 Conference & Expo, May 6 - 9 in Anaheim, CA
    CCSS:  Achieving Lights Out Automation in an IBM i environment. Get the Best Practice guide.

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    The New England Guide To IBM i Wanted: Power 745 M3 For IBM i SMBs

    Leave a Reply Cancel reply

Volume 12, Number 5 -- March 13, 2012
THIS ISSUE SPONSORED BY:

ProData Computer Services
Infor
ASNA
Linoma Software
RJS Software Systems

Table of Contents

  • ASNA ‘Bulks’ Up with Wings 5.2
  • Profound Updates RPG OA Screen Modernization Tool
  • Halcyon Overcomes IBM i Spool File Limits
  • Krengel Adds Credit Card Processing to RPG-XML Suite
  • Iron Mountain Unveils New Backup Tape Offerings
  • Spinnaker Buys Versytec’s Third-Party JDE Support Business
  • ARCTOOLS Updates JDE Performance Tool
  • Oracle Ships Smartphone Expense Management App for JDE E1
  • IBS Finally Goes GA with Version 7 of ERP Suite
  • Lawson Updates Software for Healthcare Industry

Content archive

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

Recent Posts

  • IBM i Development and Modernization is Getting A Fresche Start with Some Ground-Breaking Subscriptions
  • CloudSAFE And Focal Point Solutions Group Combine Services, Unify Brands
  • Guru: Partitioning Result Sets Using SQL
  • As I See It: Elusive Connections
  • IBM i PTF Guide, Volume 25, Number 47
  • AWS Inks Deal With Connectria To Have a Power Play
  • IBM i Shops Have Alternatives to Db2 Web Query
  • Eradani Lays Waste to API Payload Restrictions
  • Four Hundred Monitor, November 15
  • Old PHP and Other PASE Apps Break on IBM i 7.5

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 © 2023 IT Jungle