IBM Support

PK30104: THREAD HISTORY ZHTCALL DYNAMIC SQL STATEMENT FROM WRONG THREAD

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

  • Thread History Dynamic Sql Calls display ZHTCALL. Inquiry
displays valid sql statement but, sql is from different thread.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM  user.          *
****************************************************************
* PROBLEM DESCRIPTION: WRONG SQL STATEMENT ON NTH PANEL        *
*                      ZHTCALL                                 *
*                                                              *
****************************************************************
* RECOMMENDATION: APPLY THIS PTF.                              *
****************************************************************
INVALID KEY IS USED TO COLLECT V8 DYNSQL W/O ROLLUP SETTING

    



Problem conclusion


    

  • COLLECT DYNAMIC SQL STATEMENT USING THE CORRECT KEY FOR
DB2 V8 DISTRIBUTED THREAD.

KEYWORDS :ZTHCALL NTH DISTSERV ACCUMACC SQL STATEMENT INCORROUT

    



Temporary fix


    

  • 



Comments


    

  • ×**** PE07/06/15 FIX IN ERROR. SEE APAR PK47224  FOR DESCRIPTION

    



APAR Information




    

  • APAR number
    PK30104
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    310
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2006-08-17
    • 

  • Closed date
    2006-10-26
    • 

  • Last modified date
    2007-11-22
    • 





    

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

    
OA17619
    

    • 

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

    
UK19137 UK19138 PK33782
    

    • 



Modules/Macros


    

  •    KO2ACAPA KO2ACAPS KO2ACAP2 KO2CMVSC KO2CMVSF
KO2CNSRB KO2CNTPA KO2CNTPS KO2CNTP2 KO2DAUDA KO2DAUDS KO2DAUD2
KO2DDSBA KO2DDSBS KO2DDSB2 KO2DMSCA KO2DMSCS KO2DMSC2 KO2DTHDA
KO2DTHDS KO2DTHD2 KO2DXSTB KO2DXS1A KO2DXS1S KO2DXS12 KO2DXS2A
KO2DXS2S KO2DXS22 KO2HDTIB KO2HDTPB KO2HINTB KO2HPRCB KO2HPR1B
KO2HPR2B KO2HSQIB KO2HSQPB KO2HVINB KO2HWLMB KO2ICOLA KO2ICOLS
KO2ICOL2 KO2IINTB KO2LCAPB KO2OH2IB KO2ONTAB KO2OTCCB KO2OTCIA
KO2OTCIS KO2OTCI2 KO2TSB1B KO2TSB2B KO2TSB3B KO2TSB4B KO2WGETB

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R310  PSY  UK19137
       UP06/10/31  P  F610
    • 

  • R410  PSY  UK19138
       UP06/10/31  P  F610
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            31 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback