IBM Support

PK19254: POOR PERFORMANCE IN QMF V8 WHEN IN TABLE EDITOR

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Users encounter poor performance when using the EDIT TABLE
feature in QMF V81.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: All QMF for TSO and CICS V810 users.         *
****************************************************************
* PROBLEM DESCRIPTION: Poor performance is experienced when    *
*                      using QMF with DB2 V7 or V8             *
*                      compatibility mode databases.           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The performance problem occurred because indexes (a non-matching
index scan) were not being used during the execution of static
SQL in DB2 V7 and DB2 V8 compatibility mode databases. There
were incompatible data types between QMF host variables and
base table database definitions. This data type incompatiblity
caused DB2 to not use indexes.

    



Problem conclusion


    

  • QMF code was changed to fix database performance problems
in the EDIT TABLE, prompted query column describe, stored
procedure verification, and stored procedure parameter
checking functions performed by DSQISDB2.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK19254
    • 

  • Reported component name
    QMF-QUERY MGMT
    • 

  • Reported component ID
    566872101
    • 

  • Reported release
    810
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2006-02-06
    • 

  • Closed date
    2006-02-21
    • 

  • Last modified date
    2006-03-02
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    
UK12001
    

    • 



Modules/Macros


    

  • DSQCBRDI DSQESDB2 DSQESDB8 DSQISDB2 DSQISDB8
DXECDATA DXEISDB8

    



Fix information


    

  • Fixed component name
    QMF-QUERY MGMT
    • 

  • Fixed component ID
    566872101
    • 



Applicable component levels


    

  • R810  PSY  UK12001
       UP06/02/27  P  F602
    • 



Fix is available


    

  • Select the PTF appropriate for your component level.
You will be required to sign in. Distribution on physical
media is not available in all countries.
    








      
              
                            

              

              [{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 March 2006
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback