Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at

Status Delivered
Workspace Db2 for z/OS
Created by Guest
Created on Dec 21, 2023

Instrument workfile high-watermarks in ACCTG

This would be useful to all business users that seek to tune their installation for best performance; specifically in the area of MAXTEMPS.

Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K blocks total, or separate by tables/indexes, or separate by 4K/32K Workfiles -- implementation choice.)

It is difficult to manage Workfile allocations without an understanding of how much Workfile each thread requires for its SQL processing. We must support the needs of production jobs -- and also adhoc jobs, some of whose SQL is incorrect (lack of a join predicate means, a cartesian product) or cannot be supported as such (an ORDER BY better done by an external SORT.)

IFCID 0342 instruments Workfile monitoring, and MAX(QW0342CT+QW0342CI) is the measure we are looking for. (QW0342MT and QW0342MI high-watermarks could represent different time instances for tables and indexes.) However, IFCID 0342 operates on a detail level. A given thread can generate thousands of IFCID 0342 records, as we saw, for example, in repeated 4K up to 8K down to 4K etc. patterns. Recording of this kind adds too much overhead to tolerate 24x7.

What we need is the Current Workfile amount (4K blocks, or separate by tables/indexes) and Maximum Workfile amount tallied in IFCID 0148 (available to monitors), and the latter recorded in the completion IFCID 0003 record (for our ACCTG repository.)

Needed By Quarter
  • Admin
    Janet Figone
    Mar 25, 2024

    Dear KC, Thank you for submitting this enhancement request. Our development team confirmed with you that functionality delivered in Db2 12 for z/OS satisfies this request and you are in agreement to close the idea.

    Therefore, I have marked it as Delivered.

    We appreciate your input to the Db2 for z/OS development team. And we hope that you will continue to submit enhancement suggestions for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.


    The Db2 for z/OS team