• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • MB Software Gets A Handle On Remote SQL Jobs

    November 28, 2018 Alex Woodie

    System administrators who get frustrated with the inability to see which SQL jobs coming in through ODBC are causing problems on their IBM i server may be interested in a product called Work with Active SQL (WRKACTSQL) from MB Software and Consulting, which recently announced the tool will be free through the end of the year.

    SQL is just about as close to a universal language for business as you can get. While there are other (i.e. “native”) methods of fetching data from Db2 for i, nearly three-quarters of IBM i developers report using SQL, making it the number two most popular development language on IBM i, after RPG (which can use “native” calls or SQL).

    The problem is, not all SQL jobs are created equal. When it comes to administering to an IBM i server that’s processing a large number of SQL jobs, things can get dicey for those charged with ensuring that things run smoothly.

    Every IBM i administrator is familiar with the Work with Active Jobs (WRKACTJOB) command from IBM, which displays every active jobs on the system and tells them which ones are consuming the most resources. WRKACTJOB is a great command.

    However, that command doesn’t always provide the needed level of clarity on all jobs, particularly when remote SQL requests are coming in over the network through the Open Database Connectivity (ODBC) exit point.

    When remote SQL queries consume resources through ODBC and JDBC, WKRACTJOB displays the jobs under the QZDASOINIT heading. Jobs that originate on Web and mobile clients, and even SQL queries fired off from System i Navigator, all fall under this QZDASOINIT umbrella.

    The problem is that administrators have no idea what these QZDASOINIT jobs are doing or what code they’re associated with. All they see is that these QZDASOINIT jobs are consuming a lot of system resources, and they need to address the problem.

    Remote SQL queries are exposed for what they really are with MB Software and Consulting’s WRKACTSQL tool.

    That’s where MB Software and Consulting’s WRKACTSQL tool comes into the picture. The command is designed to give visibility and control over remote ODBC requests by showing the actual SQL statements that are impacting the system in real time, thereby allowing systems administrators to react appropriately.

    According to MB Software and Consulting, WKRACTSQL lets admins hold, terminate, or change run priority for specific SQL requests that running on the system. It also lets them set up alerts to automatically receive notification when a user runs the same SQL request that caused the problem in the first place. The software also lets administrators block specific users and specific SQL requests from getting access to the system.

    MB Software and Consulting normally charges $500 per LPAR for WRKACTSQL. But as part of a promotion unveiled last month, the New York company is giving the tool away for free through December 31. For more information see the company’s website at www.mb-software.com.

    RELATED STORIES

    Boadway Puts IBM i Performance Data on the Cloud

    MB Software Introduces WebClip/400

    ezRAD.com Announces General Availability of PalmView/400

    Performance Tool Developer Breaks New Ground with PalmView/400

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: IBM i, JDBC, LPAR, ODBC, Open Database Connectivity, RPG, SQL, WRKACTSQL

    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

    Four Hundred Monitor, November 28 Syncsort Snags EView for Log Data Hooks

    Leave a Reply Cancel reply

TFH Volume: 28 Issue: 79

This Issue Sponsored By

  • T.L. Ashford
  • Profound Logic Software
  • Datanational Corporation
  • Rocket Software
  • WorksRight Software

Table of Contents

  • High Schools: The New Recruiting Grounds for IT Jobs
  • Syncsort Snags EView for Log Data Hooks
  • MB Software Gets A Handle On Remote SQL Jobs
  • Four Hundred Monitor, November 28
  • IBM i PTF Guide, Volume 20, Numbers 46 And 47

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • 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

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