IBM Support

JR62766: THE UPGRADESCHEMA_PROCESSSERVER.SQL DATABASE SCRIPT FAILS ON IBM Db2 FOR Z/OS DATABASES

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.

Direct links to fixes

workflow.20002.delta.repository
8.6.20020001-WS-BPM-IFJR62766

 

APAR status

  • Closed as program error.

Error description

  • If you are upgrading to IBM Business Automation Workflow
V20.0.0.1 with IBM Db2 for z/OS, the
upgradeSchema[version_number]_ProcessServer.sql database script
might fail with an error similar to the following message:

call sysproc.admin_cmd('reorg table
@SCHEMA@.BPM_HISTORICAL_DATA_PLAYBACK')
This statement produces the error:
Exception: [IBM][CLI Driver][DB2] SQL0440N No authorized routine
named "SYSPROC.ADMIN_CMD" of type "" having compatible arguments
was found. SQLSTATE=42884 SQLCODE=-440

Local fix

  • Remove all the reorg table sqls from the
pgradeSchema[version_number]_ProcessServer.sql script and run
the database script again.

Problem summary

  • No additional information is available.

Problem conclusion

  • A fix is available or will be available that ensure the Db2 z/OS
 scripts run successfully.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR62766
    • 

  • Reported component name
    BUS AUTO WORKFL
    • 

  • Reported component ID
    5737H4100
    • 

  • Reported release
    K00
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-09-01
    • 

  • Closed date
    2020-11-09
    • 

  • Last modified date
    2020-11-09
    • 





    

  • 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
    BUS AUTO WORKFL
    • 

  • Fixed component ID
    5737H4100
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            14 December 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback