IBM Support

PI78750: DB2 SHUTDOWN HANG

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

  • STOP DB2 ended up hanging, since the DB STOP/START asynchronous
task count was none zero. DB2 checkpoint system task
020.CHEKPT03 is suspended in DSNTRCKW due to the non-zero
asynchronous task count :

ACOMRECC     +3

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* All DB2 V12 for z/OS Administrators that                     *
* execute STOP DB2 command.                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* STOP DB2 hang due to a non-zero                              *
* asynchronous task count.                                     *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
The asynchronous task count was used widely across different
components. Therefore, when those asynchronous agents were gone,
it was hard to keep track which module did not decrement the
task count correctly.

    



Problem conclusion


    

  • The asynchronous task count will not be used to serialize STOP
DB2 with any asynchronous tasks. Instead, it will only be used
as counter for LPL/GRECP recovery.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI78750
    • 

  • Reported component name
    DB2 OS/390 & Z/
    • 

  • Reported component ID
    5740XYR00
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    YesHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-03-23
    • 

  • Closed date
    2017-05-08
    • 

  • Last modified date
    2017-06-02
    • 





    

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

    
PI75337
    

    • 

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

    
UI47082
    

    • 



Modules/Macros


    

  • DSNTDMST DSNTADL  DSNUZLCR DSNTDSTP DSNB1PCK DSNILSTS DSNIAGBR
DSNISREC DSNTRCKW

    



Fix information


    

  • Fixed component name
    DB2 OS/390 & Z/
    • 

  • Fixed component ID
    5740XYR00
    • 



Applicable component levels


    

  • RC10  PSY  UI47082
       UP17/05/24  P  F705  ¢
    • 



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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 June 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback