• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • CCSS Adds Killer Queries, FTP Use to Watch List

    January 4, 2005 Alex Woodie

    Sometimes the actions of users can have unintended consequences, like that seemingly innocent query that Jane in accounting set off this morning, which is now threatening to bring down the system. And while the shipping department folks know they’re not supposed to FTP documents from the iSeries anymore, somebody back there is still doing it. These are two actions that new OS/400 software from CCSS would pick up for you, before they cause crashes or arouse attention from auditors.

    QSystem Monitor is a client/server application that shows system administrators how their iSeries servers are using system resources, such as database CPU, interactive processing per logical partition, or I/O. In total, the product simultaneously monitors dozens of performance metrics, which are displayed on the graphical PC client, called the Online Monitor.

    A new command within CCSS’s QSystem Monitor Version 11 detects so-called “looping jobs,” which are often badly written queries that suck up available CPU until everybody’s terminal runs like molasses. The traditional approach to dealing with this killer query frequently resembles an autopsy more than an active investigation, which is to say that it can be difficult to track down exactly what happened, even after the fact, let alone preventing it from happening in the first place. That doesn’t do a lot of good when orders aren’t being taken and product isn’t being shipped. But with QSystem Monitor’s new feature, looping jobs can be isolated before it comes to this.

    Once QSystem Monitor detects the looping job, it can be programmed to immediately send a message to the operator for assistance, or to take things into its own hands, including putting the job on hold or lowering its priority. A full audit trail is also maintained, helping the IT staff to understand the events leading up to the near miss (and keeping those auditors satisfied).

    QSystem Monitor can identify looping jobs in less than 90 seconds, says Paul Ratchford, a product manager for CCSS. “These are the very jobs that, left unattended, have the ability to bring down a system altogether,” he says. “The time saved on preventing any type of downtime situation can be immediately translated into money saved for the organization.”

    CCSS has also enhanced security and that all-important audit-ability with a new FTP monitoring feature in QMessageMonitor, a complementary product to QSystem Monitor that filters the main QSYSOPR message log to weed out the unimportant messages, and notifies the operators of the critical ones through automatically generated e-mails, phone calls, pagers, or other electronic devices.


    A new FTP tracking feature in QMessageMonitor Version 6 tells administrators exactly what FTP actions are being used on an iSeries and who is running them. In this way, QMessageMonitor adds another degree of visibility and accountability to internal controls, which is an area of significant concern for iSeries shops that must conform to Sarbanes-Oxley and other regulations, CCSS says.

    There’s an increasing demand for eliminating any “gray areas” from essential daily processing tasks, CCSS said in a statement. “Such work is changing the culture of large and multi-system computing, bringing the weight of responsibility for data security firmly into the IT manager’s department,” the company says. “In an age where modern commerce depends virtually wholly on the applications and systems used to support them, this trend for total accountability looks set to continue.”

    CCSS is located in Gillingham, in the County of Kent, in England. Its U.S. headquarters are in Raleigh, North Carolina. For more information, go to www.ccssltd.com.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Centerfield Addresses Compliance with delta/TRACKER Get Organized with the WDSc Tasks View

    Leave a Reply Cancel reply

Volume 5, Number 1 -- January 4, 2005
THIS ISSUE
SPONSORED BY:

Bytware
California Software
El Camino Resources
Lakeview Technology
RJS Software Systems

Table of Contents

  • Oracle Pledges Support for World ERP System
  • CCSS Adds Killer Queries, FTP Use to Watch List
  • Menten Goes for the i-effect
  • Inovis Unveils Unified E-Business Product Line

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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