IBM Support

PH72137: HAA-TO-DAJ MIGRATION: SQL ERRORS OR DATA CORRUPTION CAN OCCUR WHEN MIGRATING PROFILES FROM HAA V3.1 OR OLDER

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

  • When migrating profiles from IBM Db2 Automation Tool (HAA) to
IBM Db2 Automation Expert (DAJ), SQL errors or data corruption
can occur. This bug may be present when migrating from an HAA
environment that was originally deployed at an older version,
typically HAA V3.1 and older.

The fix will be implemented in the TCz B1TOPInn (Migrate
AUTOTOOL Profiles) generated jobs for each Db2 SSID.

Local fix

  • N/A

Problem summary

  • ****************************************************************
* USERS AFFECTED: All users                                    *
****************************************************************
* PROBLEM DESCRIPTION: When migrating profiles from IBM Db2    *
*                      Automation Tool (HAA) to IBM Db2        *
*                      Automation Expert (DAJ), SQL errors or  *
*                      data corruption can occur. This bug may *
*                      be present when migrating from an HAA   *
*                      environment that was originally         *
*                      deployed at an older version, typically *
*                      HAA V3.1 and older. The fix will be     *
*                      implemented in the TCz B1TOPInn         *
*                      (Migrate AUTOTOOL Profiles) generated   *
*                      jobs for each Db2 SSID.                 *
****************************************************************
* RECOMMENDATION: APPLY the PTF                                *
****************************************************************
.

Problem conclusion

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH72137
    • 

  • Reported component name
    AUTOMATION EXPE
    • 

  • Reported component ID
    5698DAE00
    • 

  • Reported release
    110
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2026-07-07
    • 

  • Closed date
    2026-09-02
    • 

  • Last modified date
    2026-10-02
    • 





    

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

    • 

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

    
UO09231
    

    • 



Modules/Macros


    

  • DAJTOPID

    



Fix information


    

  • Fixed component name
    AUTOMATION EXPE
    • 

  • Fixed component ID
    5698DAE00
    • 



Applicable component levels


    

  • R110  PSY  UO09231
       UP26/09/04  P  F609
    • 



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":"BU048","label":"IBM Software"},"Product":{"code":"SSSXEC9","label":"IBM Db2 Automation Expert for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"110","Line of Business":{"code":"LOB70","label":"Z TPS"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 October 2026
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback