IBM Support

JR44699: "$ADMINTASK BPMDELETESNAPSHOT" CAN'T DELETE SNAPSHOT WITH LARGE NUMBER OF INSTANCES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • On PS single cluster Envrionment, for snapshot R1_1, there are
about 67326 completed instances.

The database transaction log is large enough, about 4G totally.
 db2 update db cfg using LOGFILSIZ 32768
 db2 update db cfg using LOGPRIMARY 30

When trying to use "$AdminTask BPMDeleteSnapshot" to delete the
snapshot R1_1, the snapshot and related instances can't be
deleted even after 2 hours execution.

This APAR is superceded by JR44937.

Local fix

  • 



Problem summary


    

  • Problem Description:
When using the BPM AdminTasks 'BPMProcessInstancesCleanup' and
'BPMDeleteSnapshot' a timeout may occur and the commands may
fail.

Problem Summary:
The stored procedure used underneath to carry out BPD instance
deletion is inefficient and needs refactoring. It does
superflous
updates to the temporary groups tables per deleted bpd instance
and was designed for single instance deletion only.


Problem Conclusion:
This fix replaces the stored procedure with explicit JDBC calls
better suited for bulk operation. It postpones the orphan task
temp group deletion to be run once only
after all bpd instances have been deleted. Further the
associated tasks will be deleted using batch update taking into
account that there are likely many task entries per bpd
instance.

    



Problem conclusion


    

  • Problem fixed
iFix available on top of V801 GA

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR44699
    • 

  • Reported component name
    BPM STANDARD
    • 

  • Reported component ID
    5725C9500
    • 

  • Reported release
    801
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-11-12
    • 

  • Closed date
    2013-02-04
    • 

  • Last modified date
    2013-02-23
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    BPM STANDARD
    • 

  • Fixed component ID
    5725C9500
    • 



Applicable component levels


    

  • R801  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            23 February 2013
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback