Db2 Tools for zOS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  QMF 12.2.0.3 Fixpack

    Posted 09/02/20 10:58 AM
    Hello everyone, there is a new fixpack for QMF on IBM Fix Central.
    Select fixes
    Ibm remove preview
    Select fixes
    The Fix Central application is identifying the fixes you selected.
    View this on Ibm >


    ------------------------------
    shawn sullivan
    ------------------------------

    #Db2Toolsforz/OS


  • 2.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/03/20 04:22 PM
    ​Shawn,

    We are on  QMF for Workstation V12.1, Build ID: 20160918

    Is there a benefit to moving to V12.2.0.3?

    Thanks, Tom


  • 3.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/04/20 10:37 AM
    There are the cumulative bug fixes, and 12.1 did not have the REST API or the QMF Server.
    Also 12.2.0.3 has the following enhancements:
    1) The Table editor now allows you to enter any WHERE clause you like on the SQL and save the resulting object as a Table Editor for future use.
    2) The sorting of columns in the grid via the results menu used to be limited to 3 columns. Now you may sort by as many columns as you wish assigning them ascending or descending order. The speed of the sort has been speeded up considerably. And the query can be set to remember the SORT. This can take the load off of the database doing the ORDER BY.
    3) The Analytical Query object takes queries as inputs and combines and transforms the result sets by Joining, Grouping or Appending them even if they come from different databases. The Analytical Query now has three more functions:
    a) The Union, which is like Append but it filters out duplicate records.
    b) The EXCEPT which acts like the SQL EXCEPT or MINUS in that it takes two result sets and delivers anything in the first result set that is not in the second result set. If you have a transactional table and an analytical table that need to be kept in sync, this feature will deliver just the delta that has built up in the transactional table since the last sync point.
    c) The INTERSECT which acts like the SQL INTERSECT. It takes two result sets and deliver just the records that are common to both.

    ------------------------------
    shawn sullivan
    ------------------------------

    Original Message


  • 4.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/23/20 07:16 AM
    Hi Shawn,

    I see that 2 Fixpacks have been published at the same time 12.2.0.2 and 12.2.0.3.
    You have posted below what's in the 12.2.0.3 Fixpack, but what about the 12.2.0.2 one, and where can I find a fix list with all the bugs that are supposed to be fixed in a particular Fixpack?

    Thanks
    Sven



    ------------------------------
    Sven Heidorn
    ------------------------------



  • 5.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/24/20 08:40 AM
    Sven 
    in the past, Fix Central would have the fixpack and a readme listing the enhancements and bug fixes like this

    fix pack: qmf1118_ee_win32_fixpack 

    Platforms:  Windows 32-bit, x86

    Applies to versions:  11.1

    Upgrades to:  11.1.8

    Severity: 

    Categories: 

    Abstract:  qmf1118_ee_win32_fixpack

    README_WebSphere

    README_Workstation

    This is no longer the case so I wrote to the developers when I saw your question and asked them for the list. 12.2.0.3 is cumulative so it has all the fixes and enhancements from previous fixpacks. While I wait for a response, is there a particular issue that I can check on for you?

    ------------------------------
    shawn sullivan
    ------------------------------

    Original Message


  • 6.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/24/20 11:05 AM

    Hi Shawn,

    Not specifically, but as you stated, as far back as I can recall there was always a list included in the readme file.
    I was searching the web for a fix list or what's new listing but could not find anything, hence the question.
    I'm also a little confused why fixpack 2 and 3 for DB2 Query Management Facility Enterprise Edition were released on the same date September 3rd.
    Besides that I was expecting fixpack 2 much, much earlier, it raised the question if they maybe were the same….

    And, knowing what's been fixed might influence the decision or schedule to apply the fixpack.

    Regards
    Sven



    ------------------------------
    Sven Heidorn
    ------------------------------

    Original Message


  • 7.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/25/20 08:28 AM
    Sven
    fixpack 2 was posted to fix central on January 16
    Fixpack 2 Release dateand fixpack 3 was released on August 31
    fixpack 3 release
    It may  be that the way you get to them is a bit tricky. You must select 12.2 as the install version to see them. If you select 12.2.0.1 it gives you no results. I still await the response from dev.


    ------------------------------
    shawn sullivan
    ------------------------------

    Original Message


  • 8.  RE: QMF 12.2.0.3 Fixpack

    Posted 09/30/20 09:26 AM
    Hi Shawn,

    well I don't have a z/Os entitlement so I use a different path in Fix Central, under DB2 Query Management Facility Enterprise Edition, the fix packs are published on the same day.

    Regards
    Sven

    ------------------------------
    Sven Heidorn
    ------------------------------

    Original Message


  • 9.  RE: QMF 12.2.0.3 Fixpack

    Posted 10/14/20 08:51 AM
    Sven IBM has now posted the readme with the list of fixes and enhancement and will do this moving forward for other fixpacks.

    ------------------------------
    shawn sullivan
    ------------------------------

    Original Message


Related Content